Search results for query: *

Hi Russ, Ditto for me - we have the exact same problem, with no option of re-installing MS Office. Have also encountered this at other companies, and have no idea how to resolve the issue other than re-open it etc. Which is a pain as my users keep forgetting this and are raising support...

Thank-you!! Stars for you all...... :o)

Hi, I have found something similar to this, but refering to MS Word, and as i have never coded in Word, am not sure how to extrapolate the code and change into an Excel reference etc. Basically I have worked out the code to loop through each cell in a specific range. However, assuming I am...

Thank-you!! Am sure will be of great help... Star for you!

Yes, I think that is the way I will have to go. Could you please post the code - me being lazy!! Many thanks for all your help! Victoria

Thanks for that JR. Can I change the registry to accept a ".***" ending as the F16 denotes a date and it will change daily. Or does each type need to be hard coded. Thanks Victoria

Try searching in the Microsoft VBA forum. There are a number of entries that display how you could do this - using different methods, including some complete with code to print out a spreadsheet containing all the differences. Victoria

Hi, I have been asked to help with a db conversion from NT & v97 to XP & v2000/2. Prior to converting the db, the team used to import a text file with a .F16 (The exact ending will be determined by the date, so I cannot hard code .F16 as an option) file ending, which is a text file. However...

Wondering if anyone can throw any light on to the following. We have an organisation chart in a Word 97 documant. When viewed via NT and Word 97, looks fine, and can be edited correctly via the org chart editing functionality in Word 97. However we have recently upgraded to XP and 2002. Now...

Tony, Sorry I didnt get back to you yesterday, all got a bit crazy here in the afternoon - XP migration!!! Your final post has done the trick - THANK YOU!!! :o) Star from me!!! Victoria

Ooops!! I should also mention that column L refers to the column containing the "Match" data/values Thanks Victoria

Tony, OK, here is some additional examples - sorry!! Below you will see an entry where the value is "330". There are no matched vlaues or multiple entries of that value. In my version of the formula I flag the value as 1 sided if the cell above does not match...

Tony, Many thanks for that - it works except for one thing. It now highlights them all as Multiple and I am loosing the option to pick out if the entry is "One Sided", i.e. it is a single entry, as per my previous IF statements. I am trying to incorporate the two, but having a few...

I'm not sure if this is the correct forum, but thought would give it a try. I am trying to write some formula's into a spreadsheet (that will eventually be automated). What I am trying to do is pick up where there are multiple entries of the same value, but the number of times it appears is an...

Had a feeling that was the answer!! ;o) Thanks for your help though!

I am new to VBA within Business Objects, but in the absence of any other replies thought I would through a suggestion into the ring! There is a Boolean Documents.AutoRefreshWhenOpening option, which you could make false. Let me know if you do find a solution that works! Victoria

Can anyone recomend a book that would help me develop my Business Objects Reports using VBA. I have been using Business Objects and now Webi for a few years, along with designing some universes, and have used VBA within Acces and Excel, but would like to combine the two. I have not been able...

Thanks for that. Both solved the error - thanks. Actually used Matts answer though as it got round another "subscript out of range" error I was experiencing. Clearly trying to be too clever for my own good! Thanks again! Victoria

Hi there, I am trying to assess the worksheet that the macro should obtain a cell value from. Basically the Workbook in question could have a number of hidden worksheets at the beginning, either 1 or 2. The information I need is stored in the first visible worksheet. As I not that...

Thank-you - should work a treat!! Victoria