Calling an Excel whizzz! - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Calling an Excel whizzz!

£0.00 @
Hoping someone can help with the following query; has got me (and google) stumped. The company I work for has just compiled a proper excel file for our products that we sell. These contain our/sup… Read More
geneticmeddler Avatar
7y, 8m agoPosted 7 years, 8 months ago
Hoping someone can help with the following query; has got me (and google) stumped.

The company I work for has just compiled a proper excel file for our products that we sell.
These contain our/supplier part #s, descriptions, prices, etc.

That's all fine, but we've also added pictures of the items to include on quotes (the pictures are in a column to the right of all the other details).
Our new quoting software tool needs a link to the filename - however, our pictures don't have logical filenames!

Is there a way we can do a batch save as of all these images so it ends up as 'part#'.jpg within folder X?

There are about 3,000 products and will be a bit of zombie work we don't really want to do!
Tags:
geneticmeddler Avatar
7y, 8m agoPosted 7 years, 8 months ago
Options

All Comments

(7) Jump to unreadPost a comment
Comments/page:
#1
Try using flash renamer, it's a free program and you can batch rename anything.

Just go into Numbers then add counter, click advanced mode and change it to Part

I have no idea what order it will put them in though but they should all be renamed to "Part #"
#2
There was a program i used to use that done batch renaming but that was at a windows folder level, not inside Excel. I used it a few times to rename thousands of pic files to to pic0001.jpg, pic0002.jpg, etc etc. If that is what you need ill dig it out, freeware, but if its inside of Excel then i dont know unfortunately.
#3
If you're using the image then presumably at that point you know:
The image name
The part number associated with the image
If you have this then add a new column and substring the text:
"RENAME " image_name.jpg part_number.jpg
copy all of this text, put it in a txt file called rename.bat, place the rename.bat file in the folder with your pictures and run it. It will rename all the images to the corresponding part numbers.
#4
suchafunkymonkey
If you're using the image then presumably at that point you know:
The image name
The part number associated with the image


A little more primative than that :oops:
The images currently only exist in our Excel spreadsheet .. don't ask me why:roll:
#5
If you save the excel spreadsheet as a webpage, it will put all the images in a folder in the order they appear in the spreadsheet.

That'll give you the images outside Excel, which is a start.

This may also help, but it names them according to the order they were inserted into the doc, rather than the order they appear.
#6
Hi,

If exporting to HTML (HyperText Markup Language) does not work for you, I would advise that "you" will be need to iterate (loop) through the Shapes collection (group of objects on the worksheet) & save the images based on the value of the product code in an associated column on the same row.

I'm expecting you may not be experienced in the use of Visual Basic for Applications (in the Microsoft Office suite; primarily MS-Excel).

Which version of MS-Excel is your organisation using, and could you copy the main workbook, remove prices & any other details from the columns that are sensitive to your business, and just provide the images embedded in the workbook with the corresponding product codes on the same row?

If so, can you make this resultant workbook available as a downloadable file for me to view?

(You can keep the location away from everybody here & send me the link by "PM" if you would prefer).

BFN,

fp.
(MS-Excel "Genius" rank at Experts-Exchange.com)
#7
fanpages
Hi,

If exporting to HTML (HyperText Markup Language) does not work for you, I would advise that "you" will be need to iterate (loop) through the Shapes collection (group of objects on the worksheet) & save the images based on the value of the product code in an associated column on the same row.

I'm expecting you may not be experienced in the use of Visual Basic for Applications (in the Microsoft Office suite; primarily MS-Excel).

Which version of MS-Excel is your organisation using, and could you copy the main workbook, remove prices & any other details from the columns that are sensitive to your business, and just provide the images embedded in the workbook with the corresponding product codes on the same row?

If so, can you make this resultant workbook available as a downloadable file for me to view?

(You can keep the location away from everybody here & send me the link by "PM" if you would prefer).

BFN,

fp.
(MS-Excel "Genius" rank at Experts-Exchange.com)



Did I scare you off?

BFN,

fp.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!