I wrote a ms Access VBA code that creates an Excel workbook with multiple sheets and inserts certain data into the respectiive sheets. Along with that I add hyperlinks to allow the user to move from one excel sheet to another. The problem I am having is that I am able to run the vba code one time and everything works great. If I attempt to run it again I get the following message. Regardless if I close out excel or not.
Run-time error '-2147417851 (800010105)'
Method 'Add' of object 'Hyperlins'failed
I can get it to work again if I close excel go into debug mode in access and reset the routine. I can also get it to work continuously if I comment out the hyperlinks in the access vba.