Search results for query: *

LOL. You don't have time for a project but have time to read? I guess you're a learn-by-book type, of which I keep trying but fail miserably so I go with hands-on. From your user name, I take it you want to learn programming in general but also in VBA. That's gonna be a huge time consuming...

Bug fixing in what environment? I'm assuming not VBA. Then, what's your current knowledge base and background? I started VBA pretty recently and it was out of a need to do something more with Office. I learned C/C++ in school 10 years ago but didn't go into an IT field. Recently at my work, I...

Ok thank you. will play with it.

which kinda brings me to the next question... When I open the Word file first then open the excel file, it locks the excel file so that I get a msg like "you can only open in read-only mode". Well... to add capability for user to update excel file anytime he/she wants to and also to not have the...

Thanks Skip. That first sentence clears a lot of smoke. The word resultset really hit home. I guess I was wondering when that event "merge" actually took place. Although that Excel file itself is really not updated when using the word file and user at a time only works on a small subset of data...

or is it because the "merge" event doesn't actually happen then?

Ok, I tried using MailMergeAfterRecordMerge but it doesn't seem to trap the event. This is what I did: in "ThisDocument", I have the following code Dim X As New EventClassModule Private Sub Document_Open() 'Call Register_Event_Handler Set X.App = Word.Application end sub and in a...

Hi all, I have looked everywhere on the web to no avail. So here I am and I'll try to explain the problem as clearly as possible. I have a doc file with merge fields and when the doc file opens it links to an excel file to get the data (excel file is not opened in any event). I also disabled...