open-run macro, disable marcos, close email it

[techexpressinc2]

I need to do this without human intervention:

Open the Excel - Run a Macro to Refresh the spreadsheets - there is a data connection to MS-Access.

Somehow?? Then disable the Macro that does the refresh. So the next person that opens the Excel the auto refresh does not happen.

Then Close the Excel.

Then send the Excel without the Macro via Outlook to a distribution list.

Any great ideas would be appreaciated. I get different parts to work but can-not get it all glued together.

Russ

[Richard Buttrey]

Hi,

When you say autorun when Excel is opened, I'm assuming you mean when the particular workbook is opened not the Application.

Why not just use a variable that's stored in an xlveryhidden sheet in say a cell named "FirstTime"

In the Workbook open event make the first instruction

Please Login or Register  to view this content.

Set the variable to Yes and save the workbook.
Now it will run the first time, but any subsequent attempt to open it will immediately close it. If you don't want this nuclear option then perhaps replace the Workbook.Close with an "End" instruction.

HTH

[techexpressinc2]

Great command - keep with me on this. I will test it and let you know.

I open the Excel up by an XP-Schedule task.

This is one strange process, but it will make my boss's boss happy. Which means I stay employed.

Thx Russ

[Richard Buttrey]

OK. I'll be interested to hear how it pans out.

You might like to make it a little more user friendly by displaying a pop up message box just before the macro closes the workbook.

Regards

[techexpressinc2]

No pop-up messages to happen.

All this is to happen at 9pm at night, by a computer.

Russ