Can i use Windows Search to find a number within Excel?
If i use Widnows search of the CONTENTS of files (not file names), i find in
Excel, that for cells that contain text, they can be found. But, it does
not appear to me that numbers can be found. Of course the number as Excel
stores it may differ from how it is displayed. But, does anybody know if
this is possible?
For instance, i have a cell with the number 3,709,227 in it, as it appears
in Excel (as formatted). I tried typing the number both with and without
the commas, into WIndows search, but Windows search still does not find the
Excel file that contains that number.
So, any kn...Excel 2007: Problem with refresh screen (when minimizied)
On our network (around 40 workstations; Win XP Pro and Office 2007) we have
particular the following problem:
The user minimized the Excel programm window and do some other works in
other applications, return to the minimized Excel window and want to maximize
the Excel window. Result: The Excel window is empty. You can paricular see
some rows or colums but often not. We try out also other graphic card but get
no success. Any ideas?
...Shutting off flags in Outlook 2007
How do I stop the message that says "message not sent" that pops up while
Is it an actual dialog box that comes up? What type of email account do you
have configured in Outlook?
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Exchange Messaging Outlook newsletter:
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exc...Finding the combination that appears more times
i have a list on excel 2007 that displays the purchase of items on columns
A:E, each column showing one (1) item
I want to find what combination of items appears more times, especifically,
which combination of four (4) is the favorite mix
A B C D F
A C D E F
B C D E F
B C D F Z
in this example, the winner would be (B, C, D, E) as it appears 3 times
the main problem is that I have over 1,000 rows
and trying with =SUMPRODUCT(COUNTIF(A1:E1,$N$1:$R$1)) por each combination
would take forever...
is there a simpler, quicker ...why won't my cursor advance in some word docs
I have several doc that suddenly are jamming all the letters on top of each
other on the left side of the page. When the doc is in web view, it shows
everything as normal, but when I click on normal or print view, it's just a
line of jumble. It also won't print our correctly. Not sure what I did to
cause this, but it sure is a pain. Any suggestions?
It is a printer driver bug and usually associated with HP printers. Do you
have a locally installed printer driver set as the windows default? When
this next happens, close Word and then reopen it to restore that pages
a...Find byte pattern in file (still desperate for solution)
I'm still desperately looking for a solution to this question. I need a
very intelligent way to find an array of bytes within a file, but not only
that preferably a regex expression of sorts.
For example my database has around 50,000 regex entries such as
"FFFF.*BB0403.*FF" that I want to turn into a byte array then search for. I
understand how to go about writing my own code for this, however it is a
little over my head when we're dealing with searching so many patterns
against many files while trying to be speedy about the operation. Does
anyone have any g...Make sure no running instances of MS Word
I need do some work which do not want any instances of MS Word existed.
How to make sure no running instances of MS Word?
and see if the PROCESSENTRY32 's szExeFile has winword.exe substring.
"lotus" <email@example.com> wrote in message
>I need do some work which do not want any instances of MS Word existed.
> How to make sure no running instances of MS Word?
...How: Link Word merge document to Quote from 'print quote for custo
In CRM 4.0 we want to do this as sometimes the sales person does minor
amendments to word merge document, and if customer looses quote and wants
another sent, any member of staff can send them a copy again.
Currently the workaround is to save to Word document and then add Note to
Quote and then attach Word file manually.
Is there a better way than this?
...Received mail notification in Outlook 2007
I am very satisfied with the performance of Outlook 2007, except I would
like to set it up so I would be notified of incomming mail with a voice,
such as "you got mail". Is it possible, and how?
That's a Windows setting in Control Panel, Sounds. Under Windows Sounds,
choose one for New mail Notification.
> I am very satisfied with the performance of Outlook 2007, except I would
> like to set it up so I would be notified of incomming mail with a voice,
> such as "you got mail". Is it possible, and how?
...Money 2007 Not Responding
Money 2007 Deluxe is periodically and un-reproduceably hanging during various
operations (transaction entering, balancing accounts, etc.) with no rhyme or
reason. My only option is to close Money by clicking the "X" in the upper
right-hand corner of the program. Vista then asks if I want to close or
wait. I've waited as long as 30 minutes with no response from Money, so I
always choose "Close". None of my data seems to get lost or garbled in any
This is a new installation of Money on a new computer with Vista. This is a
new money file that only has tra...Macro to run without any popups
I am a newbie but thought someone in this group could assist
Trying to accomplish the following:
Search for all ^p and replace them with ^| (soft return) and then find
the following text =93please call with questions=94 and put that in bold
anywhere in the sentence.
However I am able to do the soft return with a macro but I don=92t want
any popups to happen when I run the macro.
Is that possible?
Dim oRng As Word.Range
Set oRng = ActiveDocument.Content
.Text = "^p"
.Replacement.Text = "^l"
.Execute Replace:=wdRep...exchange 2007 delayed sending
a while ago I posted a message about delayed sending being stuck in the
outbox in outlook 2007
outlook can not be closed as then the email is not send
now I am trying to do the same but using outlook in online modus
instead, the messages are now send immediately
this even though the message header in outlook clearly states that the
message is not to be delivered before "date and time" (in the future)
how can I find out why this feature is not working (as expected)
This artical is very useful and it applies to Exchange/Outlook 2007 as well
http://blogs...How to change a Macro based on content of a cell
I need to import a text file into a spreadsheet. I can do this manually by
doing File > Open > then select a text file. Then Excel goes through the
Text Import Wizard
I can automate this by recording a Macro in Excel. The macro looks like this
(Excell wrote that for me, I did not):
Workbooks.OpenText Filename:="C:\DrillData\" + "MOR701.pck",
StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1),
, 1), Array(26, 1), Array(37, 1)), TrailingMinusNumbers:=True
How can I change ...Make combobox blank in macro
I use a wizard to create a combo box to find the record in my form. It
creates macro automatcially. Works fine. After finding the record, I
want to set the combo box to null or "" but need help add that line in
Sorry but not many people use macros (me too) so can’t really be help there.
But try this.
I assume your macro is search on a name ?
You have the ID field in the combo and the name and the ID field is the
bound column of the combo ???
1st MAKE A BACKUP OF YOUR DATABASE
Then – open you form in design view
Right click the combo an...Please help me with a couple of VBA related Word questions... than
1. If a group of users have a common template installed on their machine,
and they are all sent a document created with that template, is the
appropriate corresponding template identified by its filename, or by its
fully-qualified-folder-path-filename (which could be in different locations
on different client machines), or something else?
2. Can VBA code be separated from the document and distributed separately
from the document?
3. What's the best way of distributing changes to a VBA macro?
Thank you for your help
I do not have the facilities to the check a...Viewing Outlook 2007 calendar in a "stacked" view?
I used to be able to view my Outlook 2003 calendar in a "stacked" weekly view,
so rather than the vertical columns in 2007, I was able to see my week as
(imagine boxes around each day with the appointments listed underneath):
I can't seem to find this view now and I'm wondering if it's even an option?
Or do I just have to get used to 2007's vertical columns?
That view is gone in 2007
Trainer and Consultant www.pragmatix.com.au
Ou...Cannot find network neigberhood for XP?
I am using XP with SP3, and cannot find my netowork neigberhood, which
disappear on my desktop, does anyone have any suggestions on how to locate it?
Thanks in advance for any suggestions
"Eric" <Eric@discussions.microsoft.com> wrote in message
>I am using XP with SP3, and cannot find my netowork neigberhood, which
> disappear on my desktop, does anyone have any suggestions on how to locate
> Thanks in advance for any suggestions
Right-click on your desktop, pick Prope...Office v.X for Mac Compatibility Issues with Office 2007
I currently run Office v.X on my Mac and am unable to open Word documents sent to me with a ".docx" extension. Is there an update available for this?<br>
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
On 2/6/08 10:55 AM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <omnivoremange@officeformac...using find and replace it's making me look in another file to upd
I have used the find and replace function several times in the spreadsheet to
update the fromulas monthly. For some reason when I use it this month it
wants me to look in another file to "update values"? There is not another
file and there is no way for me to use the find and replace.
...Investigating macros and objects
I need to write some macros and to do so I must understand some of the Excel
functions. For example, when I record a macro to find something, I edit the
macro and find this:
Cells.Find(What:="actualaxis1", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
For example: What are all the options for "After:=" If I suspect that
"ActiveCell" does not fit my needs, what else can I put in here? In this
case, I don't want to look AFTER any particular cell, I wa...can't save files in subfolders using Word #2
I'm running Word on a Mac running OS X. When I go to save a file in
Word, it only gives me the option to save in the root files like
"Documents" or "Applications." How do I save the file into a
subfolder? On a PC, I would double click to open the folders until I
got to the folder I needed. That doesn't work here. Can someone help?
I'm sure this is something obvious I'm missing.
In article <firstname.lastname@example.org>,
> I'm sure this is something obvious I'...Publisher 2007 file is listed on my network, but the file wont ope
After designing a publisher application with Microsoft Office 2007, I have
saved the document to my local network, and ALAS, the folder containing the
file is "empty", but clicking on the folder shows the document(properties,
size etc.) but I cannot open/edit/rename the file! Any help is greatly
Can you open the file if you drag it to your local hard drive?
"jtjordan_design" <email@example.com> wrote in message
> After desi...Conditional Formatting in Excel 2007 #2
I have been asked to prepare a spreadsheet that uses conditional
formatting on another cell. What it needs to do is that is a cell
contains a particular value i.e. between 2 and 6 the adjacent cell
will turn say blue, but the issue is that there is up to 6 different
rules that could be applied to that one cell. All of these rules then
need to work for the subsequent entries.
If anyone could help me with this issue I would be very grateful.
On Tue, 19 Oct 2010 03:10:07 -0700 (PDT), didi <firstname.lastname@example.org>
>I have been a...toolbar macros #2
I've gone through the routine to assign a macro to a toolbar button, even
down to getting the option to select the macro, but it isn't permanent. When
I click on the button afterwards,I get the same dialog to assign the macro.
However, I can permanently assign the same macro to a graphic in the sheet.
Second quandary - Can I assign that same macro to a cell which has only text?
...How do I compare 2 worksheets, 1 old, 1 updated to find difference
I have 2 large worksheets of text information, the 2nd being an update of the
first, I need to identify/highlight the updated fields. Is there a way to do
There is a workbook compare add-in by Myrna Larsen and Bill Manville on Chip
Pearson's site you might try:
"alienstew" <email@example.com> wrote in message
|I have 2 large worksheets of text information, the 2nd being an update of
| first, I need to identify/highlig...