Macro: a different kind of Save dialog box?

  • Thread starter Milhouse Van Houten
  • Start date
M

Milhouse Van Houten

Hello,

I have the macro below, which prompts for a location to save the file to,
but only by browsing to the location. Is there a way where I can get a
dialog box instead (or in addition) that would allow me to directly type in
a path and hit enter?

I'm using Access 2007 SP2

Thanks

'------------------------------------------------------------
' ExportPayrollConfirmation
'
'------------------------------------------------------------
Function ExportPayrollConfirmation()
On Error GoTo ExportPayrollConfirmation_Err

DoCmd.OutputTo acOutputQuery, "Payroll_Confirmation",
"Excel97-Excel2003Workbook(*.xls)", "", False, "", 0, acExportQualityPrint
DoCmd.OutputTo acOutputQuery, "QRYPrlIncompleteFiles",
"Excel97-Excel2003Workbook(*.xls)", "", False, "", 0, acExportQualityPrint

ExportPayrollConfirmation_Exit:
Exit Function

ExportPayrollConfirmation_Err:
MsgBox Error$
Resume ExportPayrollConfirmation_Exit

End Function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 2950 from macro when exporting to Sharepoint 0
Error probably caused by lack of library reference 8
Word macro that can call cells out of Excel for a find and replace 0
Macro Code for bringing up Save As dialog box and changing file Type 0
Error message with Macro 1
vba date output 2
Output Query as an Excel file 2
Data Import Problem With Acess 2007 2

Top