X Error Bars appearring when it is not set
I am using the ErrorBars in my chart. I only want the Y
Error Bars to show on my chart and I set it correctly in
my program using .ErrorBar Direction:=xlY but it appears
as a bug in Microsoft Excel Macro.
I tried the method in Article 157110 of the Microsoft
Knowledge Base to remove the erronously set X Error Bars
as follows and it doesn't seem to work:
Application.ExecuteExcel4Macro ("SELECT(""Series 1 X Error
What else should I check or what other method can I use?
Is this problem corrected in the the latest Microsoft...parsing a date and time field #2
I am having trouble parsing the date and time in a field. I download
data from a data base and the date and time come together in one
field. I want to seperate the two. The date and time comes across as
the following: "2/1/2009 14:37" in the cell. When I parse it, it
seperates into three columns as follows: "2/1/2009", 2:37 AM", and
"PM" I can see what is going on but I would like to get two columns
with one as the date and the other as the correct time. are they any
ideas on how to address this?
Try using the TimeValue and DateValue functions.
First format ...Public information store
Exchange 2K-Under the Properties for a new public folder I have created, the
Directory Rights tab is grayed out.
Any input would be appreciated
On Tue, 12 Jul 2005 12:01:03 -0700, "Joe M"
>Exchange 2K-Under the Properties for a new public folder I have created, the
>Directory Rights tab is grayed out.
>Any input would be appreciated
Its grayed out until you mail-enable it.
...how to set the worksheet direction in Excel XP
in a right-to-left interface the vertical side showing the row numbers of the
excel worksheet appears on the right side of the sheet. how do I change it'
to appear on the left side?
does tools / options / international - default direction ... help?
"inbal" <firstname.lastname@example.org> wrote in message
> in a right-to-left interface the vertical side showing the row numbers of
> excel worksheet appears on the right side of the sheet. how do I change
> to a...Set a range from a variable location
I am using a loop function that will eventually select and activate a
specific cell known as "TheCurrentCell." Once I reach that location I want
to use that coordinate as the upper left area of a new range. Supposing that
the end cell of my range is D1000, the Range selection would be something
like Range(TheCurrentCell:D1000).select, however, I don't know the correct
syntax to make this happen.
Please help. Thank you.
Use something like Range(Selection.Address & ":D1000").Select.
"Troubled User" wrote:
> I am using a loop function that will...Money: Err Msg: Path Has Not Been Properly Set Up
Microsoft Money. The path is not properly set up in the registry or has been
moved after running Money's Setup. Please re-install Money. Otherwise, Money
may not be able to run properly.
re-instal wont help
deleting registry entry dasn.t help.
windowx xp sp2 Ms Money 97 (v.5.0)
Are you using an administrator account to run the software?
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://registe...Outlook 2003: Most messages are moved to junk folder
I am getting a lot of spam recently, at least looking at the numbers of
mails in my junk folder.
However, it turns out that these messages are not spam at all, but just
regular messages (even from the same domain), that should remain in the
regular inbox. Even when I identify a message as 'Not spam', then
subsequent messages from that sender keep popping up in the junk
Obviously I have changed the junk mail settings to 'No automatic
filtering' but Outlook keeps thinking it is smarter than I am.
Any idea? Googled the internet already but couldn't find anoth...Money Central Portfolio #2
My print function has gotten corupted. When I print it flips to WORD / format
and prints in a format that is 4x normal.
I am pretty new to using (or attempting to use) a Macro in a workbook. I am
having trouble following how and what to do to even start the process; ie If
there needs to be a worksheet already in progress or can I start from a new
THEN where to go from there.
Can I have some help in this area? Can some one supply me with a sample
Any help would be greatly appreciated
The best way to get started with macros is to use the Macro
Recorder. Go to the Tools menu, choose Macros, then Record New
Macro. Then, carry out some simple tasks and examine the code
that is produced.
...merging 2 cells without losing data?
How can I merge 2 cells without losing data from the other cell?
Not possible I'm afraid. Try placing the dat from both cells into one
and use "Center across selection" under Format>Cells>Alignment
Merge cells always end up causing grief. they are best avoided.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"bob" <email@example.com> wrote in message
> How can I merge 2 cells without losing data from the other...Statements #2
How are statements sorted? Alphabetically by name or by account number? Does
Any help is appriciated, Deb
Mine are done alphabetically by name.
"Deb" <Deb@discussions.microsoft.com> wrote in message
> How are statements sorted? Alphabetically by name or by account number?
> anybody know?
> Any help is appriciated, Deb
...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email firstname.lastname@example.org ��and
windows2003 + exchange 2003 Server "B" email@example.com user name is same in A
B��Mx record was be set ,question is how to config Exchange 2003 to receive
down the mail to Server A , because of we need to replace A with B.
thanks a lot.
E2K3 setup guides you through common scenarios (like yours) pretty much holding
your hand - on welcome screen tell it that you have existing E55 org and want to
join it, then follow on-screen instructions. Having usable backup of Exchange
databases and AD i...seperate accounts to seperate folders?
Hi I just had a quick question...
I am currently using Outlook 2003, and I have 2 pop3 email accounts se
up in my outlook.....one of them is my personal company email and th
other is the general comapny email address (which i am responsible fo
checking). What i am trying to find out how to do is, is it possibl
to have the general company email messages go directly to a seperat
folder besides the inbox? I still want my personal company email t
come to the Inbox folder, but i want the general company email to go t
a folder called "SCS." Any help would be greatly appreciated! Thank...Deleted items folder in o2k3
The big boss refuses to empty or archive his deleted items, now holding some
25,000 messages and approaching 3 gigs in size for the deleted items folder
Does Outlook treat messages in the deleted items folder any differently than
messages in other folders? Would it be better for him to never delete
messages since he doesn't really want to delete them?
It would be better to not delete them since Deleted Items... is for things
you want to get rid of.
"Wowbagger" <none> wrote in message
> The big boss refuses ...retrieving folders.old file
probably been posted before, but need some help. i was
getting the "MSIMN has caused an error in directdb.dll" i
found the solution by renaming the folders.dbx file to
folders.old. here's the problem, i opened express back up
and my sent folder was empty. my question is, how or can
i retrieve that old sent message list??
...setting to have email saved on Exchange server instead of PST
In Outlook 2007, is there a setting to have all the email saved to an
Exchange Server rather than to a PST file?
Set the default delivery location to the exchange acct in tools, account
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
You can access this newsgroup by visiting
http://w...Public folders #9
I'm looking for a tool or a methode that can write all the properties of the public folders to a file
Now I'm doing ik manual, but it isn time-consuming
Can anyone help m
"cisca" <firstname.lastname@example.org> wrote:
>I'm looking for a tool or a methode that can write all the properties of the public folders to a file.
>Now I'm doing ik manual, but it isn time-consuming.
>Can anyone help me
PFADMIN or PFINFO can do this.
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
...Setting up my work outlook account at home
I do not know how to set-up my outlook at home to check
and receive email at home.
This is really a question for your Mail Administrator.
This depends on what ISP is used for work or if you
use the Exchange Server. Then there may be a domain
Nikki Peterson [MVP - Outlook]
"Liz" <email@example.com> wrote in message
I do not know how to set-up my outlook at home to check
and receive email at home.
A customer brought his laptop from work and added it to
his SBS 2000 network. Now he can not get to his old mail
or contacts. The operating system is Windows XP Pro. His
Outlook is also XP from Office XP Pro. He did not create
a PST file prior to adding the laptop to the network. I
belive his old mail and contects are still there but in a
different profile. I can not find them in the Office 10
folder. Can anyone tell me how to recover his old
contacts and mail or piont me to a Knowledgebase article?
Here is one for you experts - I am a novice
I want to add a macro to a worksheet that will print selected information
held on certain rows of the worksheet.
Once the 'button' has been selected a mesage box will pop up asking the user
to input which row number he/she wishes to print.
On input that number is matched to the corresponding row of the worksheet
and that row is copied (without any formula - just cell values) and pasted
into another worksheet where it is placed into other formats and printed.
Seems like a simple(!!) job - but far to difficult for me to programme
Can an...Customizing Excel's Border Defaults
I'm working with Excel 2000 and use Borders frequently.
The preset default border is a thin line, yet I prefer
and always change it to the thick line. How can I change
the Excel default to the thick line rather than the thin
line? I know it's a small problem, but it's driving me
crazy changing it all the time. In WORD, I know how to
easily "add style default to template", but can't figure
it out in Excel. Any help is greatly appreciated!
...Business contact manager install failure
Office 2007 BCM gives me this error when I try and install it:
Setup cant finish because it can't delete:
c:\Program Files (x86)\Microsoft SQL
...Set default address book automatically (registry)
I know I have done this before a few years back in another site - but
I cant remember how.
We need to set the default lookup address book for all our 2000+ OL2k3
users and to use a specific lookup order. I know they could each do
this manually but we have 2000+ users and the support overhead would
be huge. We dont want to users to use the GAL as their default lookup
(which it is out of the box) because it contains lost of confusing
system addresses and duplicate names for the same person in different
security level networks; which the users find VERY confusing to
We wan...Replicating folders
I am having a strange issue with tasks replicating for no
apparent reason. Outlook 2002 on Windows XP. Anyone run
across something like this before? Deleted 34 blank
tasks and the next day there were 14 new ones.
...Sum amount if = 2 value's
I have a spreadsheet of payment types for which I want to sum the tota
amount per type per month
A B C
Type Amount Month
I'm able to get the total amount per type by usin
=SUMIF(A:A,"TYPE",B:B), but can't work out how to get a total for eac
type each month
Somthing along these lines: =SUMIF((A:A,"TYPE",B:B)&C:C,"MONTH")) ????
loscherland's Profile: http://www.excelforum.com/member.ph...