Forum Discussion
Kia Boon Goh
Sep 19, 2018Copper Contributor
Activate specific sheet when open excel
Hi all, I would like open a specific worksheet whenever i open my excel irregardless where is my last save. I have performed the following actions: 1) I have written the following in VBA projec...
Lorenzo Kim
Sep 21, 2018Bronze Contributor
the problem is the double quotation mark. I corrected them pls see attached file..
HTH
Michael Pepper
Aug 07, 2021Copper Contributor
What, exactly, is the problem with the double quote?
Thank you.
- JMB17Aug 07, 2021Bronze ContributorThere's more than one double quote character. When you copy/paste code from an external source, sometimes the double quotes are not the exact same double quote that vba recognizes. The character code of the double quote in the OP's project is 147, versus the 34 vba is expecting.
https://www.ascii-code.com/