I have used this over 24000 times in the past year and a half, each time saving me about 30 minutes of work. LIFE SAVING. I cannot express how heavily I rely on this package.
I've modified the usefulSheetsV4Api module to work with my needs. However, with the recent retiring of Internet Explorer, the sheetsOnceOff function has become an issue.
From what I can understand, this function in a nutshell, compiles a string of text to be used in the Computer\HKEY_CURRENT_USER\SOFTWARE\VB and VBA Program Settings\xLiberation\type_google\scope_sheets registry item, which enables the sending or pulling of data from a specified Google Sheets sheet ID.
I'm wondering if there is a way to modify the cBrowser class to work with whatever the detault browser is rather than exclusively with an InternetExplorer object. At the moment, whenever sheetsOnceOff is ran, it generates a page in Internet Explorer that states This Website Doesn't Work, and redirects to a Microsoft Edge window, which then lets the user login with their google credentials, and click allow for the gsuite project, which then generates a string of text that it directs you to paste into the code.
My guess is that this string of code would be entered into the Navigate Function in the cBrowser class and I see it is used in the string of text for the registry. How would you modify the cBrowser class to work with a different browser, or whatever the system default browser is?
I can provide the actual files I'm using if we can determine a private method to do so, I don't want to put them in here with my token in there. If it's not inappropriate, would you be willing to hop on a zoom call or something to help me look at this?
Thank you for your time, interest, efforts, and the amazing learning opportunities you have afforded me.
Hey Bruce,
in May 2019 I began use of your "Using the Google Sheets V4 API from VBA to integrate Sheets and Excel" via https://ramblings.mcpher.com/integratingappswithotherplatforms/googlesheetsv4apifromvba/
I have used this over 24000 times in the past year and a half, each time saving me about 30 minutes of work. LIFE SAVING. I cannot express how heavily I rely on this package.
I've modified the usefulSheetsV4Api module to work with my needs. However, with the recent retiring of Internet Explorer, the sheetsOnceOff function has become an issue.
From what I can understand, this function in a nutshell, compiles a string of text to be used in the Computer\HKEY_CURRENT_USER\SOFTWARE\VB and VBA Program Settings\xLiberation\type_google\scope_sheets registry item, which enables the sending or pulling of data from a specified Google Sheets sheet ID.
I'm wondering if there is a way to modify the cBrowser class to work with whatever the detault browser is rather than exclusively with an InternetExplorer object. At the moment, whenever sheetsOnceOff is ran, it generates a page in Internet Explorer that states This Website Doesn't Work, and redirects to a Microsoft Edge window, which then lets the user login with their google credentials, and click allow for the gsuite project, which then generates a string of text that it directs you to paste into the code.
My guess is that this string of code would be entered into the Navigate Function in the cBrowser class and I see it is used in the string of text for the registry. How would you modify the cBrowser class to work with a different browser, or whatever the system default browser is?
I can provide the actual files I'm using if we can determine a private method to do so, I don't want to put them in here with my token in there. If it's not inappropriate, would you be willing to hop on a zoom call or something to help me look at this?
Thank you for your time, interest, efforts, and the amazing learning opportunities you have afforded me.