J
Jayhawks88
I'm in the process of trying to setup a large Excel (using 2003) fil
that
I'm basically going to be using as a database of sorts to then impor
and
merge the data from into a Publisher file.
Thus far I've been able to setup all the actual data sections of Exce
and
import them with no problem.
The issue I'm running into is when it comes to finding an efficient wa
to
insert the file paths for the image files that I'm going to be usin
into
Excel.
The easiest method I've found thus far is to copy and paste the fil
path
for one picture from the folder into a cell and then copy this inf
into
another cell and then change the filename for each picture by hand
For
exampe: change C:/test1.jpg to C:/test2.jpg. (I do plan on re-namin
the
pictures in ascending numerical order so that it makes it a bit easie
for
me).
What I'm hoping for is that someone knows of a way for me to be abl
to
automate this process somehow using Excel as my final list will likely
include over a thousand pictures and I really don't relish the idea o
doing
each of them by hand
that
I'm basically going to be using as a database of sorts to then impor
and
merge the data from into a Publisher file.
Thus far I've been able to setup all the actual data sections of Exce
and
import them with no problem.
The issue I'm running into is when it comes to finding an efficient wa
to
insert the file paths for the image files that I'm going to be usin
into
Excel.
The easiest method I've found thus far is to copy and paste the fil
path
for one picture from the folder into a cell and then copy this inf
into
another cell and then change the filename for each picture by hand
For
exampe: change C:/test1.jpg to C:/test2.jpg. (I do plan on re-namin
the
pictures in ascending numerical order so that it makes it a bit easie
for
me).
What I'm hoping for is that someone knows of a way for me to be abl
to
automate this process somehow using Excel as my final list will likely
include over a thousand pictures and I really don't relish the idea o
doing
each of them by hand