Sign in to follow this  
Hemendra

MACRO

Recommended Posts

HI,

using SHELLEXECUTE function to open EXCEL file of particular location. I will have to wait data to dumped in particular opened sheet, then I need to run specific MACRO of that opened file. How can I run MACRO from our DAQ?

Share this post


Link to post
Share on other sites

That I don't know.  That would be on the Excel side.  You may be able to use a command line flag to tell Excel to do something on load, but I am unsure as I don't really use Excel.  Check it's manual.  ShellExecute() in DAQFactory is the same as typing something in at the Command Prompt.

Share this post


Link to post
Share on other sites

I not sure, either, but it's possible that's there's a magic name for a macro, like "autoexec" or something, whereby Excel knows to automatically run it when the document is opened. 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this