Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
xl2k vs xl03 code difference
Hi Clr,
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? I think the FileDialog thingy was introduced with Excel XP. You can use something like this on any Excel version as of '97: Sub GetOpenFileNameExample() Dim lCount As Long Dim vFilename As Variant Dim sPath As String Dim lFilecount As Long sPath = "c:\windows\temp\" ChDrive sPath ChDir sPath vFilename = Application.GetOpenFilename( _ "Microsoft Excel files (*.xls),*.xls", , _ "Please select the file(s) to open", , False) If TypeName(vFilename) = "Boolean" Then Exit Sub Workbooks.Open cstr(vFilename) End Sub Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
xl2k vs xl03 code difference
Thanks Jan Karel, I appreciate that very much.
I'll give it a try ASAP. Vaya con Dios, Chuck, CABGx3 "Jan Karel Pieterse" wrote: Hi Clr, 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? I think the FileDialog thingy was introduced with Excel XP. You can use something like this on any Excel version as of '97: Sub GetOpenFileNameExample() Dim lCount As Long Dim vFilename As Variant Dim sPath As String Dim lFilecount As Long sPath = "c:\windows\temp\" ChDrive sPath ChDir sPath vFilename = Application.GetOpenFilename( _ "Microsoft Excel files (*.xls),*.xls", , _ "Please select the file(s) to open", , False) If TypeName(vFilename) = "Boolean" Then Exit Sub Workbooks.Open cstr(vFilename) End Sub Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
xl2k vs xl03 code difference
Outstanding........works super-fine for me
Many thanks Jan Karel Vaya con Dios, Chuck, CABGx3 "Jan Karel Pieterse" wrote: Hi Clr, 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? I think the FileDialog thingy was introduced with Excel XP. You can use something like this on any Excel version as of '97: Sub GetOpenFileNameExample() Dim lCount As Long Dim vFilename As Variant Dim sPath As String Dim lFilecount As Long sPath = "c:\windows\temp\" ChDrive sPath ChDir sPath vFilename = Application.GetOpenFilename( _ "Microsoft Excel files (*.xls),*.xls", , _ "Please select the file(s) to open", , False) If TypeName(vFilename) = "Boolean" Then Exit Sub Workbooks.Open cstr(vFilename) End Sub Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
xl2k vs xl03 code difference
Hi Clr,
Many thanks Jan Karel You're welcome. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL03 - Cell Text value not saved | Excel Programming | |||
Sub to extract uniques from 200k data in xl03 | Excel Programming | |||
IF function in Data Validation- XL03 | Excel Discussion (Misc queries) | |||
How do I auto-alphabatize in XL03? | Excel Discussion (Misc queries) | |||
Help! Bug-esque code behaivor on Windows 2K Server & XL2K | Excel Programming |