VB File Save

[John A]

I have an Excel 97 workbook that produces a sheet of cheque-print
data. I have a VB macro that reads data from a text file from another
application into the workbook, and another VB Macro that saves data on
this sheet to a comma-delimited text file (for input to Word for
cheque printing).

I currently have the file paths for the text files hard-coded into the
VB macro.

I would like to be able to select the paths from a standard Windows
File Open and File Save box, but the only option I can find is to
enter the path in an InputBox, which is not very good.

Can this be done?

Thanks

John Allen

[IC]

This copied directly from Excel help (GetSaveAsFilename Method)

fileSaveName = Application.GetSaveAsFilename( _
fileFilter:="Text Files (*.txt), *.txt")
If fileSaveName <> False Then
MsgBox "Save as " & fileSaveName
End If

Ian

"John A" <[email protected]> wrote in message
news:[email protected]...
>I have an Excel 97 workbook that produces a sheet of cheque-print
> data. I have a VB macro that reads data from a text file from another
> application into the workbook, and another VB Macro that saves data on
> this sheet to a comma-delimited text file (for input to Word for
> cheque printing).
>
> I currently have the file paths for the text files hard-coded into the
> VB macro.
>
> I would like to be able to select the paths from a standard Windows
> File Open and File Save box, but the only option I can find is to
> enter the path in an InputBox, which is not very good.
>
> Can this be done?
>
> Thanks
>
> John Allen

[John A]

Ian

Thanks for your help

My Excel97 VB help doesn't work

On Sat, 05 Feb 2005 20:06:36 GMT, "IC" <[email protected]> wrote:

>This copied directly from Excel help (GetSaveAsFilename Method)
>
>fileSaveName = Application.GetSaveAsFilename( _
> fileFilter:="Text Files (*.txt), *.txt")
>If fileSaveName <> False Then
> MsgBox "Save as " & fileSaveName
>End If
>
>Ian
>
>"John A" <[email protected]> wrote in message
>news:[email protected]...
>>I have an Excel 97 workbook that produces a sheet of cheque-print
>> data. I have a VB macro that reads data from a text file from another
>> application into the workbook, and another VB Macro that saves data on
>> this sheet to a comma-delimited text file (for input to Word for
>> cheque printing).
>>
>> I currently have the file paths for the text files hard-coded into the
>> VB macro.
>>
>> I would like to be able to select the paths from a standard Windows
>> File Open and File Save box, but the only option I can find is to
>> enter the path in an InputBox, which is not very good.
>>
>> Can this be done?
>>
>> Thanks
>>
>> John Allen
>