Hi I have done a search on Groups and can't find a good answer to my
query.
I have a list of hyperlinks in one workbook that contains hyperlinks
to other workbooks.
I want to loop through each of the hyperlinks, follow the hyperlink,
to open the file, then print the file and close the file, then move
onto the next hyperlink.
Can someone help me with the basis for this code?

I think the problem comes from this line of code
ActiveWorkbook.FollowHyperlink ("MyLink.xls")
From that point, I've lost control over the file so I can't do
something like
Workbook.PrintOut
Workbook.Close SaveChanges:=False
ie the code
dim wb as Workbook
set wb = ActiveWorkbook.FollowHyperlink ("MyLink.xls")
wb.PrintOut
Just doesn't work because the Follow Hyperlink can't be a type of
Workbook...

Can anyone help with this please?