variable output macro

[bobfin]

I have an Access 2000 database on a network drive that is used by several people. This database has a single report which each person uses to print their own data. But the users would also like to save a snapshot of their report. I could add a button on the main form that would run a macro which uses the OutputTo action to save a snapshot. I could even specify a common save location on their individual hard drives (e.g. C:\My Documents). But every filename would be the same. Is there any way to give the users the ability to name the output file (and path) when they save it?

 

[spacepro]

Yes.

When you create the macro where it asks you for the output file , leave this empty and when you run the macro it will show you the output to dialog box asking the users where to save it to and the filename.

HTH
Andy

 

[md-rahim]

How can I export in excel some selected row data through macro output to from access table.

 

[ajvol01]

How can I export in excel some selected row data through macro output to from access table.

Not sure if this is possible by using a Macro.

It can easily be done by using a VBA procedure.

Sub ExportExcel()
' "Range" is a named Range defined in a worksheet of the Excel workbook
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Table", "File", True, "Range"
    
End Sub