LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 5th 04, 03:25 PM posted to microsoft.public.excel.programming
external usenet poster
First recorded activity by ExcelBanter: Dec 2003
Posts: 3
Default ActiveX Component Can't create object - Any Explainations?


(Please let me know if this is /is not the correct forum;since it
deals with excel programmming ,i thought this would be a good place to
start with.The sitaution that i am attempting to portray is really
vague ,please excuse me for any incomplete data)

Application Aim:-

I have an application coded using vb6.0 and it uses excel to do some
formatting on input excel sheets.This is done through ole automation.I
use late binding i.e

createobject("excel.application") to get a valid object of
excel.Following this line i have a error trapping code reading

if err.number<0 then print error message.

Assume that the above application is in system A.In system A there is
a folder that is shared and mapped as F (any logical drive
names).There is a batch file which calls this application against
input files in the shared folder.The application exists as an exe in a
path inside this shared folder

There are 2 more systems System B and System C, which map drive F to
the shared folder in system A.System A holds many batch files which
call the application against different set of input files.

The situation that i faced is that system A is executing a batch file
and so are systems B and C(against different input files).It may be
possible that some of the input files are common(this stage of usage
doesn't matter as the error occurs much before this.

My problem is that the batch file involving the application(against
one set of input files ) flags the error "activeX component can't
create object error" and exits since no further action is possible.

How is this possible.When i tried to reproduce this situation with no
system B or C connected or logged on with the same user id that was in
system A, i couldn't. There was no such problem.

Is it really possible to throw some light on what is happening.I guess
there is violation of some access (max limit ).The following microsoft
KB article gives vague reason for this ( based on the error


The last probable cause listed seems to fit but i would like to know
how so that i can avoid situations like this.

With Regards

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
error 336 (visual basic) ActiveX component not correctly registered Jose Luis Excel Discussion (Misc queries) 0 September 10th 07 09:34 AM
Activex component can't create object Naveen New Users to Excel 1 September 4th 07 02:57 PM
DsoFile ActiveX component can't create object on other computers Jeremy Gollehon[_2_] Excel Programming 1 August 18th 03 09:44 PM
ActiveX component can't be created Singnet Newsgroup Excel Programming 0 August 6th 03 03:27 PM
activex component can't create object with SAP 6.20 Mark Bigelow Excel Programming 0 July 22nd 03 06:24 PM

All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017