how do i change tick marks of excel graph from vb.net
I'm trying to change using VB.NET the tick marks from their default outside
position and place them inside the graph. How can this be done?
...Team Folders migration from 5.5 to 2003
Are there any known issues with migrating Exchange/Outlook Team Folders from
Exchange 5.5 to Exchange 2003 using PFMigrate? We have many Team Folders on
our older Exchange 5.5 server that we MUST migrate over to Exchange 2003
with full functionality
These are Team Folders created with the Team Folders Wizard? I don't know
whether PFMigrate will migrate the folder home page setting and the custom
form that a couple of the folders use. You may need to handle those
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
How do I find out what Exchange hotfixes have been applied to an Exchange
5.5 (SP4) server (running on Win2k)? Is there a utility I can run to detect
them? Or are they listed in the registry (in a common location hopefully)?
yes if you check in the add/remove programs ,you should
see all the hotfixes listed there .They will have a Q
number appended .
>How do I find out what Exchange hotfixes have been
applied to an Exchange
>5.5 (SP4) server (running on Win2k)? Is there a utility
I can run to detect
>them? Or are they lis...esm shows wrong exchange server version
I have an Exchange 2000 Installation with SP3 + Rollup package 870540-v2 +
Exchange System manager still shows Build 6249.4 SP3.
Should ESM show a higher Build number ?
Thanks for any replies.
IIRC, ESM only shows SP4 on clustered servers that have the update applied
For Exchange news, links, and tips, check:
"MC" <email@example.com> wrote in message
>I have an Exchange 2000 Installation with SP3 + Rollup package 870540-v2 +
...Cannot show, import, export userform: error &H80004005 / component is not corretly installed
Please, help me! I can not find where is the the information I need.
My problem is:
I had Windows 2000 and Office 2000.
Now they installed Windows XP and Office 2000 (serv.pack 3).
And my forms do not work anymore!
The error message says nothing useful, only:
1) the component is not corretly installed (ok! but it's a common form
with only normal windows common buttons and labels, not a single
userparty creative control)
2) error: &H80004005 -2147467259
3) memory insuficient (ahah, at 512 Mb, only Excel running... )
4) can not set OleObjectBlob property
But if I try to open the...Exchange 2000 DST Changes
How is one supposed to address the DST changes for Exchange 2000 if
they do not have extended support to get the patch? Will Microsoft be
providing a workaround like they did for Windows 2000?
I'm referencing the following article:
It states :
What to do before you run the Exchange tool
Install DST updates
Before you run the Exchange tool, make sure that client and server
computers are updated correctly with the operating system and
application DST updates. These updates must be installed in the
1. Install the Windows DST upda...Excel, how do I change the column headings from letters to number
I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?
Go to the Tools menu, choose Options, then the General tab.
There, uncheck the R1C1 reference style setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"lazybee" <firstname.lastname@example.org> wrote in message
>I have a spreadsheet that has numbered columns as opposed to the
> letters. How can I change this ...How do I freeze or lock cells to show up on each page without typ.
I have a 4 page sheet. I have a header already. But I want to freeze the
cells that head up the first page. I've done it before in school but can't
remember what it is called or how to do it...that's why I'm doing this.
Anyway, I want these cells to print off on each new page without having to
type them on each page. I hope that makes sense and I hope that someone can
If you mean for printing do file>page setup>sheet and select rows to repeat
otherwise for viewing you can select a2 if the headers start in row 1 and do
window> freeze panes
...Exchange 5.5 to 2003 upgrade issue 3
We have upgraded our Exchange 5.5 server to 2003 and moved all the mailboxes
and moved and re-homed the folders following the KB articles.
We turned off the 5.5 services and for a week everything was working fine.
Now for some reason the messages to the main distribution list is being sent
to the old 5.5 server on a x400 protocol.
How can I stop this and assure that the 2003 server is self contained so I
can get rid of this server?
...Changing Item #'s
Is it possible to change the item #'s after the item has already been entered?
No there isn't in the "base" product, but MBS does have a tool that you can
use called Item Modifier - this will allow you to change an Item number from
one value to another.
You can email this address below and they can answer any questions you have
about the tool and can tell you what the cost of it is.
Hope that helps you out,
> Is it possible to change the item #'s after the item has already been entered?
...How do I setup an SMTP gateway / smart host for Exchange 5.5 internet bound mail
My current setup has a Windows NT 4.0 Exchange 5.5 server setting on our
company LAN behind a Microsoft ISA Server. The Exchange server's Internet
Mail Connector binds to (I assume this is the proper terms) port 25 on the
ISA server for inbound and outbound Internet Mail.
Our company has finally upgraded to a new Cisco Pix Firewall which we are
able to setup a DMZ on. The suggestion by our ISP is to setup an SMTP
gateway in the DMZ and have our internal Exchange server send mail to it
destined for the Internet.
I am aware that most of the work for making the connections from the SMTP
...Data Validation List not showing
I'm using Excel 2003. My data validation lists have stopped working on one
sheet in my workbook. It is working on all other sheets.
I have googled the problem and found the following advice:
1. Make sure freeze panes is off.... check.
2. Select "Show All" under Tools->Options->View->Objects ... check.
The problem remains. Any ideas?
"Stopped working" doesn't do much to describe your problem. When you select
one of the "stopped working" Data Validation cells, do you see the drop-down
arrow to the right of the cell? When you select t...Messenger emoticons
I have changed laptops and I did grab the old laptops custom emoticons
folder (all in dt2 and id2 file endings.) But when i copy everything in
the folder and add it to my new laptops custom emoticons folder... they
get added (i.e. show up in the folder) but the images/gifs or names dont
show up on the actual msn... *what gives*?
Do I have to change the dt2 endings to gif or jpeg and go to "create" in
msn for each of them to add them in? (I tried with one and it worked)
Only problem is i have alot, like 203 dt2 files so changing the ending
to .gif and adding each singu...Can't receive EMail #5
Keep getting this pop up along with 'server did not
connect within 60 seconfs, do I want to wait
A time-out occurred while communicating with the server.
Account: 'Richard', Server: 'pop.east.cox.net', Protocol:
POP3, Port: 110, Secure(SSL): No, Error Number: 0x800CCC19
Please reply using email@example.com
please read this information from Microsoft
Ich habe nichts gemacht, gestern gings noch!
Bitte in den Newsgroup antworten damit jeder etwas davon hat.
Bravestar@Datenschutzminis...Backing Up Outlook #5
How do I backup copies of all mye-mail folders? Hod do I
backup all my contacts within the address book?
You can do a total backup of your Outlook PST file using
a back up program in Outlook.
To download the ad in go to
If you have trouble email me at firstname.lastname@example.org
>How do I backup copies of all mye-mail folders? Hod do
>backup all my contacts within the address book?
"Damon" <damo...How do I import from LotusOrg 6.0?Import command only has 5.0
I am trying to import my calendar data from Lotus Org V6.X. Under the file
command, it will only import from V5.X. Does anybody have any help for me
since I would like to convert to Outlook from Lotus Organizer.
DonAlbert <DonAlbert@discussions.microsoft.com> typed:
> I am trying to import my calendar data from Lotus Org V6.X. Under
> the file command, it will only import from V5.X. Does anybody have
> any help for me since I would like to convert to Outlook from Lotus
> ...emails not showing up in deleted items until i do a find?
This just started happening a last week. A message comes
in the Inbox and I click the delete key so delete it.. so
far ok. then i go into the deleted items folder it's not
visible. but if i do a find then they show up in the find
box but still not in the folder. any ideas?
this program makes me crazy sometimes *s*
starindy <email@example.com> wrote:
> This just started happening a last week. A message comes
> in the Inbox and I click the delete key so delete it.. so
> far ok. then i go into the deleted items folder it's not
> visible. b...Outlook 2000 client Connection TimeOut w/ Ex5.5 server???
Hi, we have a really intriguing issue that started recently.
Outlook users, when clicking on an item in the Mailbox, will get the message
"Can't open this item. The operation could not be completed because of an
error on the network. Try to log on to the network again, and then repeat
The user will click OK, and usually will be able to open the same item in
one or two attempts.
The Envrionment: Ex5.5 SP4, Outlook 2000.
It is ONLY the Windows98 users that is seeing this message, on NT and W2k
stations, there's this occassional hour-glass when we click on an ...Assistance with ESEUTIL ans ISINTEG on Exchange 5.5
I need to perform some maintenance on a exchange 5.5 server.
My users are complaining about speed, etc...
First, GOOD BACKUP!
Second, Take down all MS Exchange services
Third, I want to run "ISINTEG -s EXCHANGE -FIX" correct? This will
hopefully fix ant integrity issues. I am told to run it over and over until
it comes up clean..
Once the integrity check is clean...
Fourth, I run these three:
eseutil /d /ds
eseutil /d /ispriv
eseutil /d /ispub
If all goes well...
Finally, startup MS Exchange services..
This is my plan. Any suggesstions? Comments?
1) GOOD BA...How do I print a SINGLE POSTCARD on 5.5x4.25in stock?
I have a preprinted postcard that is 5.5" x 4.25". A standard postcard. I
cannot for the life of me to get Publisher to print on this cardstock!! It
keeps thinking the page is "LETTER 8.5x11".
I have NO problems getting 4 cards (multiple addresses) to print on one
page. But now I have the cards pre-printed and just want to mail-merge an
address list onto them.
How do I set this up? Because apparently, using the post card template of
5.5x4.25 (or even the 6x4) doesn't do it!!!!!
Thanks for any insight.
Here select your stock si...Changing named range reference depending on a cell's content
Where to start?!
I've got the following formula pulling data in from a secon
spreadsheet within the same workbook:
We have 8 different locations ("MICH" being one of them) that we nee
to be able to access. I can write a nested IF formula that looks a
cell I7 (that contains a list of all 8 locations) and, depending o
I7's content, brings back the desired values.
I was hoping someone in the forum could help me write a simpler formul
that would not have 7 IF statements embedded in it.
Any help w...Stop changing of languages in Word 2003 when typing letter.
While typing a letter in Word 2003 it changed from English to what looked
like Arabic language. I have rebooted 3 times and started over and still
the same occurs. I even copied what I had in English to an email in Yahoo
and sent it to myself and rebooted. Came back to that same email and copied
it to a new email that I started to myself, and when I started typing it
would only type in what looked like Arabic language.
This happened to me once a couple of weeks ago, but never occurred again
What do I do?
In the Language dialog box, turn off the option to autom...Strange behaviour: show/hide formatting symbols reveals old change
In Word 2007, I'm getting some strange behaviour in a document that was
authored by someone else. Track Changes is switched off, all changes have
been accepted, and everything looks as it should in whichever view I happen
to choose (Print Layout, Draft, whatever). But when I click to show
formatting symbols (in whatever view) a whole lot of old changes - deletions
AND insertions, ostensibly all accepted, and from before the document got to
me - appear in the document, making it quite tricky to work with. These old
changes are impervious to anything I try to do with them
E...Need to show file properties dialog box
I need to show the shell's file properties dialog box. I tried
converting old vb6 code into vb.net but it gives me error. Here's my
Private Structure SHELLEXECUTEINFO
Dim cbSize As Long
Dim fMask As Long
Dim hwnd As Long
Dim lpVerb As String
Dim lpFile As String
Dim lpParameters As String
Dim lpDirectory As String
Dim nShow As Long
Dim hInstApp As Long
Dim lpIDList As Long
Dim lpClass As String
Dim hkeyClass As Long
Dim dwHotKey As Long
D...Color change in cell when > 49.99
I need a cell to change color if the value inside the cell reaches 50 or
higher.either text or cell shade. just so it catches the users attention.
im running excel 2000. and i have this currently in the cell that i want to
aplly this to:
have you tried conditional formating?
>I need a cell to change color if the value inside the
cell reaches 50 or
>higher.either text or cell shade. just so it catches the
>im running excel 2000. and i ...