Greetings, Gurus.
A search of the forum gave me most of the code I need, I just need some help with modification. The code below opens a window which allows the user to select a file to open. Apparently, it starts in the directory of the file containing the macro. How would I modify this to open in "M:\Archived PO Responses\Processed\"?
Thanks in advance for any help you can offer.
Please Login or Register to view this content.
Hutch
Last edited by hutch@edge.net; 10-23-2008 at 11:23 AM.
Found it! I just needed to add the ChDir line before the GetOpenFilename. Here's the code that worked:
Have a good one.Please Login or Register to view this content.
Okay, I was wrong. This isn't solved.
Adding the ChDir line worked on my computer, but for some reason when I runt he macro on another computer, it still defaults to the My Computer directory when the select file dialog opens up. Is there another line I need to add, or what?
This worked on the other computer:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks