ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I insert a file into Excel 2007 spreadsheet ? (https://www.excelbanter.com/excel-discussion-misc-queries/262040-how-do-i-insert-file-into-excel-2007-spreadsheet.html)

Chris J.

How do I insert a file into Excel 2007 spreadsheet ?
 
The old Excel command Insert-Object does not exist anymore, instead only these
Insert {Tables | Illustrations | Charts | Links | Text }

I want to insert a general application file, I pretended it is a .Jpg file
by renaming it and attempting Insert - Illustration -From File, but of course
this was rejected.

I also tried using a macro, the essence of which was
Set myPict = .Parent.Pictures.Insert("C:\MyFile.Dat.Jpg")
but this had the same effect.

I finally tried good old drag-and-drop into a cell, but this simply opened
up the binary in a separate Excel window (apparently importing it as CR-LF
delimited rows into the spreadsheet), which means that the file is not
recoverable.


Any ideas?


All times are GMT +1. The time now is 04:05 PM.

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