Executing an older excel 4.0 macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
ExecuteExcel4Macro "SET.UPDATES.STATUS
(""NOAMGR|EXCEL!DISPLAYZONEGAMMA"",1,2)"

possibly
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Range 1
XL 2007 records print command as XL4 macro 1
Help with my macro 8
Excel4Macro 3
What are the options in the print macro? 1
Can you tell me the Print options for ExecuteExcel4Macro? 1
Running Excel 4.0 Macro in Excel 2007. 1
Print Macro 5

Back
Top