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?
...excel 97 filename truncation in Windows XP Pro
I have a legacy application that runs in Excel 97. I have
Excel 97 and Excel XP loaded on a new machine that runs
Windows XP Pro. The legacy application fails because the
filename of a workbook is truncated during the saveas
command. When I do a manual saveas in Excel 97, the
filename truncates to the first letter. If I do the same
thing in Excel XP, the saveas works normally.
There have been a few posts describing the same problem. I searched google and
The last post in the thread suggested an answe...isv.config file
We have altered the isv.config file to show additional tabs and
buttons in the CRM forms. These tabs and buttons show and work fine in
the web client but are not available to the sales for outlook client.
They do not show in Outlook.
Should this customisation show in the sales for outlook client?
if you look in your _resources directory under wwwroot on the crm web server
you will see a file called OutlookClient_sample.xml
you use this file for the outlook client config file. so you duplicate
anything in isv.config to this file and call it i think OutlookClient.config
...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...How to copy iPhone SMS to TXT file on computer?
[url=http://www.backup-iphone-sms.com/how-to-copy-iphone-sms-to-txt-file.html][b]How to copy iPhone SMS to TXT file with iPhone SMS Backup software on computer?[/b][/url]What is .txt file: .txt is a filename extension for files consisting of text usually contain very little formatting (ex: no bolding or italics). Files with the .txt extension can easily be read or opened by any program that reads text and, for that reason, are considered universal (or platform independent).With Tansee iPhone Transfer SMS, you can [b]backup iPhone SMS to PC as a txt[/b] file and keep them safe. [b]Guide of how ...Office 2003 Opening a new Excel Doc.
I just updated to Office 2003 and everytime I open up a new workbook a blank
workbook name PERSONAL opens as well. How do I change that from happeneing??
Window>Hide and save the personal.xls
When you record a macro you have the option to save the macro
in this hidden workbook so you can use the macro in all your workbooks.
You can find the file in your Xlstart folder
Regards Ron de Bruin
"Jesse" <Jesse@discussions.microsoft.com> wrote in message news:65505D55-31EB-4BAA-A32D-B052F70E03AD@microsoft.com...
>I just...Renaming Files
I have a great number of files labeled with a first name followed by a
last name and a date. I need to switch the file names and save them as
Last Name First Name followed by the date? Any suggestion on how to do
Is there a character which separates the names, like space or
If your file names are 3 parts each separated by a space:
John Smith 12022005.xls
Something like this might work:
Dim wkbk As Workbook
Dim myFileNames As Variant
Dim NewFileName As String
Dim iCtr As Long
Dim lCtr As Long
Dim myName A...Two Excel tables in MS Query
How can I link two tables in two Excel-files, in MS Query and result view in
I can link two tables in one Excel-file.
ActiveSheet.PivotTableWizard SourceType:=xlExternal, SourceData:=Array( _
"SELECT `TKG_DATA$`.YEAR, `TKG_DATA$`.MONTH, `TKG_DATA$`.DAY,
`TKG_DATA$`.TIME, `TKG_DATA$`.`INC/OUT`, `TKG_DATA$`.`C59/170`,
`TKG_DATA$`.`C46/158`, `TKG_DATA$`.`C356/137`, `TKG_DATA$`.`C355/358`, `TKG" _
"_DATA$`.`C354/357`, `TKG_DATA$`.`C32/142`, `TKG_DATA$`.`C30/116`,
`TKG_D...Problems during Outlook 2003 start
Greetings to Everybody
I've a problem during the start of Outlook 2003:
Last week I've installed and removed the program Motorola Mobile Phone
Tools. Now everytime that I start outlook appears an error message about
the impossibility to found a DLL called Out97.dll placed in the folde
c:\programmi\mobile phone tools.
In the error message is written to try to use the option "Rileva Problemi e
ripristina" in the menu ?(English translation is about Find Problems and
reset" but I don't think that in the English version of Outlook the menu is
called like this) but if I ch...Merging excel office data into a publisher office project(Australi
Having problems when I get to the point in the merge wizard "catalog merge
template", with the DOB format to be entered into the membership card that I
have made in Publisher. It reverts back to American date format.
Could the problem be in the edit record section?
All seems to be okay till then. I have checked the regional settings etc.,
When I have finished template of merge & highlighted the DOB field gone to
language on tool bar and set language it still doesn't work then preview, it
has reverted to American.
...Deleting Rows Automatically using a Text File List
I have a text file list of .jpg files that I want to delete (rows) from
Excel. The list has 800+ items in it. Deleting these rows one at a
time in Excel (after doing a "find") is terribly time consuming. Does
anyone know how to make Excel read my text file and delete the rows
with that filename in it (automatically). The filename (listed in the
text file) is in a column (in my excel sheet) called "filename".
Any help would be most appreciated!!! Seriously! I may have to spend
hours on this otherwise!
------------------------------...how do I tell excell 2003 to print sheets back to front?
In excel 97 I could tell printer to start printing from the back page to the
front so the job would come off of the printer in the right order. I cannot
find that command in excell 2003. Am I overlooking it, or have they changed
the command convention to an obscure, hard to understand, jargon.
FILE | PRINT... | Click on the PROPERTIES button | PAGE ORDER, i.e. back to
> In excel 97 I could tell printer to start printing from the back page to the
> front so the job would come off of the printer in the right order. I cannot
> find that co...Insert .gif into protected doc
I have a document that I'm protecting from editing- all but 4 cells. In one
of those 4 cells I want users to be able to insert a .gif. I'm able to type
in those cells, but I can't insert a .gif. How do I enable this?
Basically, I want to allow users to insert a .gif into a protected document,
is this possible? I don't want them to know the password or to unprotect
the doc in order to do this.
"Michael Miazga" <firstname.lastname@example.org> wrote in message
> I have a document that I'm protecting from editing- a...Export Excel file to SQL
I'm currently doing a project where it require client to
export excel spreadsheets to SQL. the application that is
using the excel spreadsheet exported is a web-based
application. Is it possible to do that? Any suggestion or
recommendation is greatly appreciated. thank you
Go to Enterprise Manager.
Browse to your database in the left pane (object browser).
Right click your database.
All Tasks --> Import Data.
Set your datasource to Microsoft Excel 97-2000 or whichever Excel version you have.
Click the ... button next to the File Name text box and browse to your Excel sheet.
M...Excell Cells: Auto Formatting
I have protected a workesheet and unfortunately when the people submit
information on the cells and it is too long than the actual height of the row
and it wont extend. What can I do?
When protecting the sheet allow users to format cells and rows.
Gord Dibben MS Excel MVP
On Tue, 9 Feb 2010 13:14:01 -0800, Sophie <Sophie@discussions.microsoft.com>
>I have protected a workesheet and unfortunately when the people submit
>information on the cells and it is too long than the actual height of the row
> and it wont extend. What can I do?
How do I jus...How can i get more 3D shapes for Auto shapes in excel?
Please suggest how i can get more shapes (simple as well as 3D ) in Auto
Shapes of drawing toolbar in excel & word?
...How do I create a drop down list in Excel 2003
How do I create a drop down list in Excel 2003. I've tried to use the help
menu and I cannot figure it out.
"Lenny" <Lenny@discussions.microsoft.com> wrote in message
> How do I create a drop down list in Excel 2003. I've tried to use the help
> menu and I cannot figure it out.
...Watermark in excel 2000
I'm trying to insert a watermark from a jpg file.
The probem is the watermark always stays on top and cover the text, no
matter I use the "send to back" button on or the item.
maybe the following sites will help you:
And for Excel 2002+:
>I'm trying to insert a watermark from a jpg file.
>The probem is the watermark always stays on top and cover
the text, no
>matter I use the "send ...Maximum value to use autofiler feature in excel
Hi, does anybody know the maximum value to use autofilter
in ms excel? I heard my friend told me that excel could
filter only select data is less than 1000. He told me that
he has 4000 row and use autofilter, an expected record is
more than a thousand but the record display only 1000
maximum. I want to test like him too but I don't have any
file that contain alot many thousand of record.
Does anybody have any idea?
"Roath Kanel" <email@example.com> schrie...Importing a CSV file
I want to import a file into physical inventory. Here is what I do:
1) Run a Quantity report(I don't think the report really matters)
2) I put it in alphabetical order, then I export it using RMS Manager into a
3) I go into Inventory > Physical Inventory, and I click on New and Manuel
4) I import the file...it works just fine!!!
If you in any way alter the .CSV file, and save it again, in the same format
Steps 1 - 4 won't work...WHY WHAT THE HECK AM I DOING WRONG???
The problem might be the Item Lookup Codes are being modified by ...Excel 2000 #38
Hi - I use Excel 2000 and wish to display negative number, accounting and
currency values in parentheses. However in the Format Cell function in Excel
there is no option to use parentheses. The only option is to use the -ve
symbol or to display the value in red. How do I display the value in
Mike from Australia
> Hi - I use Excel 2000 and wish to display negative number, accounting and
> currency values in parentheses. However in the Format Cell functio...Excel 2003 ODBC Add-in
Where can I download Excel 2003 ODBC Add-In from ?
MS no longer delivers this addin with Excel 2003. But check out:
"Excel2003User" <Excel2003User@discussions.microsoft.com> schrieb im
> Where can I download Excel 2003 ODBC Add-In from ?
I am attempting to make a theme file that will work on any computer that I
want it to. So far I have made it work on my computer. When opened on other
computers it only does some of what I want it to do. Anything anyone could
suggest would be great.
Themes are not part of Access, they are part of Windows. Your question may
be better answered in a newsgroup appropriate to your problem. This
newsgroup is dedicated to the Microsoft Access database product.
Arvin Meyer, MCP, MVP
"Nathan Ri...DDE link error Excel freezes
I am using Excel 2003 and in one sheet I have a DDE link from anothe
program. When I open the sheet I get a question wether I want to updat
the fields or not. When I click YES the sheet normally opens and I ca
view the data. But sometimes it seems like Excel freezes and I have t
wait 3-5 minutes until it resumes.
Anyone that has any idea why?
The source program is always started first by the way.
Message posted from http://www.ExcelForum.com