Hello, I'm new to VBA and need a solution to this rather sooner than I expect I will be able to learn to code it myself. I hope someone can help in the meantime. I am using Excel 2010, and Windows 2008 Server.
I have a single-sheet spreadsheet with 1000+ records in it, and growing all the time. The spreadsheet is in the same folder in SharePoint as 1000+ PDFs. The spreadsheet acts as an index to the PDFs. The records are numbered sequentially in column A. Each value in column A is a hyperlink to the PDF associated with that record, and opens the PDF when it is clicked on. The hyperlinks have been created by right-clicking on the cell and selecting Hyperlink, and navigating to the appropriate PDF to establish the link. The PDFs are http addressable.
Some of the hyperlinks in column A are broken for one reason or another, and some cells contain a value, but the hyperlink has not yet been defined. I want to insert a new column B, where each cell will contain a custom formula, eg. =CHECKLINK(A1), to determine if the hyperlink in column A is working, broken, or not defined, and display "OK", "BROKEN", or "NONE" in column B. I do not want to open the PDFs, just check the status of the links to them. Then I can filter column B for broken or missing hyperlinks, and take corrective action.
Any help much appreciated.
I have a single-sheet spreadsheet with 1000+ records in it, and growing all the time. The spreadsheet is in the same folder in SharePoint as 1000+ PDFs. The spreadsheet acts as an index to the PDFs. The records are numbered sequentially in column A. Each value in column A is a hyperlink to the PDF associated with that record, and opens the PDF when it is clicked on. The hyperlinks have been created by right-clicking on the cell and selecting Hyperlink, and navigating to the appropriate PDF to establish the link. The PDFs are http addressable.
Some of the hyperlinks in column A are broken for one reason or another, and some cells contain a value, but the hyperlink has not yet been defined. I want to insert a new column B, where each cell will contain a custom formula, eg. =CHECKLINK(A1), to determine if the hyperlink in column A is working, broken, or not defined, and display "OK", "BROKEN", or "NONE" in column B. I do not want to open the PDFs, just check the status of the links to them. Then I can filter column B for broken or missing hyperlinks, and take corrective action.
Any help much appreciated.