I have an xlsm file that's used as a template on sharepoint. Needs a little description...
Users can navigate to their respective folder, hit a "New" button that opens it on their pc (unsaved), and when they save it, the Save As dialog opens already pointed at the sharepoint folder they were in when they hit "New".
This is fine, except that it defaults to saving as xlsx instead of xlsm, and has become a nuisance for the users. To fix that, I added code that forces it to save as xlsm, but now it just wants to save in their local My Documents folder instead of the sharepoint folder.
How do I pass that sharepoint/web folder to my code so the Save As dialog defaults to the correct folder? It's dynamic (based on where the user last navigated), so I can't just hard code "http://whatever...". Again, Excel knows that folder path normally (even if I close IE, so it's stored somewhere in Excel or the registry), but doesn't know with my code in the way.
Thanks!
Bookmarks