LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
dk_ dk_ is offline
external usenet poster
 
Posts: 70
Default Workbooks.Open with out full path help needed.

Below is the first part of a macro that works 'almost' perfectly.

In my macro, I don't want to use the 'full path' to the file, because I
move the set of files to different directories at times. The macro works
well on my Macintosh without a full path.

The macro will open the "testfile.xls" when called, if the file has been
perviously opened once, via the 'File' menu in Excel. However, opening
the testfile.xls via Windows Explorer does not work for the macro. I'd
like to be able to either not have to manually open the file, or at
least be able to open the file in Windows Explorer without using the
File menu.

The file can then be closed and the macro will open the file if I
haven't quit and restarted Excel, and if the file was opened via the
File menu.

The "testfile.xls" is in the same directory as the Excel file that is
running the macro.

First part of macro here...

Sub QuoteCopy_Tester()
Application.ScreenUpdating = False
Workbooks.Open FileName:="testfile.xls"
Range("QuoteArea").Select

....macro continues.

Thanks for the help.

Sorry if I've talked in circles.

-Dennis
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Full path possible to be seen? Octavio New Users to Excel 10 July 2nd 06 08:51 PM
Indirect does not recognize full server path? Matt Excel Worksheet Functions 3 January 6th 06 09:18 PM
full UNC path in footer muttdaemon Excel Discussion (Misc queries) 1 October 12th 05 06:21 PM
full path of excel file Song Excel Discussion (Misc queries) 2 August 21st 05 06:50 PM
How to change the Excel Title Bar to show the full file path na... lmilkey8855 Excel Discussion (Misc queries) 2 January 6th 05 03:08 PM


All times are GMT +1. The time now is 07:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"