changing filename when exporting to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
pppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppp
 
Something like this should work:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "TableName",
"c:\mydocs\excel\" & txtFileName & ".xls", True, "MyNamedRange"
 
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).



Joe Fallon said:
Something like this should work:

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



Amy said:
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?
Click to expand...
Click to expand...
 
Back
Top