Question on query source and set up of workbook

[ardykav]

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]

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]

Thank you very much that is of great assistance.

I will go with the shared workbook option,

thanks again

 

[JLGWhiz]

Thank you very much that is of great assistance.

I will go with the shared workbook option,

thanks again

You're welcome,
Regards, JLG