0
You can create a macro to do this process. In the macro view, select the "OutputTo" Action. From there, F6 to the bottom of the macro view then: 1. Select report as the object type. 2. Under object name, you will need to identify which report you're wanting. 3. Select output format to be Microsoft Excel 97-2003. 4. place the path you would like to save the report under output file. (for example, c:\MyReport) 5. save your macro by naming it, and run the macro as many times as you like. If it's just a one time thing instead of an ongoing report, you can open the report in print preview and then email it to yourself by doing a file;sendto function. Hope this answers your question.
What else can I help you with?
What is the difference between the way Access saves a record and the way Excel saves a row in a work sheet?
the difference between the way Access saves a record and the way Excel saves a row in a worksheet. Answer
When can you use word access Excel applications interchangeably?
There are lots of times when you would do it. You could be doing a report or a project in Word and in it you might want to have some calculations on a set of numbers that you have in Excel, or a list of data from Access to be part of your document. When a business does a report on their business they will have things like their financial details in it, which may have come from Excel or could have a list of their main clients or of their most important products based on sales from and Access database in the report.It is also possible to exchange data between Excel and Access too. A lot of data that you have in an Excel spreadsheet can be used in Access too, or the other way around. So if you already had the data in one or the other, and wanted to have it in both, you can export from one to the other to save you having to type it all in a second time.
When you save a workbook that contains external reference forumlas Excel stores the most recent results of those forumlas in the file?
When you save a workbook with external reference formulas, Excel will save the most recent results. When the file is next opened, it will update itself based on the other files.
How do you convert Excel to csv in Microsoft Excel?
From within Excel, File Menu>Save As>Save As Type>CSV
How Excel 2007 Converted to Excel 2003?
You can open a 2007 Excel spreadsheet with Excel 2003 if you save the file in Excel 2007 using "Save As" and select the 2003 compatibility mode.
How do you post your Excel spreadsheet as a webpage?
First you need to save it as a webpage, which you can do by using Save As. You will then need access to webspace in order to upload it. You will also need FTP software to do the uploading.
How do you export data from a query to Excel?
Create the report in a tab delimited format. It may have a suffix like txt or rpt. In Excel use the "Open" command. You will get a panel that allows you to refine where the column breaks are and define the format of the columns. Once this is done the data will be in Excel. Just save as a standard Excel file.
Create Auto save macro in Excel?
In XLS 2003 you can simply turn the "Save AutoRecovery info" in EXCEL (Tools/Options/Save)
How do you convert from Excel to open office?
Save your file as Excel xls format. Use the File-->Save As... menu and select the file type in the save dialog. For a video How to, see related links.
How do you deal with an error message pivot table created in a later version of Excel and can not be updated?
Unfortunatly, you will need to find a more current version of Excel to access the pivot table. After you do, save the file in compatible format for older version of Excel. Then you should be able to open the file and update the pivot table. However, if someone created the pivot table with Excel 2007 and used any of the new features, those features will be lost when you save in Excel 2003 format. See related links for a method to change the default for Excel 2007 to save pivot tables in the older classic format for Excel 2003 and earlier.
How do you do Auto Save in Excel 2007?
You don't. "Auto" means automatic - Excel does it for you.
How do you convert an xls file to xlt?
Open in Excel and save as an Excel Template.
