Can I make a Macro "Run" on opening the application?

steve case · May 13th, 2002, 03:23 PM

I would like to have the user click on the Icon from the desk top and have the macro execute it's function with out any further input from the user. Can this be done?

What I'm wanting to do is have the user copy text to the Windows clipboard from another application, click on an icon for the Excel file. Excel then "Automatically" manipulates the text and saves as a text file. Then logs off. The user then opens the newly saved text file and continues.

This would save the the user the step of having to click yet another button.

stevebausch · May 13th, 2002, 03:35 PM

Do an object browser search on "open", there should be a workbook_open event you can fill with code. That code will be invoked when the workbook is opened.

mikeyboy · May 13th, 2002, 04:02 PM

Sub Workbook_open()
'
Range("A1").Select
ActiveSheet.Paste
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub

This will run automatically when installed in "ThisWorkbook". You can add more script to paste to any any sheet in the workbook.

[ This Message was edited by: mikeyboy on 2002-05-13 15:25 ]

steve case · May 13th, 2002, 05:05 PM

If I knew how to do an "Object Brower" search, or what it even is, I would be more dangerous than I already am

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 03:23 PM	#1
steve case Board Regular Join Date: Apr 2002 Posts: 682	I would like to have the user click on the Icon from the desk top and have the macro execute it's function with out any further input from the user. Can this be done? What I'm wanting to do is have the user copy text to the Windows clipboard from another application, click on an icon for the Excel file. Excel then "Automatically" manipulates the text and saves as a text file. Then logs off. The user then opens the newly saved text file and continues. This would save the the user the step of having to click yet another button.

May 13th, 2002, 03:35 PM	#2
stevebausch Board Regular Join Date: May 2002 Posts: 809	Do an object browser search on "open", there should be a workbook_open event you can fill with code. That code will be invoked when the workbook is opened.

May 13th, 2002, 04:02 PM	#3
mikeyboy Board Regular Join Date: Apr 2002 Posts: 57	Sub Workbook_open() ' Range("A1").Select ActiveSheet.Paste ActiveWorkbook.Save ActiveWorkbook.Close End Sub This will run automatically when installed in "ThisWorkbook". You can add more script to paste to any any sheet in the workbook. [ This Message was edited by: mikeyboy on 2002-05-13 15:25 ]

May 13th, 2002, 05:05 PM	#4
steve case Board Regular Join Date: Apr 2002 Posts: 682	If I knew how to do an "Object Brower" search, or what it even is, I would be more dangerous than I already am