Open File Dialog Box

[Tha BeatMaker]

I want to run a macro from Workbook1 which will
1) open the "Open File" dialog box
2) allow the user to select another Workbook (Workbook2)
3) copy and paste information from Workbook1 into Workbook2

My main problem is the Open File box. I know how to do step 3 but am
clueless about steps 1 and 2.

 

[Bob Phillips]

Look at GetOpenFilename in VBA help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tha BeatMaker" <[email protected]>
wrote in message
news:[email protected]...