--- In [email protected], "stradavarious2002"
<[EMAIL PROTECTED]> wrote:
I don't know if this is your problem or not, but one thing I was
curious about is have you used this script with other applications
and not had the same problem?
>
> I connect to the activex script by creating a link to the OLE
object.
> I can then call a procedure
>
> In the script below, the OLE object is :
>
> CreateOLEObject('Intradaytradingnumbers.Class1')
>
> and the procedure I use to push numbers to excel is
Is is possible you are creating a new object for every time you
are attempting to load a value to the spreadsheet by executing this
create object code for every new value?
Just somewhere to start if you haven't already considered it.
Something to hold you over until the experts come along.
I am not far from dealing with office apps myself. I spent a
great deal of time converting excel spreadsheets to comma delimited
files for processing. It would be so much easier if I just read the
values directly from the spreadsheet.
[C]
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
