I am currently using an Excel workbook I have been working on with VBA I have learned along the way to catalogue the images for products on a web server.
It works by using a static formula + information in the Product ID field to create hyperlinks to each possible image that could exist. Then validates the web link, if it gives a 404 error then the link is deleted in Excel, etc. Lastly it will insert the images of the corresponding link in line with each Product ID in a neatly formatted and styled table.
My problem is now this is seeming to "outgrow" the constraints of Excel. I am looking into seeing if making this into it's own standalone program or something web-based would be considerably quicker and worthwhile.
I don't have any formal knowledge of coding languages, but am willing to learn. Any suggestions on which language would be most beneficial than relying on Excel would be greatly appreciated.
Looking for which languages would be better in terms of pulling web data, like images, and organizing then into table formatting with mouseover functionality as well as possibly zoom and PDF exporting.
This is a work project, for Windows based operating systems. I'm hopefully one of you JSP'ers can point me in the right direction. If you have a suggestion, tell me why so I can gauge my options.
This post was edited by Fire_Deviant on Dec 28 2017 09:20am