answersLogoWhite

0

Create Auto save macro in Excel?

Updated: 12/24/2022
User Avatar

Wiki User

14y ago

Best Answer

In XLS 2003 you can simply turn the "Save AutoRecovery info" in EXCEL (Tools/Options/Save)

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Create Auto save macro in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Engineering

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.


What allows you to save worksheet in HTML format in excel?

The way Microsoft designed Excel, the program has the ability to save files in HTML format. You just click the Save As option and select .html. MS Excel automatically creates the appropriate HTML code for you.


What is a macro enabled document?

http://office.microsoft.com/en-us/help/HA100310711033.aspx Macros automate frequently-used tasks; many are created with VBA (Visual Basic for Applications (VBA): A macro-language version of Microsoft Visual Basic that is used to program Microsoft Windows-based applications and is included with several Microsoft programs.) and are written by software developers. However, some macros pose a potential security risk. A person with malicious intent can introduce a destructive macro, in a document or file, which can spread a virus (virus: A computer program or macro that "infects" computer files by inserting copies of itself into those files. When the infected file is loaded into memory, the virus can infect other files. Viruses often have harmful side effects.) on your computer.


How do you create an HTML file?

We write HTML coding in notepad and save it with .html extension. It will automatically open with internet explorer


How do you save a webpage to your document?

Yes, a word document of any type can be saved as a web page. It's very simple. Create the document, which you want to save as web page. Now click on save as in main menu. A window will open. Here you have "Save as type" option. Chose "web page" and name the file in "File Name" box and click save. Your done.

Related questions

How do you do Auto Save in Excel 2007?

You don't. "Auto" means automatic - Excel does it for you.


What Excel feature automatically saves your workbook?

auto save


Is an Excel spreadsheet an example of a file?

A spreadsheet that you create and save with Excel is an example of a file.


How do you create an Excel to Oracle converter?

From MS Excel, there is nothing you can create. You can save an Excel file in various formats, that might make it easier to import the data into Oracle.


What does xlsx stands for?

..xlsx is a Excel 2007 format, whereas .xls is Excel 2003 or earlier. Excel 2007 allows you to save in multiple 2007 formats: ..xlsx - Normal Excel 2007 format ..xlsm - Macro-Enabled format ..xlsb - Binary format Save your files as 2003 under Save as Type and you should be fine.


How do you save access report results to Excel?

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.


How many ways can you save an excel file?

· File -> Save · File -> Save As · [Ctrl] + Save · Save button · [Alt] + [F], [S] · Create a macro to save a spreadsheet · F12 · Close


Which excel command would you use to create a new spreadsheet without changing an existing spreadsheet?

Save As


Creating an .csv file from word?

create a Word table, Select the entire table and Copy, paste into an Excel doc, save Excel doc as .csv


What is a Macro in Excel?

Macro is feature in MS Excel software which records all the steps and all the steps can be repeated whenever a same task is required to be performed. It helps in reduction of time in performing monotonous task. Macro is available in Tools menu.


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.