[O2007] -> How to search for a string in the body and get the line number?
I'm trying to get a reply to a mail message and look for a specific
Then I need to know the position of the line.
search "Sincerely yours,"
get the line number
insert 3 lines BEFORE the "Sincerly Yours"
I can't find a way. I know how to use Replace to change
subtrings, but I can't get a way to just locate one and get
the line number.
How can I do this?
Then, how can I insert text at that linePosition-3?
Thanks for any help.
(Remove the K_I_L_LSPAM from my email address)
------...ext. hard drive question
I have copied files from three pc's to an ext. harddrive. I didn't label
them as I should and now I am getting them mixed up.
How can I tell which pc they came from? two are XP and one is Vista.
From: "JS" <email@example.com>
| Hi all,
| I have copied files from three pc's to an ext. harddrive. I didn't label
| them as I should and now I am getting them mixed up.
| How can I tell which pc they came from? two are XP and one is Vista.
You can't. You need to practice better data storage management skil...Dynamic Chart Question #3
I'm trying to set up line charts for more than 40 different production
locations. But I would like to give the user the option of selecting one or
two (at most) locations then have Excel display the corresponding chart/s
instead of creating 40+ charts. Each location will have its own data table
(pounds/dollars). How do I go about doing this task?
when u change the way u look @ things, the things u look at change.
For information on dynamic charts and controlling which series are
displayed have a look at Jon's page.
Outlook/Exchange novice here....
I have a user that has archived files to different areas
on his laptop. He wants them all to appear in his folder
list under Archive Folders. If I copy and paste them into
docs and settings\%username%\local settings\application
data\microsoft\outlook do i need to rename the files so as
not to overwrite the one archived file that is in there?
In other words, what is the proper procedure to restore
these archived files that are not where Outlook 2k sees
them so that they can be viewed in his Archive Folders
What I would do is put...Convert Date string to date format
I have some date strings I need to convert to date format. For example im
trying to convert strings like "200910" to Oct-2009. I tried using something
like this to do it but I get an error:
Cell A4: "200910" this is the date string to be converted
Cell B4: =left(a4,4)&","&right(a4,2)&","&"01" changes to "2009,10,01"
Cell C4: =date(b4)
After converting to a date I would use the custom cell format "mmmm-yyyy" in
C4 to give the result of Oct-2009.
I get the error "You've entered too few a...Excel Number Question
I should know this one but I'm rusty.
I'm using Excel 97. I received a spreadsheet with a filed of Zip Codes
that has two different appearances. Most of the numbers are '85226 and
are left aligned. A few of them are 85226 (no ' ) and are right aligned.
Is there an easy way to edit the Zip Codes to remove the ' and have them
all line up the same way?
If you can read this, thank a teacher....
If you are reading it in English, thank a Veteran.....
With any empty cell selected, try:
Edit | Copy | Select zip code cells | Edit | Paste Special...OT: But should be easy question for experienced MSVC6 users
I can't compile my MSVC6 project. It's very frustrating.
(1) C:\Proj1\File1.cpp(938) : fatal error C1010: unexpected end of file
while looking for precompiled header directive
Note, I had this error. Have commented out the entire contents, am still
getting this error.
(2) BSCMAKE: error BK1506 : cannot open file '.\Debug\File1.sbr': No such
file or directory
I have know idea what this is on about.
On Tue, 2 Aug 2005 23:51:32 UTC, "Hamish" <firstname.lastname@example.org> wrote:
> I can't compile my MSVC6 project. It's very frustrating.
...Office 2K XL question please
I want to do an FFT on some data so in the HELP system I find I must
install the Analysis ToolPak. It even tells me how to install it:
"To install the Analysis ToolPak
On the Tools menu, click Add-Ins. "
Only problem is that there's no TOOLS on my menu. My top menu items are
FILE EDIT VIEW INSERT FORMAT DATA WINDOW HELP.
I looked everywhere for some other menu with TOOLS in it with no luck.
I did find a "Toolbar" but I saw nothing about any Analysis or Add-Ins.
If I ever get it installed, I'll need the TOOLS menu again for the HELP
tells how to use it:
&q...help.. multiple select in listctrl
I'm looking for the code to select multiple row in clistctrl by holding the
however i can select multiple item IF i drag the empty space at FIRST row,
and there's a rectangle when selecting the items.. i want to select multiple
items whether its in second column or in another column.
>I'm looking for the code to select multiple row in clistctrl by holding the
>however i can select multiple item IF i drag the empty space at FIRST row,
>and there's a rectangle when selecting the items.. i want ...Inventory questions- multiple parts???
Hi i have a question on inventory contol.
I make a product out of several parts, How can i add these
to the finished part, so when i sell it it deducts the
In other words i make a product, and in the product i use
Stainless springs and Stainless mounts. I want to have it
set up that when i sell my product, it deducts the springs
and mounts i have left, so i know when i am running low.
Right now i have the springs and mounts as "free products"
and i include it in the invoice, but i was hoping there is
an easier way.
Please email me, i don't check this board ...Merge cases / items into cases
With Dynamics CRM 3.0, is it possible to either merge cases in their
entirety, or merge additional items into a case? By additional items I
mean, for example, I have an ongoing case with a customer but then
they send me a new email (that doesn't have the CRM tags) - can I
merge that email into the existing case?
You can append the email to the case (providing the case is still open). To
do this, set the Regarding field of the email
David Jennaway - Microsoft Dynamics CRM MVP
...Comparing two versions of a worksheet
What is the best way to compare two versions of a work
sheet to determine changes that have been made?
Have any rows been inserted or deleted? Same for columns?
If none have--just data has changed, then Myrna Larson and Bill Manville have
written a comparison program
that does a cell by cell comparison (a1 with a1, x99 with x99).
You can find it at:
Look for Compare.
Billy Washam wrote:
> What is the best way to compare two versions of a work
> sheet to determine changes that have been made?
...Fuzzy string comparison / detecting "similar" strings
When dealing with real live data, you often have some
variation of minor errors in your data. E.g. I have
two lists (databases) in which Names sligthly differ.
"Clark Kent" vs "Clark Kent"
"John P. Smith" vs "John Paul Smith"
"Miller Limited" vs "Miller Ltd."
"Peter Hammer" vs "Petre Hammer"
I am looking for a way to handle this (semi-) automatic.
My idea is to have a function f, that takes two strings
and delivers a measure on how much the are alike. E.g.
f should be 1, if both arguments are identica...Database Runtime Question
I am designing a database in Access 2003. It is almost complete other then
the fact I need to create a runtime for it to enable PCs without Access to
view the database. My question is, when the runtime is created and installed
on the PCs that need it, if I need to add or make changes to the database
will the users with the runtime program be able to see these changes or would
I need to create a new runtime for them to see the changes? Thanks in
advance for your responses, they are appreciated:)
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/...Validating a Date String
Is there a function(s) for validating a Date stored in a CString? FYI, the
CString is set by an external program.
The input string is in the format of 2 digits for Day, 2 digits for Month, 2
digits for Year.
For example, how could I test "290204" is valid, "290205" is invalid.
You might check into COleDateTime::ParseDateTime to see if it will detect this, but it
requires you canonicalize the date into one of its acceptable formats. Otherwise, just
check the fields for consistency with leap-year status.
On Thu, 20 Apr 2006 22:43:01 -0700, Charles Tam <Cha...New here -- weird question
Hello all. I'm new here. I have a weird question.
Is there any way to import into Outlook 97 my settings, mails, address book,
etc., from Outlook Express 6? I'm on a WinXP system.
Unlikely. Versions are too disparate.
Did you try the Import Wizard's option to import from the concurrent
versions of OE?
"Jeff Needle" <email@example.com> wrote in message
> Hello all. I'm new here. I have a weird question.
> Is there any way to import into Outlook 97...How do I select which labels to print on the Avery sheet.
In Publisher 2003 can I select which lables to print on rather than produce a
whole sheet of labels the same as you can in Word.
Mary Sauer MSFT MVP
"Dennis the Menace" <Dennis the Menace@discussions.microsoft.com> wrote in message
> In Publisher 2003 can I select which lables to print on rather than produce a
> whole sheet of labels the same...Beginners Question
I know how to add two cells but I would like the cells to have a title within
the cell. Something like 8.5 Hrs, or 32 steaks. Something like that.
Thank you in Advance
or General "Steaks
The part before the text can be formatted in any of the standard number
It will appear as 32 Steaks, but all that will be held in the cell is 32,
which can then be used in further calculations if required.
"GordyB" <GordyB@discussions.microsoft.com> wrote in mess...Column chart question
How can I group data in column chart?
_Week_ _Day_ _Qty_
1- Fri - 200
2- Fri- 350
3- Fri- 150
1- Sat- 225
2 - Sat -200
3- Sat -100
How do I make column chart with all Fri together and all Sat togethe
and label the weeks
rajgopal's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=728
View this thread: http://www.excelforum.com/showthread.php?threadid=31952
You could create a pivot table with Weeks & Days as your axis.
So you will get a table like:
... ...question #5
I have normal excel document
consisted of 2 columns A and B.
In each columns there are 4000 rows.
In each row is url adress in form: http://www.studiotatjana.com
I want new list of urls in column C which is sum of values in column A and B.
So there will be 8000 urls in column C.
But there needs to be only one rule.
If value in one row of 4000 row in column A is
identical to any value in any row in column B then
that value do not go to colum C.
I want that if one url adress can be fund in column A and B
that that url is deleted and do not go to column C.
All values in colum A are difere...select and paste
I want to copy past a formula in an adjacent cell
and drag it down for all records in the adjacent cell.
There are thousands of records
Is there a way of selecting and pasting only the cells that has data in it..
rather than selecting the whole column and pasting it?
Yes, to select your column and then pull-down:
Edit > Goto... > Special and then check what you want - constants, formulae,
This will end up selecting only certain cells. The do the paste.
> I want to copy past a formula in an adjacent cell
> and drag it...Select Thing in Report
How can you set up when you run a report to only pick a certain information.
I have a table that has a drop down menu of locations, I would like to run a
report and when you go to run it it asks you what location you would like to
pick. If you could please reply when you get a chance. Thanks.
On Wed, 12 Mar 2008 17:42:00 -0700, Anthony wrote:
> How can you set up when you run a report to only pick a certain information.
> I have a table that has a drop down menu of locations, I would like to run a
> report and when you go to run it it asks you what location you would like t...Automatic print layout selection
Can you set up an option so that when you print a report, it automatically
selects landscape or portrait and fits the report to the page rather than
going to a 2nd line
You can modify the report with Report Writer and on the Report Definition
window change the Printer Orientation to Landscape. Don't forget to change
security to use the modified report.
You can also use Named Printers to change the printer properties to
landscape if the report is one controlled by Named Printers.
David Musgrave [MSFT]
Original Developer of Named Printers
Senior Development Consultant
Escalation Eng...Can combobox selection place another value in spreadsheet?
I have a combobox where the user selects a city. The cities come from
a spreadsheet where all the cities are listed in one column, and all of
their zip codes are in the column next to it. How can I allow the user
to pick a city, while putting that city's zip code into the spreadsheet?
If this is a combobox from the control toolbox (ActiveX) then set the
ListFillRange property to the address of the list (e.g Sheet3!$A$1:$A$100),
then set the LinkedCell property to a cell that will return the value of the
selected item in the combobox. I usually set this to the cell 'unde...WMP 11 WIN-XP_MCE = Rip Location question
I want to set my RIP location to a virtual (remote) drive ... not on my
computer, but visible and available. WMP 11 does not seem to be accepting
the UNC location; \\EXTERNAL\M-Drive\Music but WMP 11 keeps defaulting to
C:\Music ... is it possible to specify a UNC path or not ???
In WMP,click on tools,options,rip music tab,change the location.If its not
listed,go to hardware tab & edit for remote drive.
"PC Guy" wrote:
> I want to set my RIP location to a virtual (remote) drive ... not on my
> computer, but visible and available. WMP 11 does not...