changing filename when exporting to excel

[Guest]

I am exporting to an excel file called equip.xls. I want to export to a
filename that is dependent upon a value in a text box on a form. For example
equip75.xls (where "75" was in a text box). I tried "equip"&"[text0].xls",
but no luck. Any ideas?

 

[andromeda]

pppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppp

 

[Joe Fallon]

Something like this should work:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "TableName",
"c:\mydocs\excel\" & txtFileName & ".xls", True, "MyNamedRange"

 

[Guest]

Thanks, I tried this but I get an error on "acexport" saying invalid
procedure. I'm not a vb expert - trying to just use the macro, when I use the
same path in a macro, I get an error that the spreadsheet is read only (but
it hasn't even created it yet).

Something like this should work:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "TableName",
"c:\mydocs\excel\" & txtFileName & ".xls", True, "MyNamedRange"
--
Joe Fallon
Access MVP

I am exporting to an excel file called equip.xls. I want to export to a
filename that is dependent upon a value in a text box on a form. For
example
equip75.xls (where "75" was in a text box). I tried
"equip"&"[text0].xls",
but no luck. Any ideas?