Need help to read Pie Chart Series Range
Excel 2003, I have an existing Pie Chart and want to extract the Ranges
My code below returns with a "Type mismatch" error.
Dim mySeries As Series
Set mySeries = ActiveChart.SeriesCollection(1)
Debug.Print mySeries.XValues (errors here)
...need Help for Migration Exchange 5.5
we`ve the following Configuration :
- Exchange 5.5 with SP4
- single Winwos 2000 DC
- configured both side ADC
a new Hardware should be used for an Exchange 2003 and second DC.
next steps i would do as following :
- Update ADC Version with Exchange 2003 ADC
- running Exchange 2003 forestprep, then domainprep, an after all
running setup to install Exchange 2003 in the same organization, site
- replicate system Folders and public Folders
- moving all Mailboxes to the Exchange 2003 Store
- configure the Exchange 2003 virtual SMTP Server to send outgoing
- reconfigure the F...Mail deleting from virtual inbox
When I open windows mail it automatically downloads and it deletes it from my virtual yahoo inbox, is there a way i can get it to stop deleting it or being able to place those messages back in my inbox to retrieve anywhere? also, it doesnt allow me to send messages so i cant foward them to myself!
Thanks, i appreciate ur help!
Erika Hey Erika.
I was having similar problem a while back. I remember in my webmail (optus)
there was an option at the bottom of the list of emails (delete after
download). I had to untick this box. You may have something similar, maybe in
tools?? Just be aw...Word Doc Macro help needed please!
I need to make a mocro that will work in a word doc. This macro would
start with  and count up one number each paragraph. For example
paragraph two would auto show  and so on. Any help would be
I have a word file which contains 100 pages. All the pages have name &
address of companies.(not in table) i have to transfer them to excel in
column format(for example first name, last name, address, phone etc)
can any one tell me code for this( i know how to open word & creat new
excel sheet) . I need code for how to reach to lines of word. r there
any thing like &quo...How big is the outgoing mail messages
Is there any way to see how big mail the user are sending or receiving.
And who's sending the mail.
I have exchange 5.5 and windows 2000
...Only printing header in Windows Live Mail
My canon printer has suddenly stopped printing the email content - only the
Printing in word, excel etc not affected. Using W7 (+ Firefox if that
Any suggestions please
Does you have the same problem if you try printing from IE? WLM depends
on IE for printing services.
Take a look at this:
Print and Print Preview May Display Only Text at Top of Page
It's a similar problem for a different version but the fix may apply.
Mike - http://TechHelp.Santovec.us
"Jem" <Jem@discussions.mic...Printing changes layout
I am printing a booklet on Pub 2002 - when I print one page, it prints a page
where everything has changed - resized, cut off the edges, etc. The worst
part - when done printing, it goes back to normal view and it actually
changes my layout to match what is printed - permanently.
Any ideas what is going on? I printed on both my Lexmark and HP printers,
does the same thing. I have Windows XP.
Look at your page layout, has it changed? I know this will happen to me
occasionally when I change printers. If I change back to the original printer
the publication will revert...Outlook pop up windows stops outgoing mail
In the last 3 weeks I continue to get a pop up window
titled "Enter Network Password". There is a key icon and
the request: "Please type your user name and password."
It then list my
Password: (entered with asterisk showing)
I continually enter my Outlook password with Bellsouth
and click the box "Save this password in your password
list" and click "OK".
Everything then works alright and then the window pops up
again in 5 minutes. It happens over and over again.
Anybody have any ideas on how to eliminate this? I use
XP Pr...open subfolders automatically on mail entry -- not happening.
Have a problem that happens in one Outlook 2002, but not another -- so I
know there's a likely setting someplace, but can't find it. I've even stumped
my company's IT people on this one:
I download mail through several rules (and accounts); and ship them to
various subfolders off of parent folders. What I desire is to have the email
automatically open the appropriate folder -- revealing the affected subfolder
-- when new mail comes into it. In one of my Outlooks (both 2002), this does
open automatically revealing the new highlighted message. But the other do...Do I need a licence to distribute MSFLXGRD.OCX?
I wish to use the MS FlexGrid control in my Access database.
Do I need a licence to distribute MSFLXGRD.OCX?
Paul H wrote:
> I wish to use the MS FlexGrid control in my Access database.
> Do I need a licence to distribute MSFLXGRD.OCX?
If you also use a VB application, the answer is no. But you will need to
build and deploy a VB application to distribute and register the OCX. You
cannot distribute it with an Office application alone.
Arvin Meyer, MCP, MVP
"Arvin Meyer [MVP]"...Sent Mail items not showing up
Using Outlook 2002 w/SP2 on WinXP Pro. Unable to view
items in Sent Item folder (Outlook shows normal blank
window with "there are no items to show in this view")
even though the Item count in the lower left shows over
2600 msgs in the Sent Items folder. It keeps increasing
as new msgs are sent. Using the standard view, all
standard columns, with NO Filter set.
Anybody seen this before? Any ideas?
...mail merge cannot continue
I have been using mail merge in Publisher 2000 on Windows
XP. But it suddenly started refusing to work, giving the
message "mail merge cannot continue". I have tried
reinstalling and uninstalling things I had done recently,
to no avail.
Did you have to relink to your database? If so, try changing your selection
in the checkbox for "First row of data contains column headers".
"Margaret" <firstname.lastname@example.org> wrote in message
> I have been using mail merge in Publisher 2000 on Windows
> XP. But it...Help With Sorting #3
Gudday to all XL gurus.
I need some help on using the SORT function.
I have a list of 100 competitors in a scoring spreadsheet that I hav
I was trying to sort by surname (a-z). The problem is that this list i
generated elsewhere and contains VLOOKUP functions. Obviously if i hav
less than 100 competitors I end up with some cells appear blank bu
contain VLOOKUP functions. XL sorts them first and I want them sorte
last after the surnames (a-z). I cant add a helper column as this lis
relates to over 48,000 forumulaes and functions that are already added
If I add a helper column I have...Need help converting Microsoft Outlook calendar to Entourage.... At wits' end here! Please advise...
I have a Mac at work which runs Microsoft Outlook 2001 client on an Exchange
server. I have a calendar on this machine (stored locally, not on the
server) which has a ton of reminders programmed into it - very useful! Now,
at home I got a new Mac laptop with Entourage X. Is there any way to move
all of the reminders (appointments) from my calendar on Outlook to my
Entourage calendar? I've tried two things:
1) I exported the calendar info as a CSV text file, and then tried importing
it in Entourage. The problem is that Entourage import function seems to
think it's importing an Address...Move / Migrate Mail
I currently have my Exchange server hosted off site.
I am looking to move this in house, of course I don't own the hardware the
server is currently on.
So I will be building a new server.
The current server (hosted) is in its own domain - I did not make this but I
have to support it-, I have duplicate accounts for email, plus some only
email accounts. I am looking for suggestions to accomplish this task.
My idea was to add all the user accounts that are currently 'email only' to
my domain so all my accounts match.... Make my Exchange server and
mailboxes. Then should I u...deleting mail on exit not working
hey guys im using outlook 2002 and I have selected empty deleted items
folder upon exiting which works until i restart my computer. I have to
slect this option everytime i restart my computer because the option
keeps unchecking itself. Any body knows how to fix this problem
thanks in advance
Am 6 Sep 2005 12:04:27 -0700 schrieb email@example.com:
> hey guys im using outlook 2002 and I have selected empty deleted items
> folder upon exiting which works until i restart my computer. I have to
> slect this option everytime i restart my computer because the option
> keeps uncheck...I need a list of command line switches for Microsoft WORD.
I am using a Shell command to execute Microsoft WORD 2003. I need to halt
execution of VBA code until WORD finishes it's task. Is there a command line
switch for WORD to cause it to pause the VBA function until it is finished?
Is there a VBA command to pause execution of code until WORD finishes? Thanks.
I am pretty sure the answer to your specific question is "No". If you tell
us exactly what you are doing, including from where the Shell command is
being executed, maybe we can suggest another way that will overcome the
Hope this helps.
Please r...help with lookup formula (sheet 2, not a double post)
I need to make a formula using a lookup. The first spreadsheet is a
inventory (ALO INVENTORY JP). The second (P&G 103) is a chart tha
tells number of gallons of alcohol per foot/inch/fraction.
On ALO INVENTORY JP I insert the # of feet, inches, and the fraction i
cells R5 and T5. I want these numbers to lookup the number of gallon
off of the P&G 103 worksheet.
For example: P&G 103 (on inventory sheet) is 26ft 4 1/2 inches, i
should look-up to be 34572 gal. for the 26'4" and 55 gal. for the 1/2"
These two numbers should be added together and multiplied by the numbe
...Help!! Way to find users sending email to large amount of receipients.
Could some one tell me if there is a way in Exchange 2003
to find out what users are sending email to a large
amount of recipients?
I'm having some serious performance issues and I'm sure
it's some one sending email to a large amount of
I have a problem. I have a list of numbers that are in one column.
Alot of numbers 8000 or so, and I need to find if there are an
duplicates. I sort them so that they are in order, but having t
scroll through the whole list takes alot of time and hurts my eyes!!
I tried advanced filter but I can only find how to find duplicates in
Someone help me please!
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step...Help with displaying the contents of the last populate cell.
I have numerous sheets within a book where all cells in column C in all
sheets have the following formula “=IF(ISBLANK(P4),"",(R3-P4))”. For you
reference both columns P and R hold a monetary value and are formatted as
Is there a way that cell D1 can automatically be populated with the contents
of the last cell in column C that has a value in it.
Sheet 1, cell C19 has a value of 200, therefore cell D1 should be 200.
Sheet 2, cell C25 has a value of 250, therefore cell D1 should be 250.
Sheet 3, cell C99 has a value of 900, therefore cell D1 should be 900.
Any h...sp_columns does not return NVARCHAR data type columns
our SQL Server Version is 2000 SP4.
For several days the SP "sp_columns" does not return NVARCHAR data type
columns any more.
I reviewd the SP "sp_columns" and it seems, that the used SP
"spt_datatype_info" does not return that type any more. A second production
server returns that column type.
The SP "sp_columns" is used by the ODBC-Driver to determine the table columns.
Thanks a lot,
Ok, my fault,
it seems that "spt_datatype_info" is a table and there is no NVARCHAR row.
After insert...Help on filter
I have a list to filter. I have to keep only integers.
I tried everything in advanced filters... does not work.
Can you help me please?
Message posted from http://www.ExcelForum.com
one way: use a helper column. Lets say your numbers are in column A
then enter the following formula in an adjacent cell for row 2
copy this down for all rows. After this filter with this helper column
> I have a list to filter. I have to keep only integers.
> I tried everything in ...help!
I have been given a dataset with data,but the problem is now i need to
create membership cards,which i plan to use the label wizard in reports,but i
also have to display the intials of the customer but i have not been given
the fields for intials just forename and last name.Is there maybe a way of
running a query to search for some of the forename field to use as my
I thought I had seen this post a day or two ago and it was answered.
If you want Initial and Last name
Left(FirstName,1) & " " & LastName
Dave Hargis, Microsoft Access MVP
&qu...Pointing to correct macro path using excel custom toolbar
I have created an excel 2000 template (.xlt) containing a number o
macros. When I open copies of this template on various pcs, the macro
function correctly, except I cannot successfully run the macros usin
the custom toolbar I created, because (I think) within the toolbar th
paths to the macros are pointed to the original location on my pc. An
advice on how I can resolve this would be gratefully received
Message posted from http://www.ExcelForum.com
Have you thought about building the toolbar when the file opens?
Or maybe separating the worksheet portion of the template from the code pa...