createobject of Excel.Application.8 takes 30 seconds 
Author Message
 createobject of Excel.Application.8 takes 30 seconds

Hello,

I create an object in Visual Basic 5 of class Excel.Application.8

Excel is installed correctly, and it runs as I expected.
When creating an object in VB5, using the following code

Dim obj as object
Set obj = createobject("Excel.Application.8")

it takes 30 seconds before the object is created, while start Excel from the
Start Menu takes less than 5 seconds.
On other computers, it takes less than 3 seconds.

Can anyone tell me what is wrong?

Thanks,
Bart



Wed, 24 Sep 2003 03:30:41 GMT  
 createobject of Excel.Application.8 takes 30 seconds

Quote:

> I create an object in Visual Basic 5 of class Excel.Application.8

You'd be better off using just Excel.Application

Quote:
> Excel is installed correctly, and it runs as I expected.
> When creating an object in VB5, using the following code

> Dim obj as object
> Set obj = createobject("Excel.Application.8")

Dim obj as Excel.Application
Set obj = createobject("Excel.Application")

That should improve it a little.

--
MikeC

Please reply to the group.



Wed, 24 Sep 2003 11:53:21 GMT  
 createobject of Excel.Application.8 takes 30 seconds
by defining DIM obj as Object you're using 'late binding' which means that
the computer doesn't know which object to create until it comes across the
set obj = line.

define the object like this:
Dim obj as Excel.Application

this is called 'early binding' and is faster.

try it to see if it makes a difference

Richard


Quote:
> Hello,

> I create an object in Visual Basic 5 of class Excel.Application.8

> Excel is installed correctly, and it runs as I expected.
> When creating an object in VB5, using the following code

> Dim obj as object
> Set obj = createobject("Excel.Application.8")

> it takes 30 seconds before the object is created, while start Excel from
the
> Start Menu takes less than 5 seconds.
> On other computers, it takes less than 3 seconds.

> Can anyone tell me what is wrong?

> Thanks,
> Bart



Wed, 24 Sep 2003 22:04:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Program takes 30 seconds to shutdown

2. MSComm when no modem it hangs for 30 seconds

3. 30 second timeout in Crystal.Net viewer or report

4. Data Environment command timeout exactly 30 seconds

5. Timeout application after 30 days help needed with code

6. excel.application object pointing to second open window

7. Set xLApp = CreateObject("Excel.Application")

8. Server.CreateObject("Excel.Application")

9. CreateObject("Excel.Application") Fails on NT

10. CreateObject("Excel.Application") problem

11. CreateObject("Excel.Application")

12. Can't createobject for Excel.Application

 

 
Powered by phpBB® Forum Software