eXcel 2000 export CSV with images
 

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?

eXcel 2000 export CSV with images
 

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?

eXcel 2000 export CSV with images
 

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?

eXcel 2000 export CSV with images
 

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?

eXcel 2000 export CSV with images
 

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?

eXcel 2000 export CSV with images
 

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?