Paperclipper
Board Regular
- Joined
- Mar 11, 2004
- Messages
- 110
Hi everyone. I'm trying this out for the first time...
I have a spreadsheet that pulls in data from other sheets (the source datafiles). In this summary sheet, I have a listbox that can do scenario analyses.
So I need two macros:
1) opens the associated source datafiles the first and only the first time that I execute the macro, since the files will be left open in case there are more recalculations (bearing in mind that this file will be used on different computers so the path should point to the current directory that the summary sheet has been saved to, and thus NOT a full programmer-specified path, and NOT a user-defined one either.)
2) closes the associated source datafiles without saving them
Thank you all very very much!
I have a spreadsheet that pulls in data from other sheets (the source datafiles). In this summary sheet, I have a listbox that can do scenario analyses.
So I need two macros:
1) opens the associated source datafiles the first and only the first time that I execute the macro, since the files will be left open in case there are more recalculations (bearing in mind that this file will be used on different computers so the path should point to the current directory that the summary sheet has been saved to, and thus NOT a full programmer-specified path, and NOT a user-defined one either.)
2) closes the associated source datafiles without saving them
Thank you all very very much!