Question on query source and set up of workbook

ardykav

Board Regular
Joined
Oct 18, 2015
Messages
102
I have a workbook with several tabs.

One tab is called master.

I then have another tab called summary sheet.

On the summary sheet i have several tables which are all queries looking into the master tab.

This is all on one computer and works fine. however if i want to put it on a usb the queries dont work due to the directories not being the same. My question is what is the best way going about changing the directory so it all works without any problems? Any alternate suggestions on set up also welcome,

All help greatly appreciated,

thanks
 

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
11,403
Office Version
2013
Platform
Windows
I have a workbook with several tabs.

One tab is called master.

I then have another tab called summary sheet.

On the summary sheet i have several tables which are all queries looking into the master tab.

This is all on one computer and works fine. however if i want to put it on a usb the queries dont work due to the directories not being the same. My question is what is the best way going about changing the directory so it all works without any problems? Any alternate suggestions on set up also welcome,

All help greatly appreciated,

thanks
The short answer is that you would either use a shared workbook loaded into a directory on a server, or write the code so that individual users could use their default directory to store the file and use a variable to assign that directory at the beginning of the code with ThisWorkbook.Path. How to go about it would take too much space on this media. You can probably search around on the web and find some articles on setting up files on LAN that will give you an idea.
 

ardykav

Board Regular
Joined
Oct 18, 2015
Messages
102
Thank you very much that is of great assistance.

I will go with the shared workbook option,

thanks again
 

Forum statistics

Threads
1,084,878
Messages
5,380,415
Members
401,673
Latest member
Ali Balleya

Some videos you may like

This Week's Hot Topics

Top