Phoenix - Your AI AssistantExcel VBA to check hyperlinks work
- Posted:
- Proposals: 3
- Remote
- #1262882
- Awarded
have already sent a proposal. Description
Experience Level: Entry
Estimated project duration: 1 day or less
General information for the business: Manufacturer
Description of requirements/functionality: Simple macro to check file paths.
I have an excel worksheet of links to files. Each file is repeated 5 times but with a different file extension. Some files are present with correct addresses. I need to cycle through each link (x each file extension) and highlight in red the links which are broken in the appropriate column. I would like the sheet to be flexible so if I added or took away a new file extension in a column it would take that into account.
Sample sheet attached. The macro needs a button to start it off and also an input box to input the folder location on the users drive.
Required today (16:00 BST Friday 26/08 pm) Please only bid if you can make this deadline.
OS requirements: Windows
Extra notes:
Description of requirements/functionality: Simple macro to check file paths.
I have an excel worksheet of links to files. Each file is repeated 5 times but with a different file extension. Some files are present with correct addresses. I need to cycle through each link (x each file extension) and highlight in red the links which are broken in the appropriate column. I would like the sheet to be flexible so if I added or took away a new file extension in a column it would take that into account.
Sample sheet attached. The macro needs a button to start it off and also an input box to input the folder location on the users drive.
Required today (16:00 BST Friday 26/08 pm) Please only bid if you can make this deadline.
OS requirements: Windows
Extra notes:
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.