OLEObjects.ADD causes excel vba project to stop / reset / go dead

Jim I did try that but that does not seem to work either. Do i have
some enviormental setting that may be causing this.

Timothy.

Not sure if this causes a problem in 2003, but you could try...
Select Tools -> Macro's -> Security -> Trusted Sources. Check Allow Access
to Visual Basic Project. I don't use 2003 here at work so I can ot test it
for you...
--
HTH...

Jim Thomlinson


"Timothy Marks" wrote:

> Jim I did try that but that does not seem to work either. Do i have
> some enviormental setting that may be causing this.
>
> Timothy.
>
>

I have both checked, Trust access to VBP and Trust all removed all add
ins and templates. I then deleted all trusted sources and add-ins.
Nothing has worked.

Maybe there is.

Close excel and clean up that windows temp file.

Windows start button|Run
%temp%

Excel stores lots of stuff associated with objects in this temp folder. Maybe
there are lots of them and excel is getting confused.

ps. You may want to close other applications when you do this so you don't
break anything. (I don't bother, but some do.)

Timothy Marks wrote:
>
> Jim I did try that but that does not seem to work either. Do i have
> some enviormental setting that may be causing this.
>
> Timothy.

--

Dave Peterson

I rebooted my computer, I then cleared out my temp directory. All apps
were restarted. Still have the same result.

Your code worked fine for me in my simple test workbook.

Does it work in a brand new workbook for you?

(I got nothing either way, though.)

Timothy Marks wrote:
>
> I rebooted my computer, I then cleared out my temp directory. All apps
> were restarted. Still have the same result.

--

Dave Peterson