Takes Long time to execute Set command

[AthmanArumugam]

Hi,

I have a line Set myxl = CreateObject("Excel.Application")
When the script is executed at this time, it takes a very long time.
However the object is created at the end of execution.
Can you provide me with any solutions.

 

[Deepak]

Hi,

If macro is running from xl then why u have refereed excel itself ?
else, Can we have complete code pls.

 

[AthmanArumugam]

I am actually creating this object from a different tool named QTP.

 

[NARAYANK991]

Hi ,

When you open Excel manually how long does it take ?

Is it possible to have early binding in QTP ? What you are doing is late binding.

Narayan

 

[AthmanArumugam]

Narayanan K - What is early binding in QTP.
Can you let me know how to do it.

 

[NARAYANK991]

Hi ,

I am sorry but I have no idea of QTP ; you will have to refer to the manuals for QTP to see if this feature is available , and if so , how it can be implemented for a reference to Excel.

Narayan