I am searching for code that copy data from google sheet link into Ms Excel with same format.
All the links will be available in column A row wise. If i run the code then code will copy data from google sheet link and will paste into new MS Excel sheet with sheet name.
Please share the code if that is possible via VBA.