2003 and 2007
Are the formats of the two pst files the same?
If unicode, yes.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, The Old Bloke asked:
| Are the formats of the two pst files the same?
"Milly Staples [MVP - Outlook]"
<MillyS@donteventhinkaboutmailingmeatmvps.org> wrote in message
If unicode, yes.
Milly Staples [MVP - Outlook]
Post all replies to t...Numbering in Word 2007
I have a large (over 150 page) document that has paragraphs followed by
numbered lists. I'm using one of the canned 2007 Styles for the documents
I went into the Numbering Library and modified the Numbering format so that
each level of the multilevel list stepped in appropriately - 2 is flush left,
2.1 starts under the starting text of 2, 2.1.1 starts under the starting text
of 2.1 etc. This does make the latter numbers have small text areas, but it
gives the look I want.
Now, I have a problem. The document is not using the numbered list style I
se...Opening excel file in new window
When an excel is already open in a window and I open a new excel file it
opens in the same window. How do I make it open in a new window?
You can't. Excel has two windows only; Excel and the VB editor.
You may be able to open another instance of Excel though, with some Windows
trick or by code. But that is spending a lot of power just for an extra
HTH. best wishes Harald
"Ravi" <Ravi@discussions.microsoft.com> skrev i melding
> When an excel is already open in a window and I open a new excel file it
...Excel password not working
A co-worker sent me an excel spreadsheet that's password
protected. When I try to open it, it says my password is
incorrect. When she opens the same file, the password
works for her. We're both stumped. The only differnce is
how we're logged into our PCs, and our Outlook/Exchange
accounts. Where would we found the settings to change so
that I have permission for the password to work?
Ask her to unprotect it and resend it!
"gregf" <email@example.com> wrote in message
>A co-worker...why can I not format a secondary axis in excel x?
Despite being able to graph data on a secondary axis in Microsoft Excel X, I
have been unable to format said axis (ie make it start from a value other
than zero). No amount of trying to click on and select the axis or the
values has helped.
Are you saying that double clicking does not bring up the Format dialog box
for the axis?
Try tapping the 'navigation (arrow) keys while watching the Name box. When
it reads Secondary Value.... use the Format menu item to open the dialog box
and then open the Scale tab to set the Min and Max values
"mackie99" <...What happens here man?-I am using vs.net 2003
this function is in a regular .dll statically linked to mfc.
//have m_pMainWnd to be not null else the thread is going to die any how
//processID=::GetProcessId(pphandle);//process id is corrent
when run to test it.
The Procedure entry GThreadId could not be located in dynamic library
>The Procedure entry GThreadId could not be loca...Merging Excel Sheet with Excel Sheet (Just like in MS Word!)
Purpose: create classroom roster between one Excel spreadsheet as data
source and another excel sheet.
I know how to use one excel spreadsheet as a data source to merge with
another word document; however, by using this method, I found that the link
between the files keep dropping from time to time, especially when the folder
has been moved around.
I'm thinking of creating the same layout of the Word document in another
Excel spreadsheet and somehow "LINK" the data source and the other
spreadsheet together, but I'm not sure how, or whether thi...Excel 2003 Viewer: No more "Browse in same window" IE functionality?
With Excel viewer '97, by going into the file associations in explorer,
you could modify the '.xls' entry and choose 'browse in same window'.
In IE, this would then launch the excel attachment in the same window.
After installing the recently released Excel Viewer 2003, the 'browse
in same window' checkbox is greyed out. Is this a feature that was
dropped in the new release? If so, is there any registry hack I can
use to re-enable it? I'd really like to have the old functionality in
the new version...without it, I can't push out the new version. Any
hel...Excel 2007 Ribbon Limitations
I have to admit when I first started using the ribbon I struggles with
it, but recognised it "should" make my life easier as it does put the
most frequent features first.
The problem is, Microsoft have removed half the functionality and made
just a pain in the butt
Simple things like removing a border format is now no longer a single
Even adding a left border is now two clicks, one to get a list of
border options from the Home-borders icon, the second to pick the left
border. So I added the left, right, top and bottom border command to
the Quick access toolbar so now at lea...Excel 2003 slow after Print Preview
I'm finding Excel 2003 is slow after using Print Preview. Searches of the
web and newsgroups reveal that a few people have experienced this over the
years but I haven't seen any responses that give a solution to the problem.
Does anyone know what would cause this and how to fix it. I've tried
selecting different printers but it had no effect.
I've discovered something further relating to this problem. The slow
manipulation only occurs if the printer being used is one that is shared by
the SBS server. If I use a printer that is connected to the network a...excel invalid page fault in Excel.exe
I get an invalid page fault when I try to open Excel from programs. I
can open it from the start, run menu in safe mode. Any help? Thanks,
~~ 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 by step guide to creating financial statements
Try the suggestions at www.cpearson.com/excel/startuperrors.htm ,
especially the section regarding customized toolbar files (xlb
Microsoft MVP -...Excel formula #2
tried to use a formula created for me by "Random" and the
following appears in the cell #NAME? What does it mean and
why does it appear?
Looks like Random had a type and omitted a ! in one of the sheetname
This should work.
"George A.Yorks" <firstname.lastname@example.org> wrote in message
> tried to use a formula created for me by "Random" and the
> following appears in the cell #NAME? What does it mean and
>...How do i export excel data to outlook contacts
have no ideai how to do this ..need step by step. I have a list of names with
phone numbers and emails and would like to export them to outlook contacts
You don't export from Excel, you import from Outlook. Just open Outlook, and
try File--Import... and take the steps from there.
"Joshna" <Joshna@discussions.microsoft.com> wrote in message
> have no ideai how to do this ..need step by step. I have a list of names
> phone numbers and emails and wou...CSV file Imported to Excel
I rec'd a CSV file today @ work. From Excel I did a File, Open and it opened
immediately (without the File Open Wizard which I was hoping for). Anyway,
everything LOOKED fine in the Range of numbers between B2 and K30 - with 20 or
30 blank cell among the numbers; I later
found out the blank cells WERE NOT Blank, but rather had 13 hard-coded space
characters in them.
I later opend the file in Word Pad and saw how that it appeared something like
4344.56, 3232.56, , 555.55,
Where in excel it was:
B C D...Running an Excel Macro from VC++
I use Excel Automation from VC++. I would like to run a
macro already stored in Excel on the workbook that I just
created. I was thinking that _Application::Run() would
do it but it doesnt' seem to find my macro.
The macro is stored under the name PERSO.XLS!Macro1. Run
doesn't seem to find it. Even if I user Macro1 as an
argument, I still can't run this macro.
Any ideas why ?
...Outlook 2007 and lLain Text
Since Outlook 2007 contains its own mini-Word for mail composition, will I
be able send true Plain Text messages without Word adding all its cruft?
Plain text is plain text, no matter what email program you send it with. =
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"Brian Tillman" <email@example.com> wrote in m...ExCel programming
I am working on a spreadsheet for work where it will calculate commissions to
be earned based on my sales. There is a table that I have to use to determine
what the percentage would be, how would I write an equation for that. For
example, the equation would have to say: if say D3 was = or < than %, use
cell# whatever and then have a sum in there. The table is on another sheet in
the document so that would have to be there too.
Basically, the way that my commissions are calculated is that we have to
take what I sold in any given month and find out what percentage of my yearly
plan i...Pivot Table in Excel 2007
I have a column that has been formatted as an integer, no decimal. When I
create a pivot table this column shows up as currency format. Is there
something I should do BEFORE starting to create a pivot table??
Just format the Pivot Table.
Put your cursor in the pivot table field and click the Field Settings button
on the toolbar. Click the Format button...
> I have a column that has been formatted as an integer, no decimal. When I
> create a pivot table this column shows up as currency format. Is there
> somethi...excel toolbars
when I open a spreadsheet (or for that matter a word file)
from an email, the "reviewing" toolbar opens
automatically, and similarly, opening a spreadsheet from
any hyperlink opens the "web" toolbar automatically. Is
there a way to prevent these toolbars from automatically
Jim Rech posted this today:
The Reviewing toolbar in Excel pops up whenever you open a workbook that has
been emailed from within Excel "for review". There may be other ways to
make this happen too. If you do a File, Properties you'll see the custom
file properties that hav...Use ActiveX controls or the controls in VC
I am designing a GUI dialog with MFC in VC6.0. I found that many controls in
VC6 can be replaced with ActiveX controls. So one question: which one should
we prefer to use? Do ActiveX controls have more advanced features allowing
Usually activex control brings extra file dependency to your executable, and
sometimes they are licensed. So I would use windows standardard control if
there is no special need for activex control.
"Yuchun Xu" <firstname.lastname@example.org> wrote in message
>...why 2003 excell does not accept dot as decimal points
In 2000 ms excell, if i type 200 and dot (.) it becomes 200.00
In 2003 ms excell, if i type 200. it becomes 2 even I fixed decimal places
I want to get 200.00 by typing 200 and dot. In 2003 ms excell, I have to
type 20000 and it become 200 without decimal points so I have to increase
decimal points by clicking increase decimal on the memu to get 200.00
Please reply me as soon as possible.
"miki" <email@example.com> wrote in message
> In 2000 ms excell, if i type 200 and dot (...Using Hyperlinks within Userforms
I have a Userform with various command buttons in place. What I'm
trying to do is allow users to be able to open various Word documents
when they click on these command buttons via the use of hyperlinks
embedded within the click event of each command button.
So if they click on one of the command buttons it opens one Word
document, and if they click another, it opens the second Word document
It would be ideal to have the Userform to always remain displayed, so
the documents open in the background, and the Userform always has the
focus... then once the desired documents...Custom Ribbon and Reports
I'm very new to Access 2007, and I'm trying to create a custom Ribbon.
Currently, I basically have the code for the sample in the USysRibbons table
<tab id="dbCustomTab" label="A Custom Tab" visible="true">
<group id="dbCustomGroup" label="Reports">
</c...Referencing a Sheet and Cell Location in Change Event of Combo Box
I have a combo box in Sheet1 of my workbook I would like after any ite
is changed in it to go to Cell A4 of my Rates Worksheet in the sam
workbook. Here is the code
Private Sub ComboBox1_Change()
It is breaking on this line here Range("A4").Select
What do I need to change so that it can go to A4 of my Rates worksheet
Message posted from http://www.ExcelForum.com
Application.Goto Reference:=Worksheets...Merge Excel Docs
I need to merge two excel docs. Both have the exact same colomns of
data. But I updated some of the cells in the new document. I need to
merge those new cells into the apropriate rows and leave all other data
unchanged in the old document.
Unfortunatly, there really is no reference in the old or new document
that points to the specific row with the cells that needs to be
I could specify the rows by number in each doc if need be.
Not same number of rows/columns. Not limited to rows or columns -
Volume is small, rows x columns is 761x9 in the old doc. 37x9 in the