DoCmd.OutputTo: Store path location selected by user to a string

[kapaw]

I am using this code

DoCmd.OutputTo acOutputReport, "rptFilter", "Excel97-Excel2003Workbook(*.xls)", strFilename, True, "", , acExportQualityScreen

with the OutputFile set to "" so the user can select the directory on where they want to store the exported template. My issue is I'm trying to figure out if I could get the file path and the file name and store it on a string so I could use it for something else.

 

[Cronk]

At the simplest level you could prompt the user to enter the details

strFileName = InputBox("What is the output file")

 

[kapaw]

What about the directory on which the user will store it? I want to be able to store that in a string too including the filename

 

[Cronk]

strFileName = InputBox("What is the output file", "Enter path and file name", "C:\your directory\your file name.xlsx")

 

[ghudson]

Maybe this sample will help get you started... Browse [Find a directory or file]