How to open Book1.xls file.?

The easy way (but labor intensive) is to put the file names in a column (can be any name you want or the pdf file name), right click on a cell, hit insert hyperlink, and in the address field at bottom, put in the file pdf file name. You would have to do this for each of your 100 files.

If you want to automate it, create a column with the directory path name, a 2nd column with the full file names, a 3rd column where you concatenate the two previous columns to create the full path, and then use the hyperlink command to provide the link:


Folder name Filename Concatenated LINK ../excel/ file1.pdf ../excel/file1.pdf file1.pdf ../excel/ file2.pdf ../excel/file2.pdf file2.pdf ../excel/ file3.pdf ../excel/file3.pdf file3.pdf

Here are the formulas behind this:
A B C D Folder name Filename Concatenated LINK ../excel/ file1.pdf =CONCATENATE(A2,B2) =HYPERLINK((C2),B2)
../excel/ file2.pdf =CONCATENATE(A3,B3) =HYPERLINK((C3),B3)
../excel/ file3.pdf =CONCATENATE(A4,B4) =HYPERLINK((C4),B4)
This should work like a charm and the other advantage is that excel won't rename your path locally depending on weather a file is open or not).

you need microsoft office installed in your unit to open the file. xls is an excel format file. you could also try to download and install openoffice 3.02 on your computer to be able to open xls files.

try this website to download openoffice for free
http://download.openoffice.org/

Book1.xls Do you mean that you can't find the worksheet you have establish and you haven't rename the file? The worksheet will be OK if it had been saved.

You need to purchase Microsoft Office to open Excel files.
There is a freeware program that is compatible with Microsoft Office.
Open Office can open and save Microsoft office programs. To download Open Office, please click on this link :-
http://www.openoffice.org/

Hi enelrah_mel0,

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

1. Please Open Microsoft Excel. Then press Alt + F11 to open the Visual Basic Editor.
2. Then, click "Insert" option above the Visual Basic Editor window and select "Module".
3. Then, in the Book1 Module1 (Code) window, paste the below code there. (pasted in the next post separately for your convenience)
   
4. Then, press Alt+Q to close the Visual Basic Editor window.
5. After that, please type the formula " =SpellNumber( * )" in the Excel Sheet and press the Enter Key.
6. Then, save the Excel Sheet.
   

eg: =SpellNumber(A1)

Where A1 is the first cell in the excel sheet.


Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.

save it with a new name...

The two of you may be running different versions of Microsoft Word,
with you having created some documents in a "newer" version than she is using.

The solution: open each document, and click "File" and then "Save As".
Under the "file name" input-area, there is a "save as type" pull-down.
Choose "rich text format". Save the file.

The "RTF" ("rich text format") was designed to be _highly_ portable,
without losing the text-formatting that you have done,
and she should have no problems with reading RTF files into Word.

Go to "FILE", "Save As" and then change "Save As type to XLS" That should hold that setting afterwards from now on.

<img src="http://i.i.com.com/cnwk.1d/i/tr/downloads/images/10_things_office2007_compatibility/10_things_office2007_compatibility_a.jpg">

If you have any more questions please feel free to email me and don't forget to rate.

:)

Thanks!

try this one

Go to start menu, run, then type 'excel' and hit enter, the installation menu will start but you can just cancel it. To me, the installation will start again and again but I cancel it as Book 1 excel already opens. Then you can double-click any excel file that you want and open it. It worked for me! :)