Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    4

    Unanswered: Excel Macro to Call Access Macro

    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?

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    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
    qha_vn

  3. #3
    Join Date
    Jun 2003
    Posts
    4
    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?

  4. #4
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    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
    qha_vn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •