I am new in VBA and would look for help for my problem.
I have list of file in range B3:40. In each cells, hyperlink to specific word document (.docx) file in the communal server.
Now, I would like to combine all documents in the hyperlink list in that range to become one new word document that contain all documents in the list using VBA excel.
Below is my code, it return for me "run time error 91".
Thank you in advance for any help
Dim olink as hyperlink
dim olinkrange as range
set olinkrange = sheet1.range.("B3:B40")
set oword = createobject("Word.Application")
for each olink in olinkrange.hyperlinks