Hi, I'm trying to create a macro that will open an excel file from an action button. the code would need to do the following:
1. Open a file stored at a designated location
2. If the file has been moved, the user would need to be prompted to navigate to the new file location
3. the new file location would then become the default location.
What I have so far is this:
If any one can help that would be much appreciated!Please Login or Register to view this content.
Thanks!
Bookmarks