I’m currently writing a macro in Excel 97 that retrieves and stores data in two different, but changing folders, so I need to be able to let users change the working directory easily (ChDir – command). So i need to either:
1) Set the working directory by a explorer window or something similar
2) be able to pop-up the Save as window when saving a workbook from VBA
Any suggestions??
