Export to Excel with dynamic field name from an access form

[Rschadt]

Hello
I want to grab a value that is selected on a form (it is a date) and have that be part of the file name when I export to excel.

Something like this.... so the file name would be Dealer-Summary-11/30/2024.xlsx

"F:\Finance & Accounting\Securitization\Rick-Securitization Data\Temp-Date\Dealer-Summary-" & [Forms]![Month-End-Form]!
[List2] & ".xlsx"

[jojowhite]

Dim fName as string
fName = "F:\Finance & Accounting\Securitization\Rick-Securitization Data\Temp-Date\Dealer-Summary-" & [Forms]![Month-End-Form]!
[List2] & ".xlsx"

DoCmd.TransferSpreadsheet acExport,acSpreadsheetTypeExcel12Xml,"YourTable/QueryName",fName,True

[Welshgasman]

Hello
I want to grab a value that is selected on a form (it is a date) and have that be part of the file name when I export to excel.

Something like this.... so the file name would be Dealer-Summary-11/30/2024.xlsx

"F:\Finance & Accounting\Securitization\Rick-Securitization Data\Temp-Date\Dealer-Summary-" & [Forms]![Month-End-Form]!
[List2] & ".xlsx"

Windows will not accept / in a filename.!

[Rschadt]

so I am guessing that i need to take the form date field and reformat it to like something near this?

"F:\Finance & Accounting\Securitization\Rick-Securitization Data\Temp-Date\Dealer-Summary-" & Format[Forms]![Month-End-Form]!
[List2],yyyy-mm-dd)"& ".xlsx" ?

[Welshgasman]

Format[Forms]![Month-End-Form]!
[List2],"yyyy-mm-dd") & ".xlsx" ?

[Rschadt]

I must be going blind, it looks right, but continue to get a not valid file name error. The form is using a query to provide a list of dates of valid data, I am wondering if that field is not recognized as a date within the macro? I use the field as a filter and it is working on the queries that are invoked with the selected date value.

"F:\Finance & Accounting\Securitization\Rick-Securitization Data\Temp-Date\Dealer-Summary-" & Format[Forms]![Month-End-Form]!
[List2], "yyyy-mm-dd") & ".xlsx"

[Rschadt]

I changed the folder location that didnt solve it either

"C:\Users\Rick.Schadt\Downloads\Dealer-Summary-" & Format[Forms]![Month-End-Form]!
[List2], "yyyy-mm-dd") & ".xlsx"

[Welshgasman]

Put it into a string variable and debug.print it.
Do all the folders exist?

[Rschadt]

figured it out....needed an "=" at the start

="F:\Finance & Accounting\Securitization\Rick-Securitization Data\Temp-Date\Dealer-Summary-" & Format([Forms]![Month-End-Form]!
[List2],"yyyy-mm-dd") & ".xlsx"

[Welshgasman]

figured it out....needed an "=" at the start

="F:\Finance & Accounting\Securitization\Rick-Securitization Data\Temp-Date\Dealer-Summary-" & Format([Forms]![Month-End-Form]!
[List2],"yyyy-mm-dd") & ".xlsx"

Depends on how you were using it. Just as a filename in a command, then No.