PDA

View Full Version : create filenames from the values in a MS Excel spreadsheet



testervb
02-02-2017, 09:44 AM
Hello.

Is there a way to create filenames from the values in a MS Excel spreadsheet?

For example, an Excel spreadsheet contains the values:
A1: trees
A2: grasses
A3: flowers

Would there be a method to automate the creation of files with an extension (such as .jpg) added to the filename:
tree.jpg
grasses.jpg
flowers.jpg

I would add the image to the created file.

Thanks.

Kenneth Hobs
02-02-2017, 02:38 PM
Welcome to the forum!

Creating filenames is easy. What content would be my question.

testervb
02-06-2017, 08:49 AM
Hello. The content would be an image that I would save to the file at a later date.

Kenneth Hobs
02-06-2017, 09:44 AM
Duplicate thread at: http://www.excelforum.com/showthread.php?t=1172356