HDD Serial Number.
I want to find out the HDD Serial Number in my C++ Code.
There seems to be a way using the WMI. But I donot (cannot) use it.
I want to know if there is some C++, C or assembly code that can help me do
Any help/suggestions would be very helpful and highly appreciated.
You can do this with GetVolumeInformation()
"Anwar Khan" wrote:
> I want to find out the HDD Serial Number in my C++ Code.
> There seems to be a way using the WMI. But I donot (cannot) use it.
> I want to know if there is some C++, C or assembly code that can help me do
&g...How can I extend maximum number of records when opening sylk file?
When opening a .slk file in Excel 2002 you can only see the first 32,767
I have a file that is larger than this , and therefore I cannot see all of
I know that you can extend the maximum number of records when opening a text
file - I just need to know how to do it.
Can anybody help me please?
Opening a text file and a SYLK file are two different operations "under the
hood". If 32,767 is the limit, there's probably not much you can do about it.
Do you have control over the workbook from which the SLK file was produced? If
so, can you split it into two ...adding history text to bulk contact records- from an Excel spreads
we have an excel spreadsheet that contains contact record naming as in CRM
and an additional column of text- we want to place this text into the contact
record- each contact record has a different history text that needs to be
added as a history item - the contacts exist in CRM already- we are just
wanting to find a easy sure way to add the history
...Preventing rounding numbers to nearest dollar
When entering currency data into a form Access rounds the number up or down
to the nearest dollar. The fields for the form and table are formatted for
currency, 2 decimal places, field size is long integer. I am not using any
queries. How do I prevent rounding numbers to nearest dollar?
MS Access 2003
> When entering currency data into a form Access rounds the number up or
> to the nearest dollar. The fields for the form and table are formatted for
> currency, 2 decimal places, field size is long integer.
Since Long data types are "whole num...Page numbers when I have 2 section breaks in 1 page
What do I do with my page numbers when I have 2 section breaks in 1 page.
-(Page) at (SectionPages)-
Right now it says 1 to 1 beacause of the section breaks. I would like it to
be 1 to 5 ex.
My problem is that I have a title which is framed in 2 section breaks. Im
doing this because I write in columns and i dont want the title to be in
columns-format. The problem is so, that it counts the title of an independent
section and confuse the page number. How do I get it to count for a single
Instead of using section breaks around the title, I would pro...How do I locate my product key number
I did not receive a confirmation e-mail with my product key number when I
downloaded the 60-day free trial of Microsoft Office 2007. How do I locate
You need that email.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Pat77" <Pat77@discussions.microsoft.com> wrote in message
>I did not receive a confirmation e-mail with my product key number when I
> downloaded the 60-day free trial of Microsoft Office 2007. How do I
> l...count number of "D"
I am new to excel .. here is my requirements.
449 78 d
449 69 m d
458 260 m
469 28 m
472 39 m
479 51 d
484 59 m d
i need to count number of "d" present in the 4 th column and number of
m present in the 3 column.. its a very big table and i need to
how to do it?
thanks in advance !!
jayender.vs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28640
View ...page number in each section
I have several section and the footer shows page # of #. In each section, I
want it to start at 1 of number of pages in the section. I figured out how
to change the first number so it is correct-- but I can not figure out how to
change the total number of pages in the document to the total number of pages
in the section.
How do you change it so is show the total number of pages in the section?
Use the SectionPages field instead of NumPages.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mv...Divide number and add remainder in another cell
Can someone help me? I made a work distribution spreadsheet and I can not get
it to divide evenly. What I am trying to do is divide the total number of
claims by the number of employees and distribute the result to each employee.
There are conditions also. For example one employee gets the max number of 50;
Here is my formula;
column E =# of hours working for each employee,
I19 = total number of claims.
If the total number of claims is 1500 and there are 5 people working it
returns 50 to the E18 employee and 363 to the rest, but t...Styles and Set Numbering Value problem
Running MS Office Pro 2007 with Windows XP Pro.
I have styles defined for numbered lists. These styles have simple
characteristics, like indent, space before, etc. - nothing special.
I want the numbered lists to appear throughout the document, with each
starting at the number 1. When I try to start a new list using the Set
Numbering Value dialog, I get a message saying "Changing the number format
for this list updates the style "NumList" and reapplies the style to each
paragraph. Do you want to continue?" If I select no, the starting number is
not chan...Convert Column Number to Column Letter
I have the last column of data. I want to use a range to say copy or define
something. So how do you convert the number LastCol to a letter to display
in a Range:
LastCol = ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column
A web search for "convert column number to letter" turned up several hits,
one of which was:
look at the last 3 posts in that discussion. Two ways to get the job done.
Personally, since you've gone the route you have at this point, I'd probably
go with the solution in the last ...Seperating Numbers and Text
I need to seperate the numbers and words in the same cell. Not all tex
and/or numbers are the same or are the same amount of characters.
is all in the same cell
22454 to be in one cell and
IN in another cell to the right
Message posted from http://www.ExcelForum.com
I assume that the original cell is text. If it is, then
you can look for the position of a blank, then separate the
two based on the blank location. If cell A1 has "22454 IN",
In cell A2: = Search(" ". A1)
In cell A3: = Left(A1,A2-1)
In cell A4: = Right(A1,Len(A1) -...limit text length in a text box in excel 2003
I'm trying to limit the text length in a text box but i can't find the option
to do so
For a textbox from the Control Toolbox Menu or on a userform: In design mode, right-click the text
box and choose properties and set the MaxLength value.
MS Excel MVP
"Darren" <Darren@discussions.microsoft.com> wrote in message
> I'm trying to limit the text length in a text box but i can't find the option
> to do so
> please help
...Inventory Adjustment with Lot Number
How do you remove a quantity from inventory for an item that uses lot
numbers. Currently the Stock Status reports shows a quantity of 167 but it
should say zero. I tried doing an inventory adjustment and I had to create a
new lot number. It posted through ok, but when I check the Stock Status
report, the item is still there showing 167. I'm stumped.
> How do you remove a quantity from inventory for an item that uses lot
> numbers. Currently the Stock Status reports shows a quantity of 167 but it
> should say zero. I tried doing an invent...Returning last number(time) in a row of cells
Need some help with this one please;
Row A4 thru J4
A4 B4 C4 D4 E4 F4 G4 H4 I4 J4
12:00 15:00 16:00
I need to return to cell K4 the last number in the above row.
I do not know what formula to use. Any help would be greatly appreciated.
There are several ways to achieve that, - here are two:
> Need some help with this one please;
> Row A4 thru J4
> A4 B4 C4 D4 E4 F4 G4 H4 I4 J4
> 12:00 15:00 16:00
> ...Deleting all even numbered rows?? Help
I have some data up to row 2200. Unfortunately, the data was capture
with a glitch, to where all even numbered rows (2, 4, 6,.....2200
contain bogus data.
I want to delete all even numbered rows in the spreadsheet, and hav
the 1100 odd numbered rows shift up, so I have only 1100 rows of th
real data on the spreadsheet
Yel268's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1570
View this thread: http://www.excelforum.com/showthread.php?threadid=27234
- in a helper c...numbers in text box
I am recieve data from a scale in text box. It has number and other carater.
How I could take only number in text box. I am work with 2008.
thanks for your help
"Roberto Londono" <RobertoLondono@discussions.microsoft.com> wrote in
>I am recieve data from a scale in text box. It has number and other
> How I could take only number in text box. I am work with 2008.
> thanks for your help
It depends on how you receive your data, but I did this for a similar
situation. I...Text Formatting within a cell
I know there is a way, I've seen it before I just can't figure it out
or find it online. How in the world would I go about formatting a range
of cells to make all text within that cell proper. I am not talking
about the function "PROPER" but I need the same thing accomplished
without having to pull the information from another cell to make it
"proper" by proper of course i mean the first letter of the word will
be capitalized. I need to be able to enter a first name into a cell and
have that cell auto format the name to capitalize the first letter
regardless...Sumproduct with multiple text criteria
I have seen this question answered a couple times but none fit my situation.
I am trying to use the following formula:
=SUMPRODUCT(--(AL2:AL50000="*GGF*"),--(AD2:AD50000="Charleston")) to search
two columns of text and return the count for the rows that meet both
criteria. (If AL2 has the text GGF somewhere in the cells text string and AD2
has the text Charleston in its cell, then it would count 1.)
It is not giving me the count that is correct, it is returning a zero. My
problem is that the text string in column AL contains different strings of
text, and I only wan...how do i set a conditional text in Excel?
how r u all,, i have a small prob. i hope u can help me with
i've created a drop down list in excel in one coloumn (the entire coloumn's
cells contains the same list). .. the next coloumn should show the ID of the
chosen data from the list. ID's r unique for each entery,, there are about 47
how can i do that?
it sounds like you need to use the VLOOKUP function in the cell to the right
of your drop down.
to do this you'll need a table somewhere else in the workbook which has the
values in the dropdown box and the ID's listed
e.g. Sheet 2
..........Turn Text Box 90 degrees
I have a text box in my application that is linked to another cell, but I
need to turn the text in the box 90 degrees so that it reads from the botom
I can't find any option in the text box properties that allow me to achieve
this, does anyone know how I can do this?
Hi, Neil. Click on the edge of the text box to select the box, and click on
Format | Text Box | Alignment | Orientation: <choose desired orientation> |
> I have a text box in my application that is linked to another cell, but I
> need to turn the text in the b...curving text
I'm working in Publisher 2003 on posters/applications/etc. material for a
local Boys & Girls Club event. I want the name of the event in Comic font
and want to arc the name like a rainbow. Also, I want to use different
bright colors for the letters that make up the name. I've tried the WordArt
option but can't change the color of individual letters. I'm on a deadline.
Help greatly appreciated!
Cindita <Cindita@discussions.microsoft.com> was very recently heard to
> I'm working in Publisher 2003 on posters/applications/etc. material...Select all text in single section break.
I am looking for an easy key stroke way to select all text in a single
section break. I hope there is something similar to Ctrl "A" which selects
the entire document. I have 10 headers and need to select everything in just
one. I really would like a key stroke solutions because I am using VB to
automate some reporting. I need to make sure everything in the one section
is selected, so I can delete it and replace it with data from a different
I'm not sure I understand the question. Assuming that you are referring to
sections as paragraphs (perhaps Head...Text Alignment in Excel Cells
I am working with a spreadsheet containing numbers of varying values (i.e.,
100, 1100, 11000, 0.1, etc.). I am trying to find out if there is a way to
BOTH center AND right justify numbers within columns of cells so that they
align by the last digit on the right. Obviously, just pressing center, left
or right justify won't do it. Help would be appreciated.
See the table in
0.????_);(0.????);0.????;@ [align on decimal point]
David McRitchie, Microsoft MVP - Excel [site changed N...Inserted Picture Gets Forced to 32x32
I inserted a picture into my email body (HTML format) without specifying the
size (I want the reader to see it in its natural size). Sometimes (usually
when it is a forward of an existing mail) the recipient receives it in
32x32. Why does this happen? The
copy in my Sent folder looks normal. Sample of what recipient receives is
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><img width=32 height=32