Michael R Mattys
mmattys at rochester.rr.com
Wed May 9 13:19:28 CDT 2007
Maybe this helps? strFileName = xlApp.Application.GetSaveAsFilename(FileFilter:="Excel Workbooks (*.xls), *.xls", Title:="Save Workbook As") Michael R. Mattys MapPoint & Access Dev www.mattysconsulting.com ----- Original Message ----- From: "Mark A Matte" <markamatte at hotmail.com> To: <accessd at databaseadvisors.com> Sent: Wednesday, May 09, 2007 2:02 PM Subject: Re: [AccessD] InstrRev in A97 > ...apparently I can't focus today. > > I found the reason they used InstrRev instead of DIR...at this point the > file has not been created...therefore DIR returns nothing. They are using > the InstrRev to parse the name of the file to be created. > > Thanks, > > Mark A. Matte >