| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open File Dialog box looks like | Excel Discussion (Misc queries) | |||
| Open Dialog Box to return Selected File Path and Not Open it. | Excel Programming | |||
| File open dialog box | Excel Discussion (Misc queries) | |||
| open file dialog-select file-import worksheet | Excel Programming | |||
| File open dialog | Excel Programming | |||
![Tha BeatMaker[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
