Trim removes spacing in the beginning and end of word.
How can i delete a spacing betwee two words (name) ex "De Wit" > i want
You can use:
to remove all the spaces (leading/trailing/embedded)
if you really wanted lower case.
Luc Vandenhoeck wrote:
> Trim removes spacing in the beginning and end of word.
> How can i delete a spacing betwee two words (name) ex "De Wit" > i want
> THX Luc
...Limitations to # of Decimal places for seconds (time)? #2
Bernie Deitrick Wrote:
> Are you really recording every 1/10 millionth of a second? And, yes
> limits you to three decimal places on the seconds
> Thanks a ton for your help, Bernie. I guess this is what I have to do.
And yes, the system does log time to the accuracy of 6 decimal digits.
Thanks and Regards,
Xprezons's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1505
View this thread: http://www.excelforum.com/showthread....Excel VBA
I have enclosed a timesheet which i want to break down the day
activities by a percentage, so if my sheet says an activity took a
hour then the day column would tell you percentage of a seven hou
Also i want the date column date to change each day. Currently it work
for one day but then the next day it changes all the above cells to th
I have attached the file
Attachment filename: book2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56396
Message posted from http://www.ExcelForum.com
...Public Folder Auto-reply #2
Is there any way that I can enable an auto-reply for emails that are going
to a Public Folder that is mail enabled. The emails will not only becoming
from inside th company but externally as well.
Thanx for the help
yes, you can...on the Administration tab, click Folder Assistant...but be
very cautious with this...it's very easy to get into a "mail loop" condition
that could conceivably crash the store...
Susan Conkey [MVP]
"Sulaiman" <Sulaiman@discussions.microsoft.com> wrote in message
news:9E3D127F-2CBE-40D3-9AC3-333F3D25B465@microsoft....outlook mobile access broken #2
I noticed this morning that my OMA was give ASP application error
reports when a device tried to connect.
I put it down to changing the installed .net framework at the end of
last week - using the aspnet_regiis.exe command located in the C:
\WINDOWS\Microsoft.NET\Framework directory, I changed from v1.1.4322
So I reverted back to v1.1.4322 hoping it would resolve the issue, no
all I get is a 404 page not found - even though there are files there
- now I'm a bit stumped.
What is going to be the easiest way to fix/repair/recreate this
Any pointers would ...Creating New Mailboxes #2
ANYONE KNOW WHY AFTER CLICKING CREATE MAILBOX FROM THE EXCHANGE TASKS ON A
USER IT TAKES UPWARDS OF 1-2 HOURS BEFORE THE MAILBOX APPEARS?
ADVICE/INFO GREATLY APPRECIATED.
Before the mailbox appears where, exactly? In the GAL? In ESM?
For Exchange news, links, and tips, check:
"PHIL MATHER" <PHIL MATHER@discussions.microsoft.com> wrote in message
> ANYONE KNOW WHY AFTER CLICKING CREATE MAILBOX FRO...Macro for checkbox (2) #2
Still does not work new message is Sub or function not
defined. I normaly just record macros so this is a bid
more of a chalange
If CheckBoxes(46).Value = True Then
Range("O54").FormulaR1C1 = "50000"
Range("T54").FormulaR1C1 = "4000"
Range("Y54").FormulaR1C1 = "4000"
Range("AD54").FormulaR1C1 = "4000"
Range("AI54").FormulaR1C1 = "4000"
Range("AN54").FormulaR1C1 = "4000"
Range("AS54").FormulaR1C1 = "...PatchFactory 2.0 Released. Professional and easy-to-use patch building tool for Win9x/Me/NT/2000/XP.
Professional and easy-to-use patch building environment that can help
you to create instant patch packages for software and file updating.
Generated patch packages are small size self-extracting executable
update programs in a famous installer style with adjustable
user-friendly interface and multilingual support.
Enhanced with features like easy-to-use interface including a Wizard
mode, powerful patch engine, integrated compression technology,
adjustable multilingual user-friendly interface of the update program,
this program will most definitely become a valuable asset for softw...Conversion from Quicken2001 Issue
I've just bought Money 2004 Canadian version, been using
Quicken 2001. Trying to convert from it, but cannot
because the file is corrupt. Did the validation on the
Quicken File fine, but still won't. Any ideas????
...rpc over https issue
I have successfully setup outlook 2003 to connect to exchange 2003 via rpc
over https using basic authentication. But everytime
I start outlook it prompts for a username and passwd.
Is there anyway to save the credentials so I dont have
to enter them everytime ?
anand <email@example.com> wrote:
> I have successfully setup outlook 2003 to connect to exchange 2003
> via rpc over https using basic authentication. But everytime
> I start outlook it prompts for a username and passwd.
> Is there anyway to save the credentials so I dont have
> to enter them everytime ?
No, no...beginning balances #2
This is a new client who is entering invoices and data as of 2006. There
are two open fiscal years--2005 and 2006.
We created 2005, as the client will need to enter beginning balances for 2006.
I just want to make sure that I have the correct steps down. In order to
enter beginning balances for 2006, they need to:
(1) In GL Transaction Entry, enter a debit or credit to the balance sheet
account and a debit or credit to Retained Earnings (or a suspense account) as
of 12/31/2005 and
(2) They need to close 2005 in the GL, so those beginning balances (BBFs)
will roll forward to...Variant #2
I have a VB6 Com object that I am attempting to use in VC++. One of the
methods returns a VB6 Variant datatype. When I look at the IDL for the object
that value is also defined as a VARIANT*.
The problem I have is I am not sure how to deal with this value on the C++
side. What datatype do I use to store this value. Unfortunately, I can really
be almost anything. Do I need to store it as a byte array?
Any help would be appreciated. Thanks!
>I have a VB6 Com object that I am attempting to use in VC++. One of the
>methods returns a VB6 Variant datatype. When I look at the...I screwed up. How do I fix it?
I started the install of the CRM Server and got to the page where it as for your Account Name and Liscense. I cancelled without putting anything in because I had not installed the MDAC componet.
After installation of MDAC I went back in to install and now get an "Can't determine your account name" error that I have been unable to get past.
I looked in Add/Remove programs to see if there was something there that might get me back to where I could put in the account name but either I am missing it or it's not there.
Any advise you might give me to solve this issue would be ...FRx Forecaster #2
In a Calc Set when a range of Accounts is used the Calc set does not work
(Calc = '1000..5000')
Have followed all the TK and it does satisfy all the requirements for a Calc
Set to work.
Any suggestions would be highly appreciated.
Thanks in advance
Ajay-- is the variable on the left side a valid Account? (i.e., does 'Calc'
exist in the list of accounts, and in the lineset?
Also, check the syntax in the actual calculation. It should read
with the single quote in front of the variables.
&...Help with combining 2 seperate Worksheet Change Event scripts
I have 2 seperate Worksheet Change Event scripts that I would like to
combine to use in one woeksheet and I'm sure how to do. I am kind of new to
The first script is for hiding columns based on a value selected in picklist.
Private Sub Worksheet_Change(ByVal Target As Range) 'SalesAid Software
If Target.Address <> Range("L2").Address Then Exit Sub
If Target = "All" Then
Range("N:BV").EntireColumn.Hidden = False
lastcol = Cells(6, Columns.Count).End(xlToLe...How do i get notifications of Issued Certificates thats nearly Exp
I know of certutil but havent found a guide for it and i dont know how to
vbscript its so i can find Certifcates thats about to expire.
...Exchange 12 UM-Email
How many Exchange servers do you need if you want to use Exchange as a UM
server and your Email server?
With all the configurable Roles Exchange server now has which ones are need
to accomplish what function?
At the launch event, they strongly recommended that the unified messaging
stuff be on its own server.
"VIDRO" <VIDRO@discussions.microsoft.com> wrote in message
> How many Exchange servers do you need if you want to use Exchange as a UM
> server and your Email server?
> With all the configurab...row height #12
My default row height is set at 13.20 and it goes up and down in .6
increments. Everyone else in my office has the default as 12.75 and it goes
up and down in .75 increments. Our fonts are exactly the same, and every
other option we could think of is the same, where can I adjust this?
Open a new workbook and make the desired change to row height, save the
workbook in C:\Program Files\Microsoft Office\Office10\XLStart as
Book.xlt (or wherever located on your system). Make sure you move and
save the original Book.xlt first in case you decide to restore the
I don't ...Report WRITER legends values #2
I need to modify existing modified report. Where can I find values for
Hello Sofiya, Legend fields are placeholders that may contain pretty much
anything, depending of the report you are working with.
For example, on many reports, they are used to display the range values used
when generating the report. (From-To)
One thing you must remember though is that they are always typed as strings
so you need to convert them if you want to do any arithmetic operations with
In conclusion, if you want to evaluate the legend field values for a report,...Data validation causing problems when using a data form in Excel 2
I have an Excel 2007 workbook that includes data validation set on a number
of cells. When using a data form to enter data and I enter an invalid value
on the form field corresponding to one of those cells I receive the
validation error dialogue that prompts me to retry. I enter the correct data
into that field on the form then close the form. My worksheet only has the
data relating to the corrected field entered. All other data entered via the
form is not entered onto the worksheet.
Is this a bug in Excel 2007? I previously was using Excel 2002 and found
that when using a ...Random connection issues!
My cust has random connection issues with the Microsoft Outlook
Connector (MOOL). Is there any reason why this could happen?
Here is what the log file states:
Outlook Connector Version 1.6.1601.0
Session timed out. Automatically re-signed in at 5/10/2005 08:31:14
Mail: Error at 14:45. Last successfully refreshed at 10:43.
Calendar: Error at 14:43. Last successfully refreshed at 10:43.
Contacts: Error at 14:43. Last successfully refreshed at 10:43.
Time: 5/10/2005 11:31:17
Error in Mail
Network operation failed
Time: 5/10/2005 11...Project Green #2
Those of you counting on or worrying about Project Green
might want to check out the rants and replies on this
forum on the Sept 20 subject entitled ".Net Plans?".
...Need Help #2
I have created a custom button for Tag along item.and I am having problem
with cursor box. It is not moving down. It is staying where the tag along
item rang up.
It should move down to empty line, But It is not. How Can I fix his problem.
Any one can help me ?
...Rootkit author offer fix for MS patch problem
"According to security vendor Prevx, the authors of the rootkit which was
the cause of a large number of unbootable systems which applied the MS10-015
patch issued last week have issued a patch to fix the incompatibility."
All your roots belong to us...
> "According to security vendor Prevx, the authors of the rootkit which
> was the cause of a large number of unbootable systems which applied
> the MS10-015 patch issued last week have issued a patch to fix t...Need to take out checkboxes from from some items of the listcontrol.. #2
I have a listcontrol in which i want to have checkboxes for only
For that i m trying ,
m_cListCtrl.SetItemState(nRow , LVS_EX_TRACKSELECT,
which is not working.....
PLease help me..
Lotz of thanx in advance,
This link may be useful