Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Get all Sheet name

0

How to export all sheet names in an open excel file, then return the results to Google Sheet? And vice versa, all sheet name in Google Sheet, export the results to the open excel file. Thank you

Answer
Discuss

Discussion

Minhys

While I couldĀ tell you how to get all sheet names in Excel using VBA (and copy to a cell or the Windows clipboard), I don't know what you mean by "export to GoogleSheets".

Also this isn't a forum for Google Sheets but there is no equivalent of VBA in that app.

I notice however that you have asked questions here in the past and never selected any of the Answers (as the Rules of the Forum request). Why should I answer another question, only to be ignored?
John_Ru (rep: 6102) Sep 22, '21 at 4:18 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login