I have no idea where to start with trying to figure this out so ...

I am using the dos copy /b function to append two files together (a
png file and a text file). The text file contains some information
relative to the png file (sort of like metadata I guess).

I need to run a macro that inserts the png file into a worksheet
(which i already can do) that also scans the png file for the appended
data contained in the text file and places it in predetermined cells
on the worksheet.

If someone could please point me in the right direction.

Thanks

Hi
You can't read the info from the text file?
Lot's of items to search through on extracting from a text file and
putting into excel.
regards
Paul

On Mar 18, 8:50*pm, wrote:
I have no idea where to start with trying to figure this out so ...

I am using the dos copy /b function to append two files together (a
png file and a text file). The text file contains some information
relative to the png file (sort of like metadata I guess).

I need to run a macro that inserts the png file into a worksheet
(which i already can do) that also scans the png file for the appended
data contained in the text file and places it in predetermined cells
on the worksheet.

If someone could please point me in the right direction.

Thanks

I only want to keep track of one file and not worry that the 2 files
are always in the correct location. The appended png file will be sent
to others to use.

Everything I found seems to be looking at the file in lines and the
png file does not seem to have any carriage returns like a text file -
maybe i'm not searching on the correct terms.


On Mar 18, 2:58*pm, wrote:
Hi
You can't read the info from the text file?
Lot's of items to search through on extracting from a text file and
putting into excel.
regards
Paul

On Mar 18, 8:50*pm, wrote:



I have no idea where to start with trying to figure this out so ...

I am using the dos copy /b function to append two files together (a
png file and a text file). The text file contains some information
relative to the png file (sort of like metadata I guess).

I need to run a macro that inserts the png file into a worksheet
(which i already can do) that also scans the png file for the appended
data contained in the text file and places it in predetermined cells
on the worksheet.

If someone could please point me in the right direction.

Thanks- Hide quoted text -

- Show quoted text -