ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel automation problem (https://www.excelbanter.com/excel-programming/434508-excel-automation-problem.html)

ARHangel

Excel automation problem
 
I have Office 2007 installed on my machine and i use com automation.

If i run the method OleRun on a excel file(2003 or 2007) the excel process
is opened but not visible (the expected result)

But if i run the method OleRun on a excel file that contains a module(it
doesn't even have to contain code)(2003 or 2007) the excel process is opened
and visible(not expected)

The reason I call the OleRun method is because I want to call the method
IViewObject.GetExtent

Is there a way to do this but without making the excel visible.


All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com