Print Page - Run an Excel Macro

Title: Run an Excel Macro
Post by: mjwillyone on August 23, 2021, 04:13:50 AM

I appreciate so much the help this forum gives. This is simple to many, but I haven't been able to locate an answer when looking through the forum.

How can I run a macro in Excel? I'd rather not use keystrokes to do it.

Thanks!
Mike

Title: Re: Run an Excel Macro
Post by: td on August 23, 2021, 06:50:25 AM

It is fairly simple. Please visit the Tech Database Excel tutorial:

https://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/nftechsupt.web+Tutorials/OLE~TUTORIAL+Automating~Excel~Tutorial.txt (https://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/nftechsupt.web+Tutorials/OLE~TUTORIAL+Automating~Excel~Tutorial.txt)

The subject is touched on near the end of the tutorial.

Title: Re: Run an Excel Macro
Post by: stanl on August 23, 2021, 07:27:10 AM

Is the question (1) running a macro already embedded in an Excel document or (2) running macro code on an Excel document from external text file or variable?

Title: Re: Run an Excel Macro
Post by: mjwillyone on August 23, 2021, 08:27:14 AM

Thanks, TD. I will give that doc a look.

Stanl, the macro is already built and in the Excel doc.

Thank you all!
Mike

Title: Re: Run an Excel Macro
Post by: stanl on August 23, 2021, 10:33:49 AM

Quote from: mjwillyone on August 23, 2021, 08:27:14 AM
Stanl, the macro is already built and in the Excel doc.

I think the link Tony indicated will handle that. Just a simple Run command.

WinBatch® Technical Support Forum

All Things WinBatch => WinBatch => Topic started by: mjwillyone on August 23, 2021, 04:13:50 AM