Madmalky1976
New Member
- Joined
- Sep 3, 2014
- Messages
- 14
Hoping someone can help. New to this forum. Sorry for writing all as text but I don't have access to the file at the moment.
I have a workbook with one worksheet that contains a list of output file names in column A, list of the file paths in column B and dynamic hyperlinks in column C where the the names can change and also the number of hyperlinks can change. I want to open each hyperlink (.csv file) and somehow import the data from that file into a new worksheet in the workbook containing the hyperlinks and then close the .csv file.
what I am looking to automate next is that after the data has been imported into the new sheet, the sheet is renamed with the output file name from column A in the link sheet. I also need to know when the opened output file is blank and if it is then this is recorded somewhere, on a results sheet?
this and all it needs to be able to loop through the macro to work through each hyperlink in the list in column C until it hits a cell without a hyperlink.
Any help appreciated.
I have a workbook with one worksheet that contains a list of output file names in column A, list of the file paths in column B and dynamic hyperlinks in column C where the the names can change and also the number of hyperlinks can change. I want to open each hyperlink (.csv file) and somehow import the data from that file into a new worksheet in the workbook containing the hyperlinks and then close the .csv file.
what I am looking to automate next is that after the data has been imported into the new sheet, the sheet is renamed with the output file name from column A in the link sheet. I also need to know when the opened output file is blank and if it is then this is recorded somewhere, on a results sheet?
this and all it needs to be able to loop through the macro to work through each hyperlink in the list in column C until it hits a cell without a hyperlink.
Any help appreciated.
