Click here to Skip to main content
15,897,187 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Hello,

I'm trying to run excel macro with ruby script in remote desk.
excel = WIN32OLE.new('excel.application')
excel.Visible = true
excel.WindowState = -4137
workbooks = excel.Workbooks
workbook = workbooks.Open(ARGS[0], 2, true)
workbook.application.Run("....")

I had to prepare remote desk to be logged in always for the execution of the excel. because, excel does not support non interactive mode execution.
The above scripts usually working well. but sometime I have a problem that script does not create excel instance correctly. I can find the execl.exe process in the task manager but the interface is not displayed.
Is there someone who had same problem ?

Thanks.
Posted
Updated 5-Jul-12 22:27pm
v3
Comments
Anumeha Shukla 17-Jul-12 8:11am    
Do you find more than one instances of excel.exe in the task manager when you run your application ??

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900