Thread: Link specific PDF page in excel

Hello guys,

I'm new to this forum and excel in general,but i really need help with this.
I sorted out about 4000 pages of PDF that contain company standards i summarized them into a table with 550 rows ( each row represents 1 standard ) and now i need to add a column with links.
the hyperlink doesn't let me use the #page=X,only if the pdf is on a site
i solved this by saving the file to the Htm format now the links work but i have to create 549 links (i created 1 for testing ) any ideeas how to do that faster ? like a macro in VBA or something.
I made a macro in vba that works but i have to make a macro for every link and that's 549 macros. Could i make 1 macro that could take a value from a hidden column and use it as the page number ?
Thanks.