LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Open file dialog box works in XL2000 but not in XL2003

Hi all,
I have this code working fine in an Excell 2000 macro:

Sheets("SF.LMI.LOAN.DTL").Activate
filePath = Application.GetOpenFilename("Load LOAN detail Files
(*.LOAN.DTL), *.LOAN.DTL", , "Select a Loan Detail file")
If filePath = False Then
Exit Sub
End If

The code shows the Open File dialog box, displaying only the name of the one
particular file I want to show to the user. However, it does not work in
XL2003. When the box is displayed XL2003, the list of files is empty. So, I
have to change the pattern for the file name to *.*, which displays all the
files in the directory.
Does anyone know why it does not work the same in XL2003?

Thanks in advance
 
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
Terminating autofilter removes commandbuttons (xl2000, not in xl2003) Rob[_5_] Excel Programming 3 August 29th 07 08:07 PM
xl2000 vs. xl2003 RangeFromPoint and Grouped Shape Greg Wilson Excel Programming 9 August 9th 07 09:10 AM
veryhidden with xl2000 & xl2003 JNW Excel Programming 7 September 19th 05 08:57 PM
Performance trouble when changing from XL2000 to XL2003 vik Excel Discussion (Misc queries) 1 March 22nd 05 06:49 PM
Can not open .wb1 file with XL2000 and XL2002 Gaurav Excel Discussion (Misc queries) 1 March 8th 05 12:21 PM


All times are GMT +1. The time now is 12:33 PM.

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"