DaveBlakeMAAT
Board Regular
- Joined
- Feb 28, 2016
- Messages
- 190
Hi
This is a bit complicated to explain but I shall try!!!
I receive a price list from a supplier, which contains PartCode,Description and price, it also includes an embedded picture shape of the product (which has generic names e.g. picture069) and a hyperlink embedded in another shape with a URL to an online data sheet.
The shapes are floating rather then locked to cells.
What I want to do is be able to create an image file for each product which is named with the product code which is in the adjoining cell. I would also like to extract the embedded URL for the online data sheet.
My thought process is the following:
1) loop through all shapes and lock to their current cell that they are floating over.
2) loop through all shapes in column A (ProductImages) and export to image file named as the value adj in
column B
3) loop through all shapes in column D (Online DataSheets) and extract the URL.
This workbook has 1200 spread across about 50 sheets, and I currently have a macro that unifies PartCode, Description & price to one sheet through an array, but I haven't worked with shapes before so any pointers would be gratefully appreciated.
Regards
Dave
This is a bit complicated to explain but I shall try!!!
I receive a price list from a supplier, which contains PartCode,Description and price, it also includes an embedded picture shape of the product (which has generic names e.g. picture069) and a hyperlink embedded in another shape with a URL to an online data sheet.
The shapes are floating rather then locked to cells.
What I want to do is be able to create an image file for each product which is named with the product code which is in the adjoining cell. I would also like to extract the embedded URL for the online data sheet.
My thought process is the following:
1) loop through all shapes and lock to their current cell that they are floating over.
2) loop through all shapes in column A (ProductImages) and export to image file named as the value adj in
column B
3) loop through all shapes in column D (Online DataSheets) and extract the URL.
This workbook has 1200 spread across about 50 sheets, and I currently have a macro that unifies PartCode, Description & price to one sheet through an array, but I haven't worked with shapes before so any pointers would be gratefully appreciated.
Regards
Dave
