Excel Macro to Call Access Macro [Archive]

View Full Version : Excel Macro to Call Access Macro

ssmieszek

08-11-03, 17:08

Trying to code in VBA to have a command button go to an Access D-base and have it run a macro. Have been messing with SENDKEYS, but it is a pain. Any other thoughts?

qha_vn

08-12-03, 02:29

how about use excel macro just to open the acess file and the codes in access will run automatically in the start up form.

hope this helps

ssmieszek

08-12-03, 17:22

Thanks - That should work fine. Another question - I am overwriting a text file and want to disable the prompt that asks if you want to save. What is the code for that?

qha_vn

08-12-03, 22:33

if you use SFO (file system object) to save the text file, its has an option to depress the overwrite prompt. if not, can you tell us how you do that.

cheers