Hi all,
I have one vbscript that is working fine on my local mechine but it's not working on my server mechine
my local mecine is:Microsoft Windows XP [Version 5.1.2600]
my server mechine is:Microsoft Windows [Version 6.1.7600]
How to run my vbs script on my server mechine or any othe way to run the macro in cmd prompt
Iam using the following command to run my vbs script
cscript my_vbs_mac.vbs
my vbs script name is my_vbs_mac.vbs
The following is the vbs script Iam using
Set oExcel = CreateObject("Excel.Application")
oExcel.Visible = False
oExcel.Application.AutomationSecurity = 1
oExcel.Application.ScreenUpdating = False
oExcel.Application.DisplayAlerts = False
Set objWorkbook = oExcel.Workbooks.Open("C:\Documents and Settings\users\ram\text.xls")
oExcel.Run "my_mac"
objWorkbook.Save
objWorkbook.Close
Set objWorkbook = Nothing
Set oExcel = Nothing
Please help me
Thanks,
Anumala
Bookmarks