Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

Running an Excel VBA macro from a VB screen

Hi,
I'm importing an Excel chart into a VB OLE box which updates as soon as I run the macro in Excel is there a way in which I can run the Excel macro from a command button on the VB screen.
I'm also having trouble putting scroll bars on my form as when I import the Excel chart I can't few it all, the scroll bars I've inserted and at the sides are Ok but they don't scroll my form.
Appreciate any help,
Thanks Mick
0
mickcoleman
Asked:
mickcoleman
  • 3
1 Solution
 
Richie_SimonettiIT OperationsCommented:
Yes you could use Run ("macroname") method.
0
 
Richie_SimonettiIT OperationsCommented:
example:
application.Run "test"
0
 
Richie_SimonettiIT OperationsCommented:
0
 
CleanupPingCommented:
mickcoleman:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
0
 
DanRollinsCommented:
Moderator, my recommended disposition is:

    Accept Richie_Simonetti's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now