If all you really want is "Picture 411" to appear where your picture is
located, then something like this run before you save as CSV might do the
trick:
Sub InsertPictureName()
With Worksheets("Sheet1")
For i = 1 To .Shapes.Count
.Shapes(i).TopLeftCell = .Shapes(i).Name
Next
End With
End Sub
--
Noel
"Jon Peltier" wrote in message
...
It's certainly possible to write a custom VBA procedure for generating
your own files, but you'd have to figure out how to represent the
information, and you'd have to realize that it would no longer be a valid
CSV file.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Earl Kiosterud" wrote in message
...
Oz,
In a word, no. CSV gives data only. No formatting, margins, formulas,
links, etc. If you open a CSV with Notepad, you'll see every character
in the file (except the end-of-line characters). There simply ain't
nothing else.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"SunnyOz" wrote in message
...
Thanks for replying.
Yes, I know CSV is in a text file format, but I was hoping to get just
the
reference name. When I click on the image in excel, the window that
normal
shows what row/cell you are referencing, it displays "Picture 411",
which I
assume is Excel's internal reference for that picture (There is a
different
number for each picture). This is what I would like to get exported to
the
CSV file if possible.
Any suggestions?
"Jon Peltier" wrote:
CSV is a text file format. Comma Separated Values. No images.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"SunnyOz" wrote in message
...
I have an eXcel spreadsheet (2000 ver) that has imbedded images in one
column
of the cells. I want to export the worksheet to a CSV file. (It is
like
a
product catalogue with each row containing an image of the product,
along
with name, description, price, etc)
Everything works fine when I save as CSV for Windows, except the
column
with
the images is empty for all rows. I would like for it to contain the
file
name of the image.
Is there any way to create a CSV file to include the images'
filenames?