Good day,

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

Thanks,

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

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,

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

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,

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