Running Macros from Excel Saved as html file
Good day,
What is the command to run a macro as soon as a file is opened? Thanks, |
Running Macros from Excel Saved as html file
You can put this into a General module:
Option Explicit Sub Auto_Open() Msgbox "Hi from Brent" End Sub If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Brent E wrote: Good day, What is the command to run a macro as soon as a file is opened? Thanks, -- Dave Peterson |
Running Macros from Excel Saved as html file
I apologize, this was a mispost on a different topic. The question I wanted
to ask for this post is as follows: Is there a way to get the macros in a spreadsheet to run if the file is saved as an html file? Thanks, |
Running Macros from Excel Saved as html file
Thanks Dave. Will try that.
"Dave Peterson" wrote: You can put this into a General module: Option Explicit Sub Auto_Open() Msgbox "Hi from Brent" End Sub If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Brent E wrote: Good day, What is the command to run a macro as soon as a file is opened? Thanks, -- Dave Peterson |
Running Macros from Excel Saved as html file
Of the file is saved as HTML. there is nowhere for the VBA code to 'hide'
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Brent E" wrote in message ... I apologize, this was a mispost on a different topic. The question I wanted to ask for this post is as follows: Is there a way to get the macros in a spreadsheet to run if the file is saved as an html file? Thanks, |
Running Macros from Excel Saved as html file
AFAIK, an Excel file saved in HTML format does not contain macros.
On Thu, 16 Oct 2008 14:01:02 -0700, Brent E wrote: Good day, What is the command to run a macro as soon as a file is opened? Thanks, Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products |
All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com