How do I create a combination chart and table with different data.
I am using Windows XP, and Microsoft Excel 2003. I have been asked to create
scorecards with charts displaying rates graphically, and an attached table
underneath with numerator and denominator data. The combination graphs in
the custom charts try to graph and display all the data. Can I create a
combination chart with the rates graphically displayed and the underlying
numerator/denominator data presented in a linked table underneath the chart?
Or do I need to create the graph and table separately?
You would do better to make a separate chart and table, because chart data
tables ...How do you create an "html" file? #2
How do you create an "html" file?
We need this file to display messages & promotions on the costumer display
...InfoPath and XSL
How do I attach a XSL to my InfoPath produced XML file?
...I can't open Office Data File from CDs #2
Dear technical experts,
I have been facing a security problem with Microsoft
Outlook files. I exported Outlook items into Office
outlook files (with the extension is .pst). The exported
files were firstly saved on my computer (different path
and location in comparison with default path of Office
Outlook files in Documents and Settings). I can open my
exported files easily.
Because the size of outlook items is very large, I would
like to save Office outlook files on another storage
device in stead of using hard drives of my computer. I
made copy these files to a flash drive (USB dri...Howto create a new resource type
Does anyone know how to create a new resource type?
What I am trying to do is add an rtf file to my resources file. At the
moment, I have added it as resource type RT_RCDATA. This works and I load it
using FindResource, LoadResource etc.
However, since it is possible to add a custom resource type from the
resource editor, it would be nice to be able to add a resource type RTF and
being able to see the resource in the resource editor. It would be nice to
be able to create a resource called RT_RTF which can later be used by
Note: Spam-resistant e-mail ...Index
I created a primary key when I created my table. I now want to create an
index on multiple fields. How do I do that and how do I use this new index
in a quary
Assuming Access 2003 or earlier, to create a multi-field index, either click
on the Index icon on the button bar (it's a bunch of horizontal lines with a
lightening bolt to the right), or select Indexes from the View menu. Pick a
name for the index (it doesn't matter what you call it) and put that in the
first column of the first empty row. In the next column, put the name of the
first field you...Creating folder structure to be the same a nother PST.
Is there an easy way to create the same folder structure between a new PST
and an exsisting one?
I am creating a new PST file (several reasons) and want to keep all of my
rules the same.
Even if it take VBA to do it, that is fine.
"Phillips" <Phillips*NOSPAM*@RecycledReefs.com> wrote in message
> Is there an easy way to create the same folder structure between a new PST
> and an exsisting one?
> I am creating a new PST file (several reasons) and want to keep all of my
> rules the same.
> ...created a rule in OE to cope with Spam
I copied and pasted, either text or words, in an email address from a spam
email and now when I write a new email and try to enter my email address in
the from window those words I copied and pasted some hours ago appears there.
I have copied and pasted other items since then so am wondering why is this
email address in text form from the spammers email is appearing.
Coincidentally the spammers email address begins with the same letter as my
email address begins with,"c". The email address is a popular ISP here in New
....scribble scribble...Inserting PDFs into Publisher File
I can't insert PDF's into my publisher newsletter by
trying the insert command. I have to copy it and then
past and it loses some quality.
Anyone know how to get around this insertion problem?
Save the .pdf as another format and then insert it.
MVP Microsoft [Publisher]
"firstname.lastname@example.org" <email@example.com> wrote
in message news:firstname.lastname@example.org...
>I can't insert PDF's into my publisher newsletter by
> trying the insert command. I have to copy it and then
> pas...Can i create my own fomrula made up from several excel ones?
I am using the nested functions below
"=if(vlookup(1, GRID, 3,false) = 0, (1, GRID, 4, false), (1, GRID, 3,
i.e for the row with the digit one in its first column return the value in
the third column else if empty return the value in the fourth column.
my problem is i am repeatedly using the line above exactly only changing the
value i am searching for (1 in this case ))
so ideally i'd like to do something like
define myformula(X) = if(vlookup(X, GRID, 3,false) = 0, (X, GRID, 4, false),
(X, GRID, 3, false))
is this possible?????????
I don't know if thi...Publisher 2003- message
I have used Publisher for a 120+ page "news letter" for the past 5 years.
Upgraded to 2003 early last year. Have had a problem with fonts changing
indescriminately (no sollution as yet). Latest problem - having spent many
hours on a new document which includes grafics and text - I received the
message - Publisher cannot open the file.
Surely after 5 years you have a backup or two.
It is never a good idea to use the same document over and over without re-saving
it with a new name.
Maybe you have a copy in a temporary folder
Type %temp% in the address bar of Wind...save array to file, read it back in
I just have an RGB volume buffer allocated like:
unsigned char pBuffer = new unsigned char[256 * 256 * 50 * 3];
and I'd like to dump it straight to a file so I can read it back in
exactly as above. Can I do something like this:
o << pBuffer;
// Later on read it back in...
unsigned char *pLater = new unsigned char[256 * 256 * 50 * 3];
I would write it out in ASCI and then convert when reading back. Since you
are using MFC...Converting mysql query result to xml
Hi all, I'm a newbie in .net xml programming, so please be patient. And
sorry for my uncorrect english, too.
I'm going to explain my problem:
I've built a web service which responds to ferries timetable requests.
It receives an xml document with this format:
...Is there any way to Create a self-extracted file programmatically ?
Hi,guys!I need to create a self-extracted cabinet file with my app,but i
don't know how to achieve this.I found ms cabinet sdk,but it dosen't mention
the self-extracted cabinet.And i know IEpress can create a self-extracted
cabinet file,but i want to write my app as IExpress.
Is there any way i can achieve this ? Thank you advance!
There is a cabarc.exe for creating cabinet file along with platform sdk.
There is also a cabinet sdk available here:-
"how...Excel crashes with linked files
I was recently issued a new laptop and now Excel crashes
frequently, sometimes upon opening a file, sometimes upon
closing a file, and most recently upon changing the font.
The most obvious thing that all the files have in common
is that they contain links to other worksheets. Does
anyone have any idea what may be causing this and/or how
to fix it? I'd appreciate any suggestions.
Erin, have you tried un-installing Excel/Office and re-installing? It sounds
like something is wrong with Excel.
Productivity add-ins an...Excluding full path to linked file on a networked drive
I have two excel files -- A and B. Both files are saved on a network
drive in the same directory. In file A, I have links to cells in file
Because the files are in the same directory, is it possible to not
have Excel show the entire path to file B in the formulas in file A
that link to file B? The network path is quite long and it makes it
difficult to read the formulas?
If file B is open, the formulas just show the name of the file,i.e.
[B]. Is it possible to always have this shown?
How about using a cell reference that contains the file path?
Portlan...Cannot create Investments to Watch
I accidently deleted my Investments to Watch and cannot
find the way to re create it. Can anyone tell me how
create this type of investment. I tried my Money help but
it does not work.
In microsoft.public.money, <email@example.com>
>I accidently deleted my Investments to Watch and cannot
>find the way to re create it. Can anyone tell me how
>create this type of investment. I tried my Money help but
>it does not work.
Create an investment account with whatever name you like. Then in
the account details, make that account a Watch Account.
Tha...How to create a save-as dialog box as in Words?
When you save a file in Words, you will see a dialog box that is
different from CFileDialog. My question is how to create it? Please
LPCTSTR lpszDefExt = NULL,
LPCTSTR lpszFileName = NULL,
DWORD dwFlags = OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT,
LPCTSTR lpszFilter = NULL,
CWnd* pParentWnd = NULL,
DWORD dwSize = 0
Set to TRUE to construct a File Open dialog box or FALSE to construct a
File Save As dialog box.
The default filename extension. If the user does not i...Create view using data autofilter
I use Excel quite a lot, and would like to expand my ability. I use the
AutoFilter feature to look at particular data. Usually it involves filtering
a few different columns. I would like to set-up some "Views" that define the
conditions and values for several columns. I could then click on one thing
and get the pre-defined sets of data.
The simplest way I think is to record a macro that creates the view you
"Arleigh Birchler" <ArleighBirchler@discussions.microsoft.com> schreef in
bericht news:48B6926E-8BF3-471B-A9E7-9D...Merging Two Files
Hi, I am getting ready to marry up two schedules (around 6000 task lines) and
am trying to find a potentially quicker solution than what I have planned
(just in case plan A doesn't go so well for me).
Two months ago I took a copy of my master file and began to add much needed
work into it, however it was not yet authorized work, so I had to continue
providing status into the main master file up to this point in time.
Now that the work will be authorized in May, I need to take the current
master file, and make sure all of the "what-if" modifications from the
se...Creating a drop down list
i want to create a column (A1) where i can choose from a list of clients
How do I create this list and keep it hidden?
Add you list on a hidden worksheet
And use this to create the dropdown
Regards Ron de Bruin
"Ed" <Ed@discussions.microsoft.com> wrote in message news:956A62C8-C64B-4C8B-BC4F-05073764171E@microsoft.com...
>i want to create a column (A1) where i can choose from a list of clients
> How do I create this list and keep it hidden?
...Shared File & Freeze panes issue
We are using a Shared file, but the Freeze panes at
times "resets" so that it appears the screen is frozed
unitl you reset freeze panes.
This is not due to user changesm but occurs in the
original file that was emailed.
Is ther any way to prevent this?
There's a guy at work who sometimes applies Window|Freeze panes to a filtered
While the list is filtered the way he has it, you can see the titles and the
But when you do Data|filter|show all (or reset the filter), the cell used to set
the freeze panes is now off the viewable screen and it looks like t...Create fiscal Year calendar list weeks by #1-52
I am trying to create a fiscal calendar that runs from The first full
week of febuary (Sunday to Saturday) through the last full week of
January (Sat-Sun) It is OK and preferred to have full weeks, so for
example, the first Full week of 2005 would be Jan 30-Feb 5. I would
like to create a drop down list to select each week # to enter dates
automatically in another worksheet, not sure where to start and no very
My laptop computer recently had a mother board that fried and had to get a
new one. Before taking the computer in for repair, I had all of my documents
backed up on DVDs. When I reinstalled Office 2007, I receive error messages
on some documents saying that the file is corrupted. Is there any way to
recover the data on this corrupted file? I have tried to open the files by
using plain text but all I get is scrambled letters and numbers and signs.
Try opening them with WordPad or Open Office. But to see how badly corrupt
they are (presuming they are docx format), rename them with...Unable to read File #4
I have one particular file in Excel 97 which I open and update daily
(stock market stuff) and each day I copy the days entries and paste it
below for the next day. Been doing this for years with no hitch until a
couple of months ago then one day I tried to open the file and got a
notice "Unable to Read File". Tried everything I knew (which is not
much) with no luck. Fortunately I had the file saved to a flash drive
and was able to open it there and "Save As" back to by hard drive. It
worked fine for a while, then last week it happened again, but I didn't
bother to ret...