Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 22nd 04, 05:41 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2003
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the macro called by an add in from older excel? Ian Excel Discussion (Misc queries) 2 June 25th 08 10:53 PM
executing a macro within another brian Excel Discussion (Misc queries) 3 July 5th 06 01:22 AM
Executing macro in one book from another. michaelberrier Excel Discussion (Misc queries) 3 June 26th 06 10:45 AM
Executing a macro from a cell filo666 Excel Discussion (Misc queries) 2 February 15th 05 08:18 PM
Excel VBA - Executing external programs in an excel macro schumacker Excel Programming 1 February 24th 04 12:17 PM


All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017