Grizlore
Active Member
- Joined
- Aug 22, 2006
- Messages
- 259
Hi,
I have a spreadsheet, which will be saved somewhere on our company's external drive on another site. I do not know where this will be and this could change.
This spreadsheet was planned to be copied automatically into one of my drives and then imported into another spreadsheet. However as this files has all kinds of Macros, I think it would be easier to, at the time of savng, have the initial master spreadsheet save a text file version of the required data next to it in the same folder.
So my question to you guys.....
How do i find where a file is saved (eg \\server1\public\Department\Its_here\) as i would need that to enable this text file to be saved in the same folder, wherever this file goes.
Any help would be appreciated
I have a spreadsheet, which will be saved somewhere on our company's external drive on another site. I do not know where this will be and this could change.
This spreadsheet was planned to be copied automatically into one of my drives and then imported into another spreadsheet. However as this files has all kinds of Macros, I think it would be easier to, at the time of savng, have the initial master spreadsheet save a text file version of the required data next to it in the same folder.
So my question to you guys.....
How do i find where a file is saved (eg \\server1\public\Department\Its_here\) as i would need that to enable this text file to be saved in the same folder, wherever this file goes.
Any help would be appreciated