A question on opening Word with Access on late binding basis

Mike375

Registered User.
Local time
Tomorrow, 08:32
Joined
Aug 28, 2008
Messages
2,548
I have managed to alter code I use to open Word, insert Access data to Bookmarks and do a SaveAs with date/time and without needing the reference to Micosoft Word 11 Object Library.

The references I have are

Visual basic For Applications
Micosoft Access 11 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft Active X Data Objects 2.5 Library

These are ticked by default when starting a new DB in my A2003

I have also managed to get Runtime A2007 to run what is made in A2003 but I don't have any are office versions except A2003.

So my questions is:

Should I be OK with the runtime A2007 running what was created in A2003 so as to do Word on versions of Office that are not 2003/11. I assume it will be OK but I can't test it at the moment.
 
I had forgotten about my Office 95. I put that on except Access and made a Word doc with the appropriate bookmarks.

Clicking on the code on the A2007 Runtime, nothing happened. So put the code behind a text box and "clicked" and the cursor just kept blinking as normal as opposed to freezing while things transpired.

I changed the name of the Word doc so it did not match what was in the code, same result, nothing, no debugs, boxes popping up etc. just nothing.

I use to use different code for Access/Word/Bookmarks when I used A95 perhaps that is needed but I think it is Visual Basic and not Visual Basic for Applications.
 

Users who are viewing this thread

Back
Top Bottom