| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBA to open an excel file
Hi,
I am using VBA to open an excel file (week 40). Is there any way to use VBA to open the last saved file (week 41, 42 etc)? I want to use the most recent file to populate my data tables. Many thanks nick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using VBA to open an excel file
Nick
Why not use the GetOpenFileName() method and select the file Dim FName as String FName=Application.GetOpenFilename() workbooks.open Filename:=FName -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk wrote in message oups.com... Hi, I am using VBA to open an excel file (week 40). Is there any way to use VBA to open the last saved file (week 41, 42 etc)? I want to use the most recent file to populate my data tables. Many thanks nick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
| workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
| Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Linear Mode
