TheSwamp

Code Red => VB(A) => Topic started by: Adesu on March 07, 2007, 03:30:31 AM

Title: Why like this
Post by: Adesu on March 07, 2007, 03:30:31 AM

Hi Alls,
I just load a code from my friend,then I load it but display alert box as like at attach file,I don't know what meaning it.

Title: Re: Why like this
Post by: Arizona on March 07, 2007, 06:45:05 AM

I'm just guessing...
but I think it may not like the spaces in the names. Try taking out the spaces :-)

Not to mention the long search path...

Title: Re: Why like this
Post by: Keith™ on March 07, 2007, 08:14:18 AM

I would suggest shortening the path to the file as well.

Title: Re: Why like this
Post by: Adesu on March 07, 2007, 06:52:38 PM

Hi Keith™ and  Arizona,
That code has solve,it contained a password.

Title: Re: Why like this
Post by: Keith™ on March 07, 2007, 08:31:52 PM

strange .. I use passwords to protect VBA projects regularly without incident.

Title: Re: Why like this
Post by: Glenn R on March 07, 2007, 09:41:06 PM

The second screen caption also shows that it's in a different location to the first screen cappy with messagebox.

Title: Re: Why like this
Post by: JohnK on March 07, 2007, 10:34:29 PM

Man you got a lot of buttons!!

Title: Re: Why like this
Post by: Keith™ on March 08, 2007, 08:25:22 AM

Ok .. I'll bet I know what happened ...

In VBA you can set a reference to the current project .... that reference is hard coded to the path of the vba file. The reference cannot be updated unless the project has full access.

Understood now ...

Title: Re: Why like this
Post by: Guest on March 08, 2007, 08:59:24 AM

Quote from: Se7en on March 07, 2007, 10:34:29 PM

Man you got a lot of buttons!!

I thought FOR SURE you were going to comment on the subject text.   :-D

Title: Re: Why like this
Post by: Adesu on March 08, 2007, 06:45:20 PM

Hi Keith™,
After I posted to my friend,that code contained a password,then he reposted code without password.

Quote from: Keith™ on March 08, 2007, 08:25:22 AM

Ok .. I'll bet I know what happened ...

In VBA you can set a reference to the current project .... that reference is hard coded to the path of the vba file. The reference cannot be updated unless the project has full access.

Understood now ...