Thread: Using VBA to open an excel file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nick Hodge Nick Hodge is offline
external usenet poster
  
Posts: 1,173
Default 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 With QuoteReply With Quote