ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I insert a file in to an excel document (https://www.excelbanter.com/excel-discussion-misc-queries/183353-how-do-i-insert-file-excel-document.html)

Mark

How do I insert a file in to an excel document
 
I'm trying to insert an Excel file in to an Excel spread sheet and I know it
can be done, but I seem to be going round in circles. How do I embed / insert
it? Anyone help?

Max

How do I insert a file in to an excel document
 
Tinker with it like this ..
Click Insert Object Create from File
Then click Browse to navigate to folder,
select the excel file Insert
Then Check "Display as icon" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mark" wrote:
I'm trying to insert an Excel file in to an Excel spread sheet and I know it
can be done, but I seem to be going round in circles. How do I embed / insert
it? Anyone help?


Kevin B

How do I insert a file in to an excel document
 
You can also insert a hyperlink to the file if all you want to do is give the
user easy access to the Excel workbook.

Click INSERT on the menu & select HYPERLINK (or press Ctrl+K).

In the dialog box, click EXISTING FILE OR WEB PAGE (the default), browse
until the file is located. Select the file & click OK if you want to link to
the file, or click the BOOKMARK command button in the dialog box and enter a
cell reference in the workbook, a sheet reference or a named range reference.
This opens the file to a specific location in the workbook.

Hope this helps.


--
Kevin Backmann


"Mark" wrote:

I'm trying to insert an Excel file in to an Excel spread sheet and I know it
can be done, but I seem to be going round in circles. How do I embed / insert
it? Anyone help?


Mike Middleton

How do I insert a file in to an excel document
 
Mark -

An Excel workbook file may contain one or more worksheets.

If you want to move or copy a worksheet from one workbook to another, open
both workbooks, right-click the worksheet tab, and choose Move Or Copy ...

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel




"Mark" wrote in message
...
I'm trying to insert an Excel file in to an Excel spread sheet and I know
it
can be done, but I seem to be going round in circles. How do I embed /
insert
it? Anyone help?





All times are GMT +1. The time now is 12:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com