Hello again!
I'm currently trying to hyperlink to specific excel worksheet names that have spaces in them. I can get it the hyperlink working without the spaces i.e:
C:\Users\Desktop\Excel.xlsx#Sheet1!A1. But if there's a space between Sheet and 1, i.e: Sheet 1, I can not longer get the hyperlink to work.
I've tried C:\Users\Desktop\Excel.xlsx![Sheet1]!A1 and C:\Users\Desktop\Excel.xlsx#'Sheet 1'!A1 but they both produce errors.
Thanks again for your help!
I'm currently trying to hyperlink to specific excel worksheet names that have spaces in them. I can get it the hyperlink working without the spaces i.e:
C:\Users\Desktop\Excel.xlsx#Sheet1!A1. But if there's a space between Sheet and 1, i.e: Sheet 1, I can not longer get the hyperlink to work.
I've tried C:\Users\Desktop\Excel.xlsx![Sheet1]!A1 and C:\Users\Desktop\Excel.xlsx#'Sheet 1'!A1 but they both produce errors.
Thanks again for your help!