|
-
February 10th, 2007, 12:39 PM
#1
Trying to run an Excel macro from HTML
All,
I am very new to VBA and am having an issue. My Excel macro is as follows:
Public Sub ImportButton_Click() ' SAC Import Utility for Deck Upload
Dim Cnt As Integer, Chk As String
DestFile = ActiveWorkbook.Name
InputFile = Application.Dialogs(xlDialogOpen).Show 'Get input filename
If InputFile = False Then Exit Sub
InputFile = ActiveWorkbook.Name
When I run it from inside Excel everything is hunky-dorry, however when I am trying to run it from HTML it will not run.
Any help appreciated.
Greg
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|