Export data from Excel Tab to Google sheet|VBA & Macros|Excel Forum|My Online Training Hub

Hi There,

Wondering if there is a VBA code to export data from 1 Excel Tab to a Google sheet tab.

I have a code to export data from a tab to save it a "new" file in xlsx

CurrentFile = ThisWorkbook.FullName

NewFileType = "Excel Files 2007 (*.xlsx), *.xlsx," & _
"All files (*.*), *.*"

NewFile = Application.GetSaveAsFilename( _
InitialFileName:=NewFileName, _
FileFilter:=NewFileType)

If NewFile <> "" And NewFile <> "False" Then
ActiveWorkbook.SaveAs FileName:=NewFile, _
FileFormat:=51, _
Password:="Online", _
WriteResPassword:="", _
ReadOnlyRecommended:=False, _
CreateBackup:=False

But looking at exporting data from 1 tab in excel to google sheet tab

Thanks

Steve