• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

Excel macro needs to run a VB.NET application

I have a VB.NET application that generates an excel sheet and puts a macro button in the excel application that is generated. The data on the excel sheet is manipulated by the user. Once the data is updated (mainpulated) the user clicks the macro button that was generated by the VB.NET app. This button / macro needs to call another VB.NET app that updates the changed data on the Excel sheet to the Database. I am able to generate the excel macro button but do not know how to execute the VB.NET app from this button / macro. Does anyone have any code or alternate method to accomplish this.

Thanks a million
0
marthand
Asked:
marthand
1 Solution
 
JoaTexCommented:
Hi

Suposing your Macro is Named Jump and your aplication is calculator from Windows Here is the code:

Dim Res
Sub Jump()
On Error GoTo ErrorHandler
    Res = Shell("C:\Windows\Calc.exe")
    Exit Sub
ErrorHandler:
    MsgBox "Error!", 64, "Update Sheet"
End Sub

Hope it Suites you
Jo
0
 
CleanupPingCommented:
marthand:
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 JoaTex's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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