"Nome"?
I assume you normally have your computer set to work in Italian?
I suspect that your new PC probably still thinks it's working in English.
Can be tested easily enough by changing your statement to
If Trim(Me.Name.Value) = "" Then
and see if it gets further before complaining again.
Don't know if there will actually be a missing reference or library. I'd
anticipate that setting the PC to Italian will resolve it.
If not, then you can always look in the References list in the VB editor
(stop the execution first) to find out what is missing, because it will be
shown as missing.
Regards, Dave S
----- Original Message -----
From: "tradutorpublico" <laertetrad@gmail.com>
To: <ExcelVBA@yahoogroups.com>
Sent: Wednesday, October 10, 2012 10:40 PM
Subject: [ExcelVBA] Trim not working / missing reference, project, library
> Hi
>
>
> I'm using my spreadsheet in a new PC and now the Trim function is not
> working [ If Trim(Me.Nome.Value) = "" Then] and I get the message the
> reference, project, library is missing.
>
> Which reference must be enabled for it to work?
>
>
> How can I install it if is missing? I've tried reinstalling excel, but it
> didn't help, neither has the help/detect & repair.
>
> I appreciate your help.
>
>
> Laerte
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search
> the ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1427 / Virus Database: 2441/5321 - Release Date: 10/09/12
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar