Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
I currently have a script set to open 2 specific workbooks and then prompt to choose the required 3rd.
As it is, I can only select 1 when the 'open' window comes up. Is there any way I can make this so I am able to select more than one file at once?
The code I currently have is as follows:
"What am I, a magnet for these idiots?"
--Pearl Forrester, MST3K
This message was edited by Von Pookie on 2002-02-20 14:01
As it is, I can only select 1 when the 'open' window comes up. Is there any way I can make this so I am able to select more than one file at once?
The code I currently have is as follows:
_________________Private Sub Workbook_Open()
On Error GoTo myErr
ChDir "(directory)"
Workbooks.Open "(file.xls)"
Workbooks.Open "(file.xls)"
Which = Application.GetOpenFilename() 'prompts user to open 3rd
Workbooks.Open Which
End
myErr:
End Sub
"What am I, a magnet for these idiots?"
--Pearl Forrester, MST3K
This message was edited by Von Pookie on 2002-02-20 14:01