Thread: Open File Dialog Box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
  
Posts: 11,272
Default 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



Reply With QuoteReply With Quote