Problem With Opening and Closing A Workbook In VBA Using a Range Name In The Active W

**John Vieren** · 12-28-2009, 03:14 AM

Hi

Thanks for reading my post.

I am trying to open and close a workbook from an active workbook but my code has a bug which i can figure out.

Your help is appreciated, thank you.

Please Login or Register  to view this content.

**Marzuk** · 12-28-2009, 03:19 AM

Is Current_File_Location a named range that refers only to a single cell? I'd check to see what path is being provided to the Workbooks.Open() call before I checked anything else.

**John Vieren** · 12-28-2009, 03:24 AM

Hi,

Yes t is a single cell.

I have it looking at a blank file in C:\ drive.

I enclosed the workbook for analysis.

Thanks for your help

**teylyn** · 12-28-2009, 03:37 AM

John, if this is basically the same question as your other post, you should mark the other thread as solved so that nobody spends any more time on it.!

**John Vieren** · 12-28-2009, 03:42 AM

Hi,

Other post not solved and this is a different attempt of mine to solve the same problem.

I did not want to make it to confusing by putting more into the other post.

But i will mark the other post as closed if you like.

Sorry if I make mistake, thanks John.

**teylyn** · 12-28-2009, 04:01 AM

If you don't mark the other post solved, -- and fast! -- this one will be considered a duplicate post and I'll close it. Especially with regards to

this is a different attempt of mine to solve the same problem.

Feel free to add a note that the problem continues to be discussed here in this thread, after you've marked it solved. that should avoid confusion and duplicate efforts of our volunteers.

cheers

**davesexcel** · 12-28-2009, 09:22 AM

Try to use this code to work with your existing code.
http://support.microsoft.com/kb/147742

Problem With Opening and Closing A Workbook In VBA Using a Range Name In The Active W

LinkBack

Thread Tools

Rate This Thread

Display

Problem With Opening and Closing A Workbook In VBA Using a Range Name In The Active W

Re: Problem With Opening and Closing A Workbook In VBA Using a Range Name In The Acti

Re: Problem With Opening and Closing A Workbook In VBA Using a Range Name In The Acti

Re: Problem With Opening and Closing A Workbook In VBA Using a Range Name In The Acti

Re: Problem With Opening and Closing A Workbook In VBA Using a Range Name In The Acti

Re: Problem With Opening and Closing A Workbook In VBA Using a Range Name In The Acti

Re: Problem With Opening and Closing A Workbook In VBA Using a Range Name In The Acti

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions