XL2003 to XL2000 code converson

  • Thread starter Thread starter CLR
  • Start date Start date
C

CLR

Hi All.....

This code works fine in XL2003, but I need the result to work in
XL2000.....possible?

Dim strFile As Variant
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Filters.Add "Excel Files", "*.xls"
.InitialFileName = ThisWorkbook.Path & "\"
.Show
strFile = .SelectedItems(1)
End With
Workbooks.Open Filename:=strFile

TIA
Vaya con Dios,
Chuck, CABGx3
 
Application.FileDialog not in 2000. so just use this

Dim File As Variant
ChDrive ThisWorkbook.Path
ChDir ThisWorkbook.Path
File = Application.GetOpenFilename("Excel files(*.xls),*.xls")
If File <> False Then Workbooks.Open File

| Hi All.....
|
| This code works fine in XL2003, but I need the result to work in
| XL2000.....possible?
|
| Dim strFile As Variant
| With Application.FileDialog(msoFileDialogOpen)
| .AllowMultiSelect = False
| .Filters.Add "Excel Files", "*.xls"
| .InitialFileName = ThisWorkbook.Path & "\"
| .Show
| strFile = .SelectedItems(1)
| End With
| Workbooks.Open Filename:=strFile
|
| TIA
| Vaya con Dios,
| Chuck, CABGx3
|
|
 
Back
Top