Trim is in the "Visual basic for Applications" library.
This may need to be moved up to the top of the references.
Best Regards
David Grugeon
Excel VBA Group Moderator
-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of laertetrad
Sent: Thursday, 11 October 2012 8:27 PM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Re: Trim not working / missing reference, project,
library
Hi David,
I guess that the problem is not languages. The script was working all right
till I had to reformat and reinstall all software. I did a full system
recovery, thus, setup is the same as before. I keep using the same
spreadsheet from my external HD.
in Me.Nome.value, Nome "name" is my form variable.
I remember that when I found the script I based mine on, it said I should
enable some reference, but I can't find any reference to this now.
I'm sending you the full script to your personal e-mail address.
Laerte J Silva
--
----------------------------------------------------------
tradutormg@gmail.com - ljstrans@gmail.com
laertejs@ljstraducoes.com http://juramentado.ljstraducoes.com (31)
3498-6020 - 9992-8118
----------------------------------------------------------
[Non-text portions of this message have been removed]
------------------------------------
----------------------------------
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
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
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