Running Macros from Excel Saved as html file

[Brent E]

Good day,

What is the command to run a macro as soon as a file is opened?

Thanks,

 

[Dave Peterson]

You can put this into a General module:

Option Explicit
Sub Autpen()
Msgbox "Hi from Brent"
End Sub

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
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]

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,

 

[Brent E]

Thanks Dave. Will try that.

You can put this into a General module:

Option Explicit
Sub Autpen()
Msgbox "Hi from Brent"
End Sub

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
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.)

 

[Bernard Liengme]

Of the file is saved as HTML. there is nowhere for the VBA code to 'hide'
best wishes

 

[Tushar Mehta]

AFAIK, an Excel file saved in HTML format does not contain macros.

On Thu, 16 Oct 2008 14:01:02 -0700, Brent E

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