Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Please help. This command will open a file. But on the second time I
activate this command, it errors on me because the file is already open (thus, I don't need the prompt for choosing a filename). How do you switch to the file that's already open without the error message? Dim file1 as string, wkbk as Workbook file1 = Application.GetOpenFilename Set wkbk = Workbooks.Open(File1) Aria :) *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
i want all windows in one excel frame (windows in taskbar) | Excel Discussion (Misc queries) | |||
cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
can windows vista edit shared document from windows xp | Excel Worksheet Functions | |||
Page breaks are different in Windows 2000 and Windows XP | Excel Discussion (Misc queries) | |||
Use Windows Script to run Windows Explorer Search? | Excel Programming |