Author Topic: Run an Excel Macro  (Read 203 times)

mjwillyone

  • Newbie
  • *
  • Posts: 45
Run an Excel Macro
« 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

td

  • Tech Support
  • *****
  • Posts: 3872
    • WinBatch
Re: Run an Excel Macro
« Reply #1 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

The subject is touched on near the end of the tutorial.
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

stanl

  • Pundit
  • *****
  • Posts: 1534
Re: Run an Excel Macro
« Reply #2 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?

mjwillyone

  • Newbie
  • *
  • Posts: 45
Re: Run an Excel Macro
« Reply #3 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

stanl

  • Pundit
  • *****
  • Posts: 1534
Re: Run an Excel Macro
« Reply #4 on: August 23, 2021, 10:33:49 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.