About Us

ina

Hello,

I have a problem with a vbscript code or my vba code I do not know
anymore; my vbscript code it works as I tried to others file and it
executes the macro included but the problem is when I execute one file;
the file.

if I do not execute this scripts my file; the file works well.

what I tried to do it is to open excel and execute one macro in sheet1
and another in sheet2. that's all.

but the macro is estremily compress as I need another programs to
execute it. (cause of some addins such as function for date, currency
and others stuff coming from a specific program) Do you thingk that
the problem can be the addins. I do not know what to do anynmore

this is my code:

<HTML
<HEAD
<SCRIPT LANGUAGE=VBScript
Dim objExcel 'As Excel.Application
Dim objWkB 'As Excel.Workbook
Sub Btn1_onclick()
OpenSheet "getfunctiontest.xls"
End Sub

Sub OpenSheet(strLocation)
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = true
'Application.EnableEvents = True
objExcel.Workbooks.Open(strlocation)
<HTML
<HEAD
<SCRIPT LANGUAGE=VBScript
Dim objExcel 'As Excel.Application
Dim objWkB 'As Excel.Workbook
Sub Btn1_onclick()
OpenSheet "getfunctiontest.xls"
End Sub

Sub OpenSheet(strLocation)
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = true
'Application.EnableEvents = True
objExcel.Workbooks.Open(strlocation)
'objExcel.run objWkB.name &"!"&"thisworkbook.workbook_open"
End Sub
</SCRIPT
<TITLELaunch Excel</Title
</HEAD
<BODY
<INPUT TYPE=BUTTON NAME=Btn1 VALUE="Openfunction Sheet"
</BODY
</HTML

End Sub
</SCRIPT
<TITLELaunch Excel</Title
</HEAD
<BODY
<INPUT TYPE=BUTTON NAME=Btn1 VALUE="Openfunction Sheet"
</BODY
</HTML

any help is appreciated.

thanks

Ina

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Desperate...please help!	sas	Excel Worksheet Functions	3	January 22nd 06 08:09 PM
VBA Macro Assistance (I am desperate)	adncmm1980[_2_]	Excel Programming	1	October 4th 04 02:01 PM
VBA Macro Assistance (I am desperate)	adncmm1980	Excel Programming	2	October 3rd 04 11:09 PM
How to delete an Excel Macro from VBScript	Ram[_3_]	Excel Programming	1	September 3rd 03 11:18 PM
Calling xla argumented macro from VBScript	Lieven Roelens	Excel Programming	2	September 3rd 03 01:45 PM

Menu

About Us