I have an access database which exports data out to an excel file. it then formats the excel file and adds in pictures. What I want to do now is add a hyperlink to the picture. I have recorded a macro in excel of me doing this and I am trying to copy it into access but I am getting a message saying "object required". Can anyone help.
Code is:
ActiveSheet.Shapes("Picture 3").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection.ShapeRange.Item(1), Address:="", SubAddress:="Contents!A1"
When I debug it points me to the Hyperlinks line.
Any help would be appreciated.
Code is:
ActiveSheet.Shapes("Picture 3").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection.ShapeRange.Item(1), Address:="", SubAddress:="Contents!A1"
When I debug it points me to the Hyperlinks line.
Any help would be appreciated.
