How do I keep from printing blank pages in excel?
I'm trying to print only rows containing nonzero values in a specific column.
I can filter the data to show only rows with nonzero values but I am then
forced to reset my print area or I get blank pages. Is there an easier way?
You could press Ctrl-* to select just the current region, then use Print
Selection, rather than simply Print.
You can probably even record a macro incorporating those steps to speed it up.
> I'm trying to print only rows containing nonzero values in a specific column.
> I can filter the data to show only r...How to Convert UTC to localTIme(C# )
I have got the value of user account's lastlogon time. Its type is Int64.
This value is stored as a large integer that represents the number of 100
nanosecond intervals since January 1, 1601 (UTC)(Refer to MSDN).
I don't know how to convert this value to localTime.
The following is my code.
DirectoryEntry deUser = new DirectoryEntry(ldappath);
DirectorySearcher src = new DirectorySearcher(deUser);
src.Filter = "(&(objectClass=user)(SAMAccountName=" +
accountNa...Convert text to time value
I have a series of time values in a 'General' format. They are of the
Which is 18:45:25 or 6:45:25 pm.
A time which is am would be of the type:
Which is 1:23:45 am.
Is there a way to convert those 'General' values to an Excel serial so
that I can figure out the difference between two times? I've seen a
bunch of examples on the net, but none of those that I have found deal
with this format that I can tell.
"Andy" <email@example.com> schrieb...how to convert date
I'm looking for some method to convert mail date, in format:
eg. "Sun, 18 Sep 2005 20:57:08 +0200", to computer local time.
I tried CTime but without resoults.
Have you tried COleDateTime::ParseDateTime()?
> I'm looking for some method to convert mail date, in format:
> eg. "Sun, 18 Sep 2005 20:57:08 +0200", to computer local time.
> I tried CTime but without resoults.
>I'm looking for some method to convert mail date, in format:
>eg. "Sun, 18 Sep 2005 20:57:08 +0200&qu...CHm file format
I have seen your's reference on code project. I am new to CHM format and i
create a CHM viewer. I have some queries regarding the same
a) what is binary TOC and binary index ( I have been able to parse the HHc
and HHk fie). How i should parse the same
b) What are merged files. How i can read them
c) How how CHI, CHw and CHQ files can be created. How reading of these files
will be different form the reading CHM file.
Please help me out by answering my queries.
...How do I convert dates to text keeping the format?
I'm trying to convert a column of data in date format *m/d/yyyy to a text
format without converting to serial numbers. Ie: I want to retain the
mm/dd/yyyy format. Is there a way to do this?
"sprlarry" <firstname.lastname@example.org> wrote in message
> I'm trying to convert a column of data in date format *m/d/yyyy to a text
> format without converting to serial numbers. Ie: I want to retain the
> mm/dd/yyyy format. Is there a way to do this?
That ...Scheduled mail with outlook
Can outlook 2003 sent out a specific email every week on a specific time?
shon <email@example.com> wrote:
> Can outlook 2003 sent out a specific email every week on a specific
Yes, with some scripting. See
...Excel: Auto converting text to numbers
I am downloading an Excel sheet, and the numbers come in as text. It
basically comes in as "33 %" but Excel registers this as text, not a
I have a cell that will be used to add the numbers, but since they are
text it doesn't work.
Given this information, is there a way to convert the imported data
into numbers. I would prefer to include this into my formula. The
potential numbers are:
0, 1, 2, 3, 4, 0 %, 25 %, 33 %, 50 %, 67 %, 75 %, 100 %, and N/A
I would prefer a function, again if possible, that could convert any
number. Please note, the space between the nu...diagonal text
HOW DO I MAKE MY TEXT GO IN A DIAGONAL WAY ACROSS THE PAGE
On Sun, 30 Oct 2005 11:06:07 +0100, SCOTT wrote
(in article <8844C60C-FD08-4FB5-B289-D530CAA285DA@microsoft.com>):
> HOW DO I MAKE MY TEXT GO IN A DIAGONAL WAY ACROSS THE PAGE
Lose the caps. It's considered yelling, is incredibly rude and makes your
posts very hard to read.
Please explain what it is you're attempting to accomplish and your Publisher
By the way, questions end with question marks (?).
What version of Publisher are you using?
In 2000, arrange, rotate or flip, custom rotate, input your n...Sharing a excel document over the internet
I am looking to improve a few things with a client of mine. I have an
excel worksheet(office 2000, but we coudl also purchase office xp if
needed) which contains work that i have to do for my client. What i
would like to do is setup an excel doc that would inform us(depending
who modifies the document) that there were changes made (like in
outlook or something).
he writes that he wants me to install 2 new computers in section
d(whatever) of the office. HE then saves the excel file, and outlook
automatically sends me a notice that it has been modified. I then
double ...Cannot double click an excel file and open it.
When I double click an excel file, the excel application opens with a
grey screen. If I drag the file onto the grey screen it opens fine.
If I double click an excel attachement the excel screen opens grey and
I get a message box saying The system cannot find the file specified.
If I drag an excel file into the outlook inbox and then double click
on it, it launches as it would normaly.
I have un associated and re associated the file with Excel.
I have checked the selections under the window menu in Excel, but
unhide is greyed out, indicating that excel has opened, but not loaded
the fil...how to convert excel's .cvf file to .csv file
...Convert Access97 to 2000
Hello, we're currently running access97 and would like to convert it to
2000, but we don't know what is the administrator password for this
database. Also this database is running on multi user and have difference
permission for diffence users. Could someone help me how to do make this
happen but keep the currently permission retaint. Thanks
...Convert 2000 Calendar to web page
When I convert my calendar for 2005 to a webpage, the page is off by 1 day.
Is there a template or fix available to fix this?
I can edit the html file but this should not be the case. Fixes?
Suggestions...other than use Apple?
"Duane Perry" <firstname.lastname@example.org> wrote in message
> When I convert my calendar for 2005 to a webpage, the page is off by 1
> Is there a template or fix available to fix this?
...How to open excel with in IE
i want to open excel with in IE and shud be able to
control the object using script. If i use createobject, it
opens up a MS-Excel separately. is there a way to embed
excel with in IE.
...Add help text to a form field?
Operating System: Mac OS X 10.5 (Leopard)
I'd like to give people instructions about how to fill in form fields in the form itself. I tried "adding help text," but nothing shows up in the form field. Is what I am trying to do possible, and, if so, what am I doing wrong?
What you're using appears in the Status Bar when the field is accessed.
Unless people know to look there it does practically no good. IMHO it's more
effective to include instructional text as default content for the field or
provide explicit labeling in an adjacent table c...Files Publisher cannot open.
After creating files in Publisher 2003, most will not open. I get the
message"Publisher cannot open this file".
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=cbbcbdd8-ef0a-412a-9a74-65ca4bb16...change case of text #2
Some recent data was imported to an Excell worksheet that
had a large amount of text in capital letters. Is there a
way to change this data to "PROPER" throughout the entire
Gloria Anderson at Habitat for Humanity of Key West and
the Lower Florida Keys
will do the trick
"habikeys" <email@example.com> wrote in message
> Some recent data was imported to an Excell worksheet that
> had a large amount of text in capital letters. Is there a
> way to c...Importing text from an Explorer window
OS: XP, Excel 2002 SP3
I have my music stored in the My Music directory. I have Artist, Album
Title, etc. attributes turned on. What I'd like to do is to take all of this
information and input it into an Excel spreadsheet. When I "Select All" from
the window, and "Copy", it wants to copy the actual songs, and not the text.
Also, the "Paste" option in Excel is grayed out anyway.
Is there a way that I can treat the info in a Browser window as just text,
and then copy that info into a spreadsheet?
Here is one I have used...Font color automatic does not work in Excel
In MS Word 2003, Font Color Automatic changes to white when selecting a dark
Fill Color. In MS Excel 2003, Font Color Automatic always appears to be black
independently from Fill Color. Am I doing something wrong?
You're not doing anything wrong. Excel doesn't change the automatic font
colour if the cell is filled with a dark colour.
Eric Jan van de Veen wrote:
> In MS Word 2003, Font Color Automatic changes to white when selecting a dark
> Fill Color. In MS Excel 2003, Font Color Automatic always appears to be black
> independently from Fill Color. Am I doing something...Change color of row (Col A thru Col Q) based on text value in Col J
I am using David McRitchie's code for changing color of entire row
based on contents based on a specified cell text value:
'Target.EntireRow.Interior.ColorIndex = 36'.
This works fine; however, I only want to change color in the first 17
cells in each of the affected rows. How do I do this?
Also, I am confused: do I want the stmt 'Application.EnableEvents =
True' at the top of my coding in the 'Worksheet_Change' event coding
(occupies the Sheet1 Module)?
Target.EntireRow.resize(1,17).Interior.ColorIndex = 36
> I...XML Note convert to DataSet
I have this function:
object acmResponse = acmLogin.acmString("4001", "", paramFormLogin +
paramUserBasics);System.Xml.XmlNode acmNodes =
What I have todo, to convert the XML Object in the DataSet Object?
...Opening two separate instances of Excel
My users (who are accountants) use dual monitors and would like to open a
different Excel file on each monitor for the purposes of reviewing changes
between the two. I know that one method of doing this is by opening Excel
twice with its shortcut, then highlighting one Excel window and opening an
Excel file, then highlighting the other window and opening the other Excel
file. Unfortunately, the software that my users use to organize the Excel
files does not allow this to be done; it always opens every Excel file in the
first Excel window no matter which instance is highlighted. We had a...Convert
Is it possible to convert a Money file created in the USA version to that of
the UK version?
Thanks in advance
The general way is QIF Export then Import. It's involved and has limitations
like loan accounts don't QIF. See http://www.bollar.org/msmoney/#Q1.
"Crispy" <firstname.lastname@example.org> wrote in message
> Is it possible to convert a Money file created in the USA version to that
> the UK version?
...Format a concantated text string
Sorry if this is boring but I'm stuck.
I have a cell that counts something, it also has a piece of text at the
front of the count but I want the count to be formatted as currency and
I've tried ="Major "& Format(COUNTIF(C:C,"Major")*245****) but I can't
get it right and think it's a VBA command!
"Bob Phillips" <bob.phillips@notheretisca...