Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
strange behaviour
First, change your code to
EITHER dim xlApp as Object set xlApp = CreateObject("Excel.Application") OR dim xlApp as Excel.Application set xlApp = New Excel.Application In general, the first is safer for web apps in my experience. For VB apps, use the latter as it is more efficient plus it givs the developer intellisense Also, fix the following line xlApp.Workbooks.Add "C:\abc.xls" to xlApp.Workbooks.Open "C:\abc.xls" remember the syntax ! -----Original Message----- hi all I have created one activeX control. when I called this control with object tag in a browser, I found strange behaviour for the following code. dim xlApp as excel.Application set xlApp = createObject("Excel.Application") xlApp.Workbooks.Add "C:\abc.xls" :::--- at this line there is no problem when I use this control in VB Projects. but when i use the same control in IE, at this perticular line excel application screen becomes visible. I have to write the code Xlapp.visible = false to hide the screen. Please explain why this strange behaviour is happening. regards amod . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut key strange behaviour | Excel Worksheet Functions | |||
Shortcut key strange behaviour | Excel Worksheet Functions | |||
Strange if(***) behaviour? | Excel Discussion (Misc queries) | |||
Strange behaviour when sorting rows | Excel Discussion (Misc queries) | |||
Strange behaviour | Excel Worksheet Functions |