Groups

    Calling an Excel whizzz!

    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!

    7 Comments

    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 #"

    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.

    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.

    Original Poster

    suchafunkymonkey;6300373

    If you're using the image then presumably at that point you know:The … If you're using the image then presumably at that point you know:The image nameThe 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:

    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.

    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)

    fanpages;6306954

    Hi,If exporting to HTML (HyperText Markup Language) does not work for … 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
    Avatar
    @
      Text
      Top Discussions
      1. Easy Jet flights - does anyone know how far in advance seats are sold?57
      2. So Brexit isn't going how a lot of Brexiters thought it would711
      3. Player Unknown's Battlegrounds now avaliable on Steam88
      4. Buying an iPhone second hand11

      See more discussions