I have googled opening hyper links from Excel but most of it is either about hyperlinks in general or opening a linked workbook, whereas I want to use this to download new work. I would ideally like to keep the filename by using a wildcard? So something like: The original csv/.xlsx filename is similar:ġ036548025_detailed_sales_report.xls the number always differs (hence the new column above), however the _detailed_sales_report.xls always remains static.
The list is extensive and is updated monthly. The links may popup a login (that's ok, I have the credentials, though if using VBA it would be safer to hard code that in so if I miss a popup it won't stall).
csv/.xlsx files on a secure server which I have to login to), then saveas with a file name generated by a 3rd row of information Column (C) to keep the BatchID intact (as below). I have a table of links, I want to open each link (they are.
