making a document print in black & white
Operating System: Mac OS X 10.5 (Leopard)
I am printing to a Canon MP190 printer which has the capability of printing in colour and black and white, but sometimes I only want it to print documents in black and white (even if they contain colour). How can I force it to print documents in black & white? Is the solution similar for other Office for Mac products, such as Powerpoint or Excel for example? <br><br>Many thanks for your assistance <br>
...Search a string in all worksheets ?
I am searching for a string say ABC in all worksheets in
Excel 97. However, it seems that it only allows me to
search it in the current worksheet.
Is there any suggestion ?
In XL2k, I just highlighted all three sheets using Right-click on one tab
and choosing Select all sheets..........then did Edit > Find > and typed my
search string in the window and hit "Find next" repeatedly and it cycled
through all three sheets finding the string...........is that what you're
wanting to do?
Vaya con Dios,
"Peter" <anonymous@di...XmlTextReader to a xml string
I want to use FOR XML in my query so I'm going to use the ExecuteXmlReader
method? The trouble I'm having now is streaming the results to a string for
output as an XML document. Also, since the XML that comes from teh query is
not a complete document it's a fragment without a root element. So, any
ideas about how to get his into a string?
Buddy Ackerman wrote:
> I want to use FOR XML in my query so I'm going to use the ExecuteXmlReader
> method? The trouble I'm having now is streaming the results to a string for
> output as an XML document. Also, ...XML receipt cache force reload?
I am pulling my hair out over here. I hand editted the XML to place the
SubDescription1 instead of ItemLookupCode. I also said for the POS
station to prompt for receipts.
Even after specifying a new receipt XML file and trying to reload the
updated version, it's having difficulty getting used to the new format.
It still recalls the old.
Can someone advise me as to a surefire way to clear out a cache of
> Even after specifying a new receipt XML file and trying to reload the
> updated version, it's having difficulty getting used...Powerpoint opens all word documents
Why when I save my word documents in 2007 format does powerpoint open it back
up. I have to manually choose Open with Microsoft Office Word so I can see my
documents. It opens all documents from internet same way
You might try Office Diagnostics, if that fails to rectify, then modify your
"abarone1967" <firstname.lastname@example.org> wrote in message
> Why when I save my word documents in 2007 format does powerpoint open it
> up. I have to manually choose Open ...Save Application State to XML: How to have each module create a "Node"?
I have an application which is built from many modules. I re-use the
modules in different applications.
I'd like to have each of my modules implement a "SaveState()" method.
The method should return the state of the module (and any modules it
contains) in some nice, easily parsable and savable format. I think
this format should be XML.
So should each module return an XmlElement, an XmlDocument, or an
XmlDocumentFragment. I've been experimenting and I can't figure out
the best way to do this. I'd like to do it "right" because I'll be
doing this a l...Excel 2003 document post to web is appending
I am using VBA code in a 2003 Excel spreadsheet. I just upgraded the
computer to Office 2003 (not 97). Now when I post with HTMLConvert, it
appends instead of replacing the contents of the page. I deleted the object
and then posted and of course it’s OK – the next day when I run the daily
update, it appends. How can I make this code just replace the current data???
Here is my code:
'save Daily Safety Stats as html format on Safety Web Page
Set rngRangeToHTML = Worksheets(strMonth).Range(strRange)
iResult = htmlconvert(rangeandcharttoconvert:=rngRangeToHTML, _
...How can you copy selected cells when one cell contains a specified string?
I need to paste selected cells into different worksheets.
The cells contain information like:
date, amount, category eg:
24/08/04, 590, eggs
25/08/04, 430, cheese
what I wanna do is copy date and amounts to eggs worksheet or cheese
worksheet, depending on whether category is eggs or cheese.
Is there a way to combine the IF function with a paste link, or something
Thanks a bundle in advance!
Formulas return a value to the cells in which they reside.
They cannot perform actions, such as copy,paste ect.
what you want is possible but you didn't not provide
enou...C: Drive documents and setting expansion
Whenever I, Right Click Start then click "Explore", I get an expansion of
the my user ID folders. Now, I rarely us "Documents and Settings" and would
like to have it expand differently.
What do I need to change so that can happen??
Bruce A. Julseth wrote:
> Whenever I, Right Click Start then click "Explore", I get an
> expansion of the my user ID folders. Now, I rarely us "Documents and
> Settings" and would like to have it expand differently.
> What do I need to change so that can happen??
1. You could ...Je vous conseille de lire ce document
Je vous conseille de lire ce document en version imprimable si vous utilisez
un webmail, merci
JE NE VENDS RIEN JE DONNE JUSTE UN TUYAU SUPER A
TITRE GRATUIT.....ESSAYEZ C�EST TERRIBLE
***Si vous d�sirez faire autour de 5000? en � peu pr�s 30 jours, je vous
demande de lire l'information suivante soigneusement***
Prenez 5 minutes pour lire attentivement cette information.
Ce sera la meilleure d�cision que vous n'aurez jamais prise.
Ce concept a aid� beaucoup de personnes � gagner 5000? en 30 jours, rien
qu'en faisant fonctionner cette ...xml to excel #2
can anybody tell me how to transfer xml data to an excel template (worksheet)
using asp.net ?
Regarding this issue of transferring the XML datato an excel template, I
would request you to please go through teh following article to transfer the
data from an access database to Microsoft Office Excel 2003. These include
using the user-Interface, programmatically creating an XML file,
transforming the data and reading it into Excel, and automating Excel and
programmatically reading the data file :
[Transfer XML Data to Microsoft Office Excel 2003 with Microsoft Visual
ht...How do I insert a letter into an existing word document?
I am working on a large document that I need to add several letters that are
on our letterhead. If I cut and paste the letter, the letterhead header
becomes skewed. This is just one issue I'm having with the document! Also
need to know how to merge 3 separate documents together once I insert the
letters that I need! Help!
What do you mean by "skewed"?
To preserve the data from the header of the document, you will need to
insert it into a Section of its own separated from the rest of the document
by Next page Section breaks before and after it with the headers...How do I write a string in the destination element depending on what the string is in the source, using XSLT/XPath? (Like a switch statement.)
Is there something like a switch statement in XPath? What I want to do is
In the source there is an element called "member" with either the value "0"
or "1". In the destination element (also called "member") the value should
be "No" or "Yes" (Where "0" corresponds to "No" and "1" to "Yes"). How do I
Joakim Olesen wrote:
> Is there something like a switch statement in XPath? What I want to do is
> In the source there is an element called "member&quo...exporting to XML
I noticed that you can export an Access database to XML, but is there anyway
you can run it from a macro or a script. I want to automate the process on
a nightly basis.
I assume access 2003?
Check out the
While in the code editor, go help...and type in
You will find information on the ExprotXML feature....
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
But keep in mind that exportXML will only export one table from the
database. You will ha...Adding USer Defined Comment data to Customer Documents List
I am using Great Plains 7.5 with Business Portal 2.0 and when I try to add
the Comment Text field to the Customer Documents List web object, the query
gives me an error message as follows:
Invalid column name 'CMMTTEXT'.
I've contacted tech support and I have yet to received a resolution. Does
anyone have any ideas how I can get past the error message and retrieve this
Never mind ... we were using a replicated database and that field was not
"Brooks Seifried" wr...How to find a text in a string without giving the position of the
My requirement are
I want to find a particular text in a string with out giving the position of
the text . I believe that if we use find and search we have to give the text
position for the particular text. Can anyone guide me what should be the
function used for getting this.
Microsoft MVP Excel
"Sreekanth" <Sreekanth@discussions.microsoft.com> wrote in message
> My requirement are
> I want to find a particular text in...Stringing formulas again
Hey there Roger, once again this formula thing is driving me crazy...I can
visualize what I want to do but can't work out the formula...This is how I
see it in my mind
What do you think?
Perhaps this will help...........
=IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),""...Read from XML into Datagrid with dropdownlist
I'm reading xml data into a dataset, but I'm struggling to display the
data in the way that I'd like to. I would like to generate a datagrid
or datalist with two columns. One contains US states, and the other
contains dropdownlists or comboboxes, which hold all the counties
within its associated state. I appreciate all help that is offered.
My xml file looks something like this:
<county>Polk<...String of strings
Is there a standard way of handling a double null terminated string with
embedded null terminated strings. I've looked but can't find any examples.
You have to manully put them in string, I believe you are looking for
MutliSz reg string or string for shFileOperation if i am not wrong.
Visit me at http://alok.bizhat.com
"I Believe this will Help"
"Gerry Murphy" <email@example.com> wrote in message
> Is there a standard way of handling a...Count occurance of a string across numerous worksheets
Have a "Control Page" and numerous other sheets.
I've now listed all workseets on the "Control Page" eg:
Im trying to count the number of times a specific string "Internet Usage -
Prepaid IP Hours &q...Searching for Substrings Within Strings
I would like to be able to search and flag a list of
string data based on another list of substring data.
If I have a list of strings in Column A and input the
list of substrings in Column C, I would like an "X"
to appear in Column B every time that a substring
mentioned in Column C is included in any of the
strings indicated in Column A. (There cannot be
multiple instances of the same substring, or a
combination of different substrings, in each string
of data in Column A.)
For instance, given the following information
indicated in Columns A and C, the "X" should appear
a...Cheque printout to a file with date & amount converted to text/string
Print cheque output a text file, and this text file will be sent to
bank for further processing.
There are some fields are hardcoded and some are from GP fields,
including date and amount.
We modify the Report Writer for the Cheque printing, the added a few
of calculated fields.
Some calculated fields will contain text with hardcoded data (may
contain special characters, like comma and /)
Some calculated fields will hold data from the field found in GP and
if it is date format, it will be using RW_DateToString() to convert it
to string text and this calculated can be showing in...How do I remove * from text string in cell
I need to remove the asterisk character from a text string within Excel but
ordinary find/replace just sees it as a wildcard and deletes everything.
Search for ~* and it should work.
HTH. best wishes Harald
"Sue" <Sue@discussions.microsoft.com> skrev i melding
> I need to remove the asterisk character from a text string within Excel
> ordinary find/replace just sees it as a wildcard and deletes everything.
...XSD/XML -> RDB in .Net
Are there available samples or code which can create "create table" SQL
statements using provided XSD and/or XML?
Is it possible to get create table statements from DataSets / DataTables in
..Net? Any ideas how to approach this?
...saving over a document
<i>am working on a project for school that requires me to create multiple documents. i wrote one of my documents, saved it, then typed over it to started working on my next one. when i finished the next one, i accidentally pressed save instead of save as... and now i have two versions of my second document. Is there any way to go back to a previously saved version of my first document?</i>
Probably not, unless you have backups (say on using Time Machine or some
other backup strategy).
On 11/01/10 01:10, Briesayzhi@o...