LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default xl2k vs xl03 code difference

Hi All.......the following code works fine in xl03 but does not work in xl2k.
Can anyone please tell me if it can be modified to work in xl2k?

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL03 - Cell Text value not saved Robin Excel Programming 3 September 13th 07 06:00 AM
Sub to extract uniques from 200k data in xl03 Max Excel Programming 28 August 6th 07 02:53 AM
IF function in Data Validation- XL03 Conker10382 Excel Discussion (Misc queries) 1 June 26th 07 12:37 AM
How do I auto-alphabatize in XL03? Conker10382 Excel Discussion (Misc queries) 1 June 5th 07 12:18 AM
Help! Bug-esque code behaivor on Windows 2K Server & XL2K Mike Mertes Excel Programming 1 November 10th 04 11:47 PM


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"