Global variable using automation

a) why would you want to get a value from another app.

b) you probably need to do some programming in the first app - can you not save the value in the registry, (probably the easiest) - then you can just read it from there
 
Re: Insert a module via VBA code

Why not just export a new module to the database:
Code:
DoCmd.TransferDatabase acExport, "Microsoft Access", "YourPathAndFileNameToSendTo", acModule, "ModuleNameHere", "ModuleNameThere"
Ah, I see where you're coming from.
 
Thanks vbaInet - that works perfectly. I didn't know about the VBA extensibility library. Looks quite cool. Powerful stuff! Do you know of any further documentation on the library?

Thanks as well Bob.
 

Users who are viewing this thread

Back
Top Bottom