Save a file with Item Name

[miletracker]

Hi Everybody
this Question may have been asked before
I have a query that will that will bring up records to remove( or save to a excel table) what I would like to do is attach code to a
command button that would give the file its name from the dialog form that set the parameters for the query
*return the Item name from combobox (Lumber)
*return from startdate the Month (Jun)
*return from enddate the Month (Sep)
and save as an excel file with name
C\:My Documents\Expense\LumberJunSep2002

Miletracker

 

[gerard1979]

It's rough, but something like this.
I think you use TransferText <param> and so on

I thought there is a param for the place to return the document. so you can build this string as follows
strFile = &quot;C:\mydocuments\tempfile\&quot;
strFile = strFile & <extract Lumber from the place it's standing> & &quot;\&quot;
strFile = strFile & <extract startdate> & &quot;\&quot;
and so on

Is this what you're looking for?
If true then
you're welcome
else
come back to me with further explanations
end if

greetz,
gerard

 

[miletracker]

gerard
I may not know exactly what I am doing but it is not working am getting error message &quot;Object not available may be read only&quot; what am i doing wrong ? what &quot;Object&quot; miletracker
thanks for helping