Get external Data questions

[ammaddon]

Hi folks, great forum. I have a few questions that I need answered. I have a program that is generating a nightly report in .csv format. I then have a workbook that is taking that csv file and appending the information to it VIA "get external data". Also have it set that it automatically refreshes upon opening of file. Heres the issue. I have multiple machines that need to access this workbook and have the ability to refresh the data. However, the get external format holds my directory information for the local machine so when the clients attempt open the workbook they get an invalid path. One solution I was thinking of doing was creating stand alone workbooks on each machine that had mapped drive to the file, but that is a redundant solution and poses a mulitple data source issue. Ideas?

Part B
The information being collected is the water temps for based upon date and time. Layout is Column A: Date Column B: Time and Column C: Temp.
When the refresh runs it appends the info to the workbook. What I would like to do is within the same workbook, on a second sheet is have a query available based upon date that will show all temps for that date or date range. The date or date range being defined by the customer. Ideas?

Thanks ahead of time......

 

[Cbrine]

Ammaddon,
Here a quick suggestion. Don't put the file in that folder to begin with. Maybe add it to the windows temp folder, or just create a folder in the base C; folder

C:\Data

You will need to create the folder on each machine, but since it's not in the Documents and Settings folders, you won't have the user name varibliity effect the path.

HTH
Cal

 

[ammaddon]

thanks for the reply Cbrine, but the issue is not from different logged on users. It's multiple machines on a network accessing a shared folder on the report generating machine. So the path for the generating machine is local and the path for the others is mapped

 

[Cbrine]

ammaddon,
How about this. Create a mapping on the generating machine pointing to the share on the generating machine as well as the others.(Seems strange, but it will work). Link to the files on the shared folder on the generating machine, that way you won't need to worry about changing local paths to network paths, since they all will have network paths.

HTH
Cal