A snipet of code I use to have a user open files I want my MACRO to get data out of:
vFile = Application.GetOpenFilename("Excel-files,*",_1,"Select the file you want to open",,False)'if the user didn't select a file, exit subIfTypeName(vFile)="Boolean"ThenExitSub
Workbooks.Open vFile, UpdateLinks:=xlUpdateLinksAlways
No comments:
Post a Comment