Prev: Unusual Date Format
Next: alternate row shading kept with autofilter
From: Chris J. Chris on 21 Apr 2010 04:03
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?
From: Dianne on 21 Apr 2010 08:29

Chris J.;704925 Wrote:
>
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?



Chris,

Object is located in the section of insert/text on the ribbon. If it
isn't, go to the office button, excel options, customize, select all
commands, scroll down to the insert object and add it to the second
column.

Dianne


--
Dianne
------------------------------------------------------------------------
Dianne's Profile: http://www.thecodecage.com/forumz/member.php?u=1755
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=197250

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Unusual Date Format
Next: alternate row shading kept with autofilter