linking pages in two different work books
trying to link two different pages in two seperate workbooks.
filling in statistical data in first workbook in
specific fields. then having to open the next work book and insertin
the same in formation again. don't wnat to be redundent and would lik
to populate worksheet in workbook 2 with the same input from workshee
in work book
Message posted from http://www.ExcelForum.com
I am also in need of this ability.
I have a list on one sheet and a chart with the names from the list o
another, same workbook. I have been linking each individual name fro
the list to their location on the ...Formatting tabs in a workbook
Is it possible to format a workbook so that a tab is set for each day of the
month? I do daily reports on excel and I would like the fromat to
goautomatically throughout the workbook.
If you mean automatically create new workbook and name worbook tabs with
numbers from 1 to number of days in month, this could be done with some
"Glen" <Glen@discussions.microsoft.com> a �crit dans le message de
> Is it possible to format a workbook so that a tab is set for each day of...have a class like CString but work with ASCII in Unicode mode?
I am finding a class work like CString class, but i only need that it work
well with ASCII in Unicode mode?
CString work with Unicode code in Unicode mode, so i dn't like use it.
Using char [MAX_PATH], it isn't good.
You could just use CStringA to force it to use ANSI (MBCS).
"Duy Trinh (Mr.)" <firstname.lastname@example.org> wrote in message
> Hi all,
> I am finding a class work like CString class, but i only need that it work
> well with ASCII in Unicode mode?
> CString work with Unicode cod...Send/Receive Commands stop working 02-13-10
Ofter, after opening Windows Mail and sending and receiving emails for a
period of time, the Send and Receive commands will stop working. The only
way I have found to solve this problem is to shut down Windows Mail and then
enter it again.
What could be going wrong here and how might I fix this annoyance?
What antivirus software do you use?
"Al_Colv" <Al_Colv@discussions.microsoft.com> wrote in message
> Ofter, after opening Windows Mail and sending and receiving emails for a
> period of tim...Conditional formating using named cell
In a pivottable in Excel 07 I have the monthly results for a
department. I use conditional formating to indicate if the spend value
for year to date exceeds the total-year-plan with more than a certain
This pct will change over the year, depending on the month shown.
Till now I have typed the value in the conditional formating:
[J is total-year-plan and G is the spend value for year to date.]
I would like to make the formula dynamic, and have it to refer to a
cell called ValueForRed.
I have tried to tye =3D($J9*ValueForRed)<$G9 but it does not work.
Any s...Money 2007
I have the following problem if someone can help me please:
I'm starting to setup the budget but there are no % numbers on each budget
group, just little square and illegible characters, is this a bug? or am I
doing something wrong?
thanks for any help
...Upgrade .pst file from 2002 to 2003 format
I want to take advantage of some of the new features of the Outlook 2003
..pst file format, namely the bigger capacity. After I upgraded OfficeXP to
Office 2003, the settings migration worked just fine. Now I want to upgrade
the .pst file format. Is that necessary and if it is, how do I do it?
Outlook 2003 will create a PST file in the new format by default. Just copy
the contents of your old PST file into a new one created by Outlook 2003. Be
sure you then set the new one to be your default.
"~~Alan~~" <alan.shepro_NOSPAM...Problem with termination of a console app within an MFC app while console is working
I have a mfc application. It executes a console application with
CreateProcess which is a lenghtly process. I will hide the console app
from the user.
My problem is this: I want to close MFC app AND console application
While hidden console app. is still active. How can I do this?
Code is below:
// TODO: Add your command handler code here
CString str ;
str = "cmd /c waitdlg.exe" ; //an app can work 15 minutes
ZeroMemory( &si, sizeof(si) );
si.cb = sizeof(si);
si.dwFlags = STARTF_USESHOWWI...Change default number format
Anyone have any idea how to do this?
You could create a template workbook (*.xlt) and format all the cells with the
numberformat you want.
Then use that whenever you want to use that special format.
If you want to use that number format for all new workbooks, name the template
workbook book.xlt and store it in your XLStart folder.
If you save another copy as sheet.xlt, then any new sheet added to an existing
workbook will inherit that number format.
> Anyone have any idea how to do this?
Right click the cell. > format cells
...Convert Word 2003 to Works
Hi, the new system that I purchased has OfficeWorks installed which I would
rather use that the (cumbersum) Office 2003 program and would like to know if
their is an easy way to covert the xxx.doc files to Works xxx.wps format?
Does "Works" open the doc files? If so, you don't need to convert.
> Hi, the new system that I purchased has OfficeWorks installed which I would
> rather use that the (cumbersum) Office 2003 program and would like to know if
> their is an easy way to covert the xxx.doc files to Works xxx.wps format?
&g...How to convert fraction format to text format ......
....... and still shows the fraction instead of decimals?
I have formatted a range of cells to fraction. Then I key in the =
9/16 etc. etc.
Then I format the cells to text and the fractions are converted to =
decimals. How can I have both text format and the fractions displayed =
as above without writing a formula?
I tried custom format, paste special>values etc. and had no luck.
I am also having trouble with a formula which works most of the time but =
not *all the time*.
e.g. A7 formatted to fraction>8/16 then I key in 11/16.=20
The form...Windows Media Player Format GUIDs
To display MP4 videos from our WPD device, we report to Windows Media Player
that the WPD_OBJECT_FORMAT of the object is WPD_OBJECT_FORMAT_MP4. Where will
I find the GUID for MOV videos that Windows Media Player now supports?
How do I change the date format to 10-Nov-2003 instead of
11/10/2003 in Outlook?
change the date format in windows control panel, regional settings.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, Visual Quick Start Guide - OneNote 2003
Outlook Tips: http://www.outlook-tips.net/
http://www.poremsky.com - http://www.cdolive.com
Expert Zone http://www.microsoft.com/windowsxp/expertzone
Search for answers: http://groups.google.com
Most recent posts to the Outlook newsgroups:
http://groups.google.com/groups?as_ugroup=microsoft.public.outlook.*&...Find & Replace formating
Any suggestions? Problem with Find & Replace and formating.
Sally tried to do a find and replace with the following: find "US",
replace with "United States." Instead of replacing it as she has
indicated, it replaced it with UNITED STATES. When she undid this and
tried to do it again, she looked at the more specific find/replace
options (where you can search for a certain format)--in that section,
all of the format boxes under "effects" were checked. (I'm not ever
sure how that is possible. Superscript AND subscript?) She unchecked
them, ran the find rep...How does XmlSchemaValidationFlags.ProcessSchemaLocation actually work?
Hello to all --
I am familiar with Xml in general and NET 1.1 Xml, but I am new to the
..NET 2.0 changes in System.Xml.
I am trying to validate an XML document that is based on a schema that
imports several other schemas.
I am using VS2005 and .NET 2.0 on Windows 2003 Server with SP1.
I am using the Validate method of the XmlDocument class. I am passing in
an instance of XmlReader.
My code is as follows (I'll explain the commented code in a second):
XmlDocument xd = new XmlDocument();
XmlReaderSettings readerSettings = new XmlReaderSettings();
//XmlSchemaSet sche...Excel drop down menus stopped working in IE
I have users running both Win2k and WinXP with Office XP, both fully patched
experiencing the following issue.
When users open an excel file in IE some of the drop down menu items
do not work. The File menu works but Edit, View, Insert, Format, Tools,
and Adobe PDF buttons do nothing. The Go to, Favorites and Help along with
the File menus function.
All the drop down menus were working fine up too a few weeks ago.
I can open the spreadsheet within Excel (not in a browser) and the buttons
Does anyone know why/how/when this feature stopped working? I get nothing
...unable to open Microsoft works files
I am unable to open Microsoft Works files with Word 2004, does
anyone know how to find the Works converter files?
On 9/29/04 1:50 AM, in article email@example.com,
> I am unable to open Microsoft Works files with Word 2004, does
> anyone know how to find the Works converter files?
There aren't any. You can use MacLinkPlus Deluxe to convert Works files,
Gene van Troyer
| Office 2004 | OSX.3.4 | PBG4 | iMac 20&...bring back ability to format subtotals in pivot tables
You used to be able to highlight all of the subtotals for a given field and
with one click and then either shade, change font, etc. and that seems to no
longer be possible. If someone knows how to do this, please let me konw!
If you enable selection in the pivot table, you'll be able to select parts of
the pivot table, and format them. To enable selection:
From the Pivot toolbar, choose PivotTable>Select
Click on Enable Selection
> You used to be able to highlight all of the subtotals for a given field and
> with one click and then eith...format cell with maximum value
I have a list of number, say 10rows by 10 columns. I want to specify a
conditional setting for each cell so that if the cell has the highest value
in its row, the cell will be coloured red. So I will get 10 cells that will
be coloured red. How do I do that?
Use conditional formatting. If your data starts in A7, then in A7, Format >
Conditional Formatting. Use the drop-downs and text box to create your
If cell value is equal to =MAX($A7:$J7), then set your format appropriately.
Copy the format through your entire table.
"Frank Drost" wrote:
> I have ...Formatting incomming mail
Is it possible to format incomming mail, so that lines
starting with "> " show up in a different colour. I want to
mimic what ximian does with incomming mail as it makes it
very easy to search for "inline" comments in emails.
No, if you have a message marked with > it means the message is in Plain
Text which doesn't support colors.
Roady [MVP] www.sparnaaij.net
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Setting Permissions on a Mailbox
-Create an Office ...OnInitDialog the event sink does'nt work!
Hi, I am developing an activex with eVC that fire events
more like a callback function. Probably is not the best
aproach but it seemed to work until I tried to fire events
on the activex control on the OnInitDialog event to
initialize the control with user data.
Seems that the event trapper starts after OnInitDialog!
Sure is by design, but how can I go around this?
What event fire after OnInitDialog where I can put extra
Working on callback functions for the activeX I tried
deriving an OCX class to override some method to make it
work more like a callback function but I d...Any way to round to denominations of 5000 using number format code
I'ld like to have numbers be shown as rounded to the nearest 5000.
Thus, if a cell has the value 92,345, I would like it to show 92,000. I
want to do this with the format codes...and NOT with a worksheet fxn if at
Also, is there any way to modify this so that it would always round up or
On Mon, 18 Oct 2004 13:09:04 -0700, "consumer"
>I'ld like to have numbers be shown as rounded to the nearest 5000.
>Thus, if a cell has the value 92,345, I would like it to show 92,000. I
>wa...Still not working
I used your method and I get the error- An internal error occurred on the
report server. See the error log for more details. (rsInternalError) Get
The source of the report definition has not been specified.
My .Net command-
Process.Start("http://localhost/ReportServer?/Pages/Report.aspx?ItemPath=%2fLegReviewRS%2fReviewDetail&rs%3aCommand=Render&RevID=" & CurrentRevID)
It is a hidden parameter.
This has always worked with the following parameterized command-
Process.Start("http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fLegReview...Advanced Search not working
I use Outlook 2007 and Windows XP PRo. I can see that advanced search
doesn't work for me anymore. When I search the inbox for messages
from smith, it returns no hits -- even though I can see emails from
Smith in the inbox. This is just one example. Sometimes it returns
some but not all of the messages that meet the criterion.
Are you using an Exchange server? If so, full text indexing may be turned on
for your mail store, and may account for the oddities you're seeing.
Indexing is usually set to run at some preset time, and until new messages
are indexe...Send To\Mail Recipient not working
I have WinXP w/Outlook 2003. When I right click a file and choose Send
To\Mail Recipient, the feature does not work. I have got it to work one time
by going to Control Panels\Add Remove Programs\Set Program Access and
Defaults. There I select Microsoft Windows, (instead of Custom), restart the
computer and I can then send to mail recipient, but only one time. After
that I get the Error message, Microsoft Office Outlook, The operation
failed. This feature works when I select Outlook Express as my default Email
client in Internet options. Please can someone help! Thanks in advance.