Results 1 to 2 of 2

Thread: calling an excel macro from an access database that refers to that database

  1. Mar 6th, 2006, 07:01 AM #1
    jimmyp
    jimmyp is offline

    Thread Starter
    New Member
    Join Date
    Mar 2006
    Posts
    5

    calling an excel macro from an access database that refers to that database

    hi

    i have a macro in excel that inserts some values into a table in a database in access, but i want to make it so i dont have to touch the excel file, instead i have a module in the access file that calls the sub in the excel file, but then i get an error saying that the database is already open....is there a way of getting around this?

    thanks

    jimmyp
    Reply With Quote Reply With Quote
  2. Mar 6th, 2006, 07:05 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: calling an excel macro from an access database that refers to that database

    Moved to Office Development
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width