Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a file to open
Hi All.......
The following code works fine in XL2007, but I am working in XL2000 and it won't run there. Does anyone know how I can achive the same thing in XL2000, please? Dim strFile As Variant On Error GoTo 200 With Application.FileDialog(msoFileDialogOpen) .AllowMultiSelect = False .Filters.Add "Excel Files", "*.xl*" .InitialFileName = ThisWorkbook.Path & "\" .Show strFile = .SelectedItems(1) End With Application.DisplayAlerts = False Application.EnableEvents = False Workbooks.Open Filename:=strFile TIA Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select File to Open | Excel Programming | |||
"Open Browser Window And Select A File" | Excel Programming | |||
select open webpage, copy information to open worksheet | Excel Programming | |||
When I select "Open" from the "File" menu in Excel, I get only a . | Excel Discussion (Misc queries) | |||
open file dialog-select file-import worksheet | Excel Programming |