when I enter file on a header the extension xls is also printed. How do I
stop this happening?
If you go to Windows Explorer and on the Tools menu,
choose Folder Options and then click the View Tab. Scroll
down until you find the check box that says 'Hide file
extensions for know file types. If you click this box to
check it on, your .xls should be hidden. You will
probably have to close Excel and restart it and then it
Hope this helps
>when I enter file on a header the extension xls is also
printed. How do I
>stop...Hide Global.xls (personal.xls) in project explorer
How do I hide VBAProject(Global.xls) in project explorer. I just want
my normal project there.
You can't hide it, but you could give it a password:
Select your project
Give it a memorable password
At least the project won't be too intrusive.
> How do I hide VBAProject(Global.xls) in project explorer. I just want
> my normal project there.
...xls attachment became dat
Hi all. Recently i received an email that was send to me and my colleague.
The attachment is of xls but when i received it, it was in the form of dat.
My colleague received it as xls. Is there anything wrong with my outlook?
Are you using Microsoft Outlook or Outlook Express? These two are very
different programs where one can handle Rich Text messages (Microsoft
Outlook) while the other cannot. The common message formats between
Microsoft Outlook and Outlook Express is Plain Text and/or HTML. Therefore
I would double check with the sender to verify that they sent the message in
Pla...controling a .xls from another .xls
does anyone know if it is possible to control one excell file from
another. i.e lets say there are two files:
in "a.xls" cell A1 we input the number "100", is it possible for this
number to automatically be populated in to cell A1 of "b.xls"??? if so
on-a-mission's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31630
View this thread: http://www.excelforum.com/showthread.php?threadid=513234
In cell A...Saving .xls without macro
I did a search for this issue, but I can't find anything related t
This is my issue:
I have an .xlt which contains macro, at the end of the macro I save th
resulting sheets as .xls. The resulting sheets are saved with origina
macro. I wonder is there a way that I could save the file without th
I am using this code to save my file as .xls.
File_Save_Name = Sheets("Menu").Range("D6").Value & Format _(Now
"mmddyy") & ".xls"
ActiveWorkbook.SaveAs FileName:=File_Save_Name, FileFormat:= _
xlNormal, Password:="",...I'm getting files saved with names like 48A52100 with no .xls f.
I'm getting spreadsheets saved on our network with an 8-character string as
the filename and no .xls file extension. Using the "Open with . . ." option
they successfully open with Excel. Does anyone know why this is happening?
Iain N Black
These are temp files created when Excel saves a workbook. Normally they are deleted
when the save is complete. This might fall under the funny behaviors that occur when
working with files on a network.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech...importing .xls chart info to .xls calendar
Operating System: Mac OS X 10.6 (Snow Leopard)
How do I take the information in an .xls file and import it to a blank .xls calendar?
...launching xls in web browser
I am trying to launch two instances of the same xls file from a browser. The
first one launches successfully in a new browser window. The second one also
launches successfully. However, the first browser window becomes blank after
the second report launches. When I close the first browser window the second
window becomes blank as well. Does anyone know how to fix this problem?
...Opening xls files in word
When I open an excel file it opens in word. If I open
Excel and then open the file it opens properly. How do I
change the default to open all excel files in excel?
Open up Windows Explorer, click the 'Tools' toolbar and
then 'Folder Options...'. Click the 'File Types' tab, and
scroll down to find the XLS file extension.
Highlight "XLS" - I think it will say that it's set to
open with Microsoft Word. If so, click the 'Change'
button and set it to open with Microsoft Ex...xls:1 but no xls:2
I have a workbook which opens with the window title
as if there are two or more views of the same workbook. However, there
is only one view I can find (I have minimised the window within Excel,
looked for other Excel windows but to no avail).
When I try to close the file (ctrl-w or clicking the lower x) the
workbook disappears (as expected) but Excel behaves as if I have just
closed one of several views: it doesn't ask me if I would like to save
changes. However, when I close the Excel program, it behaves as if I am
closing filename.xls and asks if I ...I do not have Excel, can I read .xls files sent to me?
I do not have Excel, yet I am sent .xls files. Is there anyway I can read
these files even though I do not have Excel? I have WorksSuite 2003.
you may try the free Excel viewer:
> I do not have Excel, yet I am sent .xls files. Is there anyway I can read
> these files even though I do not have Excel? I have WorksSuite 2003.
Try the free Excel viewer from Microsoft
-...Save .xls as fixed width text or csv
How do I save an Excel file as a Fixed Width Text file?
Save it as a space delimited text file *.prn
"Brian Jenkins" <email@example.com> wrote in message
> How do I save an Excel file as a Fixed Width Text file?
...import groups from xls
In outlook 20000, If I have an excel spreadsheet with First, Last and email
address for 50 people, can I import it as a group into outlook?
Authority does not make you a leader It gives you the opportunity to be
one. - Anonymous
You can import it into your Contacts folder. You'd still have to then either
create a distribution list manually or add each of these 50 people to the To
or BCC field for an email message.
Author, Special Edition Using Microsoft Outlook 2003
Author, Absolute Beginner's Guide...Convert CSV Files to XLS
I have approximately 1300 .csv files that I need to convert to .xls
files so I can extract data from a master spreadsheet. Excel
apparently requires a .csv file be open to extract the data.
I could open each one individually and do a save as, but that would be
rather tedious. Is there a way to programmatically do this. The .csv
files are in the following format:
xx is 01-29 (notice the leading 0)
n is n
zz is 01-110 (notice the leading 0 on 1 digit numbers and that the
highest number is 3 digits, 2 digit numbers have no leading 0 i.e.
"Pigs can't be...Open File gives me *.xls:1 and *.xls:2. What is this?
When I open a particular file provided by a client it opens two copies :1 and
:2. and 1 is hidden.
If there's a short explanation for what causes this and what it means I'd
Otherwise what should I search under in Help or elsewhere for more info.
creates these windows.
if book1.xls:1 is truely hidden, you can use windows|Unhide to, er, unhide it.
After it's showing, you can click on the window you don't want and hit ctrl-w to
> When I open a particular file provided by a client it opens two co...Extracting OE 2007 Address book to .xls?
How can I extract OE 2007 Address book (or at least part of it?) in a
Thank you in advance,
Assuming OE 2007 = Outlook 2007 which ships with office: File, Import and
Export or create a view with the fields you need and copy, then paste into
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outloo...Multiple xls into one xls
I have 162 separate xls files that I have used for mail
merges. All the fields (column headers) are identical,
just the data is different.
I would like to amalgamate all of these into one single
xls file. How can I do this?
I promise to use a database next time! :)
Thanks very much, quick too. :)
>Regards Ron de Bruin
>(Win XP Pro SP-1 XL2002 SP-2)
>"James Searle" <firstname.lastname@example.org> wrote in
me...Shared xls using ODBC/JET
In a LAN, while a user is working on an XLS file, form many other hosts a
tool I have to write should be able to view information from it (using ODBC).
My test works only when the XLS file is closed.
When it is opened (on the machine where they modify it through Excel), I get:
The Microsoft Jet database engine cannot open the file '(unknown)'.
It is already opened exclusively by another user...
(Another strange case: it happened that my code receives 'actual' values
when the xls is closed, 'possibly older values', without returning the above
mentio...how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.
how do i password protect an .xls file? how do i unlock it for automation.
e.g. want to unlock and access a .xls from another .xls macro.
> how do i password protect an .xls file? how do i unlock it for automation.
> e.g. want to unlock and access a .xls from another .xls macro.
Do you want file protection or just workbook or worksheet protection?
...What does it mean to have a file name followed by .xls:1 etc.?
I received an Excel spreadsheet that produces two separate spreadsheets when
I open it. They have the same names except that one is .xls:1 and the other
..xls:2 and I have not been able to find what this signifies.
Those are multiple windows that view the same Excel file.
You create them by selecting Window>New Window.
If you close the :2 window, the other will still be open (but the :1 will no
Does that help?
> I received an Excel spreadsheet that produces two separate spreadsheets when
> I open it. They ha...Appendig all xls files in xls 2007
Does someone have a macro or script to append a bunch of xls files in
a directory into 1 xls file? I am using Excell 2007. Thanks!
Regards Ron de Bruin
<email@example.com> wrote in message news:firstname.lastname@example.org...
> Does someone have a macro or script to append a bunch of xls files in
> a directory into 1 xls file? I am using Excell 2007. Thanks!
E...Export xls to dbf
I have an excel file with some columns and headings, some columns have
no data and others do. When I try to save it as a dbf file and then
open it with DBase the empty fields at the end have all kinds of
...Opening XLS files directly
OK I apologize for the bad subject line but this is a strange problem.
Guru's, I am at your mercy!
Let me lay out some basic stuff. PC running Windows 2000 Pro Office 2000
with latest patches and updates installed 1.8 Ghz, 512 mb memory, over 80
gig's on hard drives available.
When the user double-clicks on an Excel icon, Excel starts but before the
sheet can be displayed an error box shows up. It states, "Cannot find the
file "[file requested]" (or on of its components). Make sure the path and
filename are correct and that all required libraries are available."...Convert XLS to XML without XLS Properties
I need to convert one excel (xls) file to XML file without the excel
properties like height, width, font etc. This appears as 'Style'
statements in the XML file.
Following is the sample XML file showing the Style statments-
<Interior ss:Color="#FFCC99" ss:Pattern=&...XLS Viewer for 98SE
Viruses wiped out my viewer and Microsoft has stopped supporting 98. I've
googeled and tried several and no luck. Anyone know where a viewer can be
By 98 do you mean Office 98 for the Mac?
There never was an Office 98 for the PC.
This viewer will service all versions of Office in a Windows OS.
Gord Dibben MS Excel MVP
On Tue, 3 Oct 2006 11:20:09 -0500, "R Hall" <rh...