Replies

Thank you so much RG!!

This is what I was looking for Thanks a tonne !!
This works perfectly fine, however, I observed that it highlights even when the cell is simply double clicked, when no text is either entered or removed. Can Excel in any way detect this as well, whether its just a double click or actually clicked for editing purpose ?

Sorry for asking an obvious question, as I am a novice to Excel VBA programming.
I want that whenever anyone updates any cell of column B, the complete row should be highlighted with yellow color.

That’s why asking if we can scan the complete column to find out the particular cell that got updated.

Would request if you can provide the code as well. I have googled a lot but nothing is coming out as per my requirement.

Thanks.

how can i detect if something has changed in the range of cells ?

Hello Steve,

I managed to put the condition, that is, when Column B is filled the application prompts to enter the value in corresponding C and D cells.

Now I want that whenever the Column B value changes, the prompt for filling the issue no. and version should again be prompted.

In current scenario, it works only when I deleted the content but if I edit the value by double clicking the cell, the prompt does not come.

Can you help on this, please ??

Thanks,
gurpreet

Sorry for not being clear in my previous posts.

My requirement is when the ObjectID is updated, the Version and Issue no. columns corresponding to the ObjectID should ALSO be updated.

Since we are already using this report, I observed people forget to update the version and Issue no., that is why to ensure that both of these are also updated I thought if there can be a macro for this.

For example:
If the user changes the value in B2, he should also change the corresponding C2 and D2 cells.

P.S: There could be a scenario where objectID does not change at all but if it gets changed, the other two columns that is, issue no. and version should also be changed.

Thanks for you reply, Steve!!

By enforced, I meant that as and when the content of “ObjectID” field is changed, the person should be forced to also update the “Issue No.” and “Version” fields without which should not be allowed to save and close the Excel file.

There is a addin on the MS site called CSV File Creator, don’t konw if will help, but its woth a try.
http://office.microsoft.com/en-us/marketplace/csv-file-creator-for-excel-EM010277030.aspx?redir=0

Tom Duthie

Thanks, Tom for the pointer !!

This is exactly what I am looking for, but I will need to buy it to get the full functionality.

This trial version does eliminate the deliminator issue but does not accept any modified file.
Meaning, if I modify the CSV file before using this Add-in, it gives an error

Probably will have to search more on this ….

thanks again !!

Thank you ALL for the support !!

I found that the report, I was using to create the Database was corrupt, which is why it was not allowing the query to run successfully

Thanks again and have a Nice day !!

regards,
gurpreet

Assuming the following table structures

Complete_Report
ID (Long Integer)
WriterName (Text)

For_Processing
ID (Long Integer)

The Query Should read:

SELECT For_Processing.ID, Complete_Report.WriterName
FROM Complete_Report INNER JOIN For_Processing ON Complete_Report.ID = For_Processing.ID

Pay particular attention to the Data Types in the tables as the data types on the Join Fields need to be the same.

Bob Oxford

I assume that you want to compare D to L, E to M and F to N. So it’s simply a matter of comparing pairs of columns.

See the attached version:

Hi,

Want to thanks the querier and the answerer, as I was looking for the same solution .

Thanks !!

You would be far better off with one or more of these resources:

http://www.klariti.c…ker/index.shtml

http://forums.adobe….nity/framemaker

Finally, there is a Framers’ List–an email list of FrameMaker users, where you can ask specific questions and knowledgeable folks should be around to answer your question quickly:

http://lists.frameus…istinfo/framers

I’m a former tech writer, but as my history with Frame recedes farther into the past I would only be guessing to try to help, I’m afraid, as I no longer have a copy of it installed–and the last version I used was 6 IIRC.

Good luck getting your question sorted out!

No, problem .. I will try the sites you shared:):…
Thanks for the pointers !!

I’ve moved your question from General MS Office Suite to Word, since it is specific to Word.

The “Select All” button in the Styles and Formatting task pane is only enabled if the check box “Keep track of formatting” in the Edit tab of Tools | Options… has been ticked. If this check box is clear, the “Select All” button will be disabled.

“Available formatting” is only listed in the Show dropdown list at the bottom of the task pane if the “Keep track of formatting” check box mentioned above is ticked. “Custom…” is only listed if that check box is clear.

Thank you for the quick response. I can proceed further now

You could run this macro:

Code:

Sub Test()
  Dim varObj As Variant
  Dim n As Integer
  For Each varObj In ActiveDocument.InlineShapes
	If varObj.Type = wdInlineShapeEmbeddedOLEObject Then
	  n = n + 1
	End If
  Next varObj
  For Each varObj In ActiveDocument.Shapes
	If varObj.Type = msoEmbeddedOLEObject Then
	  n = n + 1
	End If
  Next varObj
  MsgBox "This document contains " & n & " embedded object(s)", vbInformation
End Sub

Thanks, Hans !! this is really helping…Please accept a BIG thanks from my complete team

If you use reveal formatting, you’ll see that your section has a border “Right (shadowed Custom, Custom color (RGB (0,0,78)), 0.85 pt, Margin: 2 pt)”

Delete that and you’re good to go.

Pam

Thank you so much , Pam !! I was stuck with this problem from last 2 days, but this solution worked out
I really appreciate your time and effort for helping me out.

Once again would like to give a BIG Thanks !!

The horizontal line is part of the definition of the Heading 1 style (it’s a bottom paragraph border). But perhaps you meant the vertical line?

Sorry !!. I actually meant to say vertical line …

Could you attach a small sample document that demonstrates the problem? Remove most or all text from the document.

Sure, please find attached the file.