Hi, I am currently running several queries in a worksheet from a specified folder. I am using a program that loads the worksheet then saves it to a different folder (for zipping & emailing) so I'm trying to find if there is anyway in which I can change the location of the database to the location that the worksheet is to be saved.
Any help or suggestions would be much appreciated.
Thanks in advance
Do you mean Access database?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi, No its a selection of DBF files that are generated from another (DOS) program and I use the excel worksheet to generate reports for clients.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks