Forum

Export data from Ex...
 
Notifications
Clear all

Export data from Excel Tab to Google sheet

2 Posts
2 Users
0 Reactions
102 Views
(@stevenbehr1)
Posts: 92
Estimable Member
Topic starter
 

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

 
Posted : 21/01/2022 8:32 pm
(@jstewart)
Posts: 216
Estimable Member
 

I don't think it's possible. They are two very different databases but so I don't think you could write VBA code to control Google Sheets (the pasting of the worksheet). Someone please correct me if I'm wrong.

 
Posted : 22/01/2022 11:37 am
Share: