I'm sure some of my coworkers would dispute the ease of working with me, but I take it. :-)
I was able to figure this out and I posted some working code above.
Thanks again for looking.
dashiellx
Last Activity: May 5 '20, 04:04 PM
Joined: Apr 30 '20
Location:
-
Figured it out:
Code:.Range("A" & y).Select ActiveCell.Hyperlinks.Add .Range("a" & y), "", Chr(39) & strSheet & Chr(39) & "!A1", , CStr(rstSummary(0))Leave a comment:
-
Whoops, Run-Time Error '5' is Invalid Procedure Call or Argument. And yep, I did forgot to copy the Dim i/y = integer declarations when getting on the site. Sorry. :)
I don't believe it is the zero length string. As this works in excel:
And the...Code:ActiveSheet.Hyperlinks.Add Anchor:=ActiveSheet.Range("C1"), Address:="", SubAddress:="'Test'!A1", TextToDisplay:= "Test"Leave a comment:
-
Hyperlinks.Add from Access to Excel
Long story short, due to some very specific formatting requirements, I can't just export the data to excel and create a pivot table.
So, I need to create a tab for each category and on the first "summary" sheet have the value in Column A (the category) be a hyperlink that opens goes to Range "A1" on the detail sheet.
For each category, there is a detail sheet with the name of the Workflow State (space...
No activity results to display
Leave a comment: