Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Executing an older excel 4.0 macro
Record a new Macro
From the menu Choose Edit/Links Check Automatic and then Update now. Open the recorded macro and look at your code. If you are automating this (such as trying to reinitialize a dead link without anyone sitting at the computer) you will need to send an enter key SendKeys "{enter}" before the update in case the Update is not successful. Otherwise excel will prompt you with a yes no question asking if you want to start the application - and this stops execution of the vba code. wrote in message ... I am trying to convert an older excel 4 macro into VBA. The line of is ExecuteExcel4Macro "SET.UPDATES.STATUS (""NOAMGR|EXCEL!DISPLAYZONEGAMMA"",1,2). VBA does not like the ExecuteExcel4Macro. This line of code is suppose to set the links in Excel to NOAMGR (another DDE program) from manual to automatic. I tried to record a macro in Excel 97 and I still get the same line of code? Any Ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the macro called by an add in from older excel? | Excel Discussion (Misc queries) | |||
executing a macro within another | Excel Discussion (Misc queries) | |||
Executing macro in one book from another. | Excel Discussion (Misc queries) | |||
Executing a macro from a cell | Excel Discussion (Misc queries) | |||
Excel VBA - Executing external programs in an excel macro | Excel Programming |