Exporting .xls file with file name changeable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James Kendall - 17 Mar 2005 21:05 GMT

I need to export a file. That's the easy part.
The difficult part is I need the file to be named YYYY-MM based on the data
range someone pulls. How do I do this?
Furthermore, I need the file to place the data on a certain tab in a certain
cell. How do I do this?
If possible I would like to build a .xls template and have it open it and
then save it as the YYYY-MM filename.

Call it your brain challenge of the day. Thanks.

Signature

Thank you for your time.
Windows NT
Office 97

Reply to this Message

Alex Dybenko - 17 Mar 2005 21:36 GMT

You can use docmd.transferspreadsheet to export to excel and pass it a file
name constructed on entered date using format function:

strFileName="C:\Data" & Format(dateVar,"YYYY-MM") & ".xls

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

>I need to export a file. That's the easy part.
> The difficult part is I need the file to be named YYYY-MM based on the
[quoted text clipped - 7 lines]
>
> Call it your brain challenge of the day. Thanks.

Reply to this Message