Removing Of/And/The from Acronym Function
Someone kindly provided me with:
Function FrstLtrs(MyStr As String) As String
Dim i As Long
TmpStr = Split(Trim(MyStr))
For i = 0 To UBound(TmpStr)
If Asc(Left(TmpStr(i), 1)) >= 65 And _
Asc(Left(TmpStr(i), 1)) <= 90 Then
FrstLtrs = FrstLtrs & Left(TmpStr(i), 1)
Which worked great but didn't ignore The/And/Of if capped. So I found some
code that should have worked
If Not (UCase(TmpStr) = "OF") And Not (UCase(TmpStr) = "FOR") And Not
(UCase(prom) = "THE") And _
Not (UCas...Exporting add-in containing dll functions to other computers
I developed an add-in for excel 2000 containing wrapper functions for a
dll I made as well. Now I'm trying to export this add-in to another
computer by copying the add-in to the other computers add-in folder(ie.
C:\Documents and Settings\"YourUserName"\Application
Data\Microsoft\AddIns) and placing the dll I developed to the windows'
system32 folder. Even though I do this something goes wrong and I get
only an error report #Value! for every function I try to to use. The
add-in works just fine on the pc I developed this add-in on.
If you have any idea please...how do i add up time to total hours? #2
Thanks But None Of That Is Working. I Get Either A .233 Or 12:00 Am
Any Other Suggestions?
CRGHTNSOCR's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1659
View this thread: http://www.excelforum.com/showthread.php?threadid=31455
What exactly do you want to get?
Give some example data and results.
(remove nothere from the email address if mailing direct)
"CRGHTNSOCR" <CRGHTNSOCR.email@example.com> wrote in message
news:CRGHT...Add New User
I logined as system administrator and tried to add a new user.
Here is what I did:
1. Settings--> Business Unit Settings-->Users-->New User (Create on New User)
After filling the new user information and clicking save, an error message
came out " Access Denied : You do not have sufficient rights and privilieges
to preform this action"
Can anyone tell me what's going on and how to fix the problems?
Are you logging after fresh CRM installation? If yes, You need to first
associated License with system administrator.
> I logined as sys...Can a vbscript identify the program/process that called a vbscript
I would like to code a vbscript ("ActionScript.vbs") in such a way that it
would do X, if ActionScript.vbs were called by "TriggerScriptA.vbs", but do
something else if ActionScript.vbs were called by "TriggerScriptAB.vbs".
Is there some way by which ActionScript.vbs could identify the
program/process that called ActionScript.vbs?
If the answer is "yes", that would be useful in many contexts.
For example, it would be useful in the context of Hta programming, where (I
think) a button (that calls a vbscript inside the Hta file) cannot se...How to add 2nd domain to Exchnage
Hi, I have a small office with one Exchange 2003 server currently
hosting the domain from my in-house Active Directory. I wish to add
another domain that my Exchange server should handle, does anyone know
how I would go about it?
Add it to the Recipient Policy - it tells Exchange which domains to accept
inbound email for, and creates email addresses.
If all users in your Org (that get picked up by your existing Recipient
Policy) need the additional email address, you can simply add the new domain
to the existing Recipient Policy. If intended for different set of users,
create a new Recip...Help needed with Date Add function
I have managed to get myself completey confused please help
I am trying to work out my recall time on listed equipment (when is it
Here are my fields
[Plant] - with unique ID
[Date] - date of last service
[Scale] - time in months of next recall (ie 6 or 12)
So lets assume its the 1st Jan, I need something to show anything that is
due/overdue from the end of the calender month (Jan 31st) using the original
service date+time scale which will also pick up those still not sorted from
previous months (Dec/Nov etc) - if that makes sense
SELECT Plant, [Date], Sca...Add GAL to each users Contact list in Outlook 2003
How do I add the GAL to my users contact tab in Outlook 2003.
Why not use Offline Address Books?
<firstname.lastname@example.org> wrote in message
> How do I add the GAL to my users contact tab in Outlook 2003.
email@example.com <firstname.lastname@example.org> typed:
> How do I add the GAL to my users contact tab in Outlook 2003.
The GAL is not Outlook ...Remove formatting from SSN
I exported some data from an Access database. The Social Security Numbers
are in this format: 123-45-6789. I would like to change them all to
I've tried creating a Custom Format and formatting the cells, but nothing
changed. Tried setting the format of a new column, then cutting and pasting
or Paste Special into the new cells, but it keeps the old formatting. Is
there an answer?
Try this in a "helper" column:
To retain your leading zeroes.
Please keep all corres...Date Diff
> I am new to Access.I work for a multi billion $ company and believe it not
> have no expertise in Access.We have Access 2002.I created a table which has 2
> date fields.I would like to obtain the date difference excluding weedends.I
> would like to know the formula and how and where to use it.
Do a search on Weekdays. You'll find numerous threads relating to your
>> I am new to Access.I work for a multi billion $ company and believe it not
>> have no expertise in Access.We have Access 2002.I created a table which ...how can I change the value of Static Text in the dialog by the program?
how can I change the value of Static Text in the dialog by the program?
> how can I change the value of Static Text in the dialog by the program?
When you create the control, its name is IDC_STATIC. Change this to something useful, e.g,
Then use ClassWizard to create a control member variable; you should end up with
in your .h file as a consequence.
To change the text
Of course, the real string sh...Report showing WTD, MTD, YTD Sales
Does anyone have an item report showing:-
Item Week to Date Sales
Item Month to Date Sales
Item Year to Date Sales
If not can someone share a SQL query to get this information?
I am looking for the same thing.
Let me know if you find it.
"Jason" <email@example.com> wrote in message
> Hi All,
> Does anyone have an item report showing:-
> Item Description...Add-In for PivotCharts in Microsoft Excel97 (Urgent)
I have created some Pivot charts in MS Excel 200 with
page level fields. But my customer uses Excel97 and he is
not able to see the Page level fields and cannot see
different views of data. It seems that Pivot charts were
not available in Excel 97. Only Pivot tables were
Does anyone know of any add-in for Pivot chart that my
customer can use in Excel 97 and is able to view the pivot
charts as they are available in Excel 2000.
or if there is any other workaround, please let me know.
I'll appreciate an early response to this message as this
is very urgent.
Regard...Make Visio Add-In working in Debug Mode
Unfortunately my Visio Solution crashed during development. There it
was possible to start it out of Visual Studio just by hitting the debug
So I copied the source files to a new system in order to make the
devolopment possible again.
But if I start Visio and the Add-In there just by debugging it does not
register and the Add-In isn't available within Visio. If I build a
setup and install my solution it works again. But I'd like to check new
functionality in a fast way just by debugging.
Would the new machine have .Net Framework 2 installed?
If so, put...Add background music????
How do I add background music to a email. I want it to play a song when the
receiving person opens the email I sent to them.
Answered in the general newsgroup. Do NOT multipost!
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Create your own fully customized Toolbar
-Creating a Classic View in Outlook 2003
Subscribe to the newsletter to receive news and tips & tricks in your
(I changed my reply address; remove all CAPS and _underscores_...Installing Money 2005 Deluxe #2
Can anyone tell me if I can install one copy of Money on my desktop and laptop?
Microsoft seems to be keeping it a secret unless I pay $35.00 to ask a
In microsoft.public.money, Anthony wrote:
>Can anyone tell me if I can install one copy of Money on my desktop and laptop?
>Microsoft seems to be keeping it a secret unless I pay $35.00 to ask a
Yes. That is permitted.
Thank you, Cal. I've been all over Microsoft's Web site and couldn't find
anything on that.
I will purchase MS Money 2k5.
By the way, I have been using the trial vers...Can Form Show Only Populated Fields?
I've created a contracts database that allows users to insert a copy of their
contract as an OLE object. Some contracts have up to 10 amendments, so I've
created additional fields for each amendment.
Does anyone know how I can:
1. Have the form show only those fields that are populated? I don't want
all ten amendment fields showing if there's only one amendment.
2. Give users a way to identify the object they're inserting? I'm thinking
some kind of box might be necessary that says "What kind of object do you
want to insert?" Then the user chooses: C...Cannot Add
I have copied a column of figure from web in my spreadsheet.
Now when I try to add up those figure I get the result as Zero.
i have formatted them and still I cannot add them up.
Any suggestion will be of great help to me.
My standard answer:
Your Numbers don't behave (like numbers)
Niek Otten, May 11, 2006
Your numbers sort incorrectly, are not included in SUMs, cause #VALUE! results in formulas, cannot be found in LOOKUPs, etc.
Your Numbers look like Numbers, but they re...How to show all *new* notes (3.0)
I've been asked if it is possible to show all notes added to the CRM since a
given day. Particularly to see all new notes added in the last week or
month. I know this option does not exist natively, but I wondered if anyone
else has a working solution for this?
....I was able to create an "Advanced Find" for this, however, it's not the
greatest solution. Any other thoughts out there?
"Graeme Canivet" <firstname.lastname@example.org> wrote in message
> I've been ...Outlook Security
I have a new install of Windows XP with Office 2003 with all the patches
If I use Word as the default e-mail editor, when I click on reply, I get the
following popup box.
A program is trying to access e-mail addresses you have stored in outlook.
Do you want to allow this?
If this is unexpected, it may be a virus and you should choose no.
We have antivirus running, and we were using barracuda spam filter but we
unistalled it and we still get the same error.
I tested it out - the issue is with Adobe Acrobat 6.0 - I tried going into
word and unchecking the add on. That...how to add automatic numbering attributes in a customization entit
how to add automatic numbering attributes in a customization entity ?
This will involve creating a custom field with the proper type and then via
> how to add automatic numbering attributes in a customization entity ?
...Adobe add-in error
Has anyone recieved an error from publisher like this before. I was just
opening publisher and this is what it said
"Publisher experienced a serious error the last time the add-in 'acrobat
pdfmaker office com addin' was opened. Would you like to disable this
add-in? To reactivated this add-in, click About Microsoft Office Publiser on
the Help Menu, and then clic Disabled Items"
It is a common error. You really don't need the Acrobat icon on your toolbar.
This error doesn't affect the PDF printer. Try enabling the PDF maker, it maybe
okay now. What are your ...ExceL Options: Add a chart for Box-plot type and Range function
I am a Process Engineer in a semiconductor manufacturing facility. I have 2
1. I use extensivelly a range calculation which is simply the maximum value
minus the minimum of a population. It would be very useful to have a function
(called range) to have it done at once instead of having to type max()-min().
2. For populations comparisons we use box plots. It would be nice to have a
chart type for box plots.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this sugge...Add % to a graph
Can you add a % sign to your graph information? I have three rows, 2008,
2007 & % inc/Dec. I can not get the % sign to show on the graph.
Where are you wanting this? If as a series legend or an axis title, you can
include any text you like.
"Marie" <Marie@discussions.microsoft.com> wrote in message
> Can you add a % sign to your graph information? I have three rows, 2008,
> 2007 & % inc/Dec. I can not get the % sign to show on the graph.
The easiest way is to format the ori...cash back add in
i am looking for a loyalty program where i can give customer a 10% cash back.
i like the cash back to apply next month on their card for all the
purchased they made this month. i like the happy checks idea from retail
hero but instead of sending checks i like to apply the cash back their cards
automatically everymonth. that way we dont have to do any work and save
their addresses or anything.
any advise? thanks, jay