Opening protected files with macros

**aresquare1** · 04-30-2013, 05:41 AM

URGENT PLEASE HELP

I have two macro-enabled workbooks that I have attached for reference. The file called Dest (for Destination) reads cells from the file Source. This file is to contain a button that opens the source file by reading the file path\name from G5 and reading the password from M2. The path\name for the Source file is shown in G5 in the Dest file. This code worked when both file were in the same desktop directory but when I put them in different directories on my work server it can’t open it.

How do I need to change the code to make it work?

Thanks, as I REALLY would appreciate you help.
RR

**TMS** · 04-30-2013, 06:12 AM

I might be missing something here, but you need to give it the full path to the location where the file is now, rather than pointing to your desktop.

So, just change G5 to the right location. Works for me, picking up the Source file from my Downloads folder. Or, if the location is not fixed, add a File Open dialogue box.

Regards, TMS

Opening protected files with macros

LinkBack

Thread Tools

Rate This Thread

Display

Opening protected files with macros

Re: Opening protected files with macros

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions