Wouter1234
New Member
- Joined
- Aug 16, 2007
- Messages
- 1
I am trying to start a VBA Macro in Excel using a VBScript in my browser.
Below you can see my - not working - chunk of code.
All suggestions are welcome!
Thanks in advance.
Bye!
Wouter1234
Below you can see my - not working - chunk of code.
All suggestions are welcome!
Code:
<HTML>
<HEAD><TITLE>Test</TITLE>
<SCRIPT LANGUAGE="VBScript">
<!--
Sub Test()
Dim fso, f1
Set fso = CreateObject("Scripting.FileSystemObject")
Set f1 = fso.GetFile("c:\Test.xls")
Application.Run "Test.xls!Macro.Macro"
End Sub
-->
</SCRIPT>
</HEAD>
<BODY>
<H3>Push the button to start the script.</H3><HR>
<FORM><INPUT NAME="Button1" TYPE="BUTTON" VALUE="Start"></FORM>
</BODY>
</HTML>
Thanks in advance.
Bye!
Wouter1234