Open File Dialog Box
 

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.


--
Tha BeatMaker
------------------------------------------------------------------------
Tha BeatMaker's Profile: http://www.excelforum.com/member.php...o&userid=23998
View this thread: http://www.excelforum.com/showthread...hreadid=384114

Open File Dialog Box
 

Look at GetOpenFilename in VBA help.

--

HTH

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


"Tha BeatMaker"
wrote in message
news:Tha.BeatMaker.1rkbqc_1120341903.411@excelforu m-nospam.com...

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.


--
Tha BeatMaker
------------------------------------------------------------------------
Tha BeatMaker's Profile:
http://www.excelforum.com/member.php...o&userid=23998
View this thread: http://www.excelforum.com/showthread...hreadid=384114