Can anyone write a VBA to automatically import data from a local Excel file to Google sheets?

%3CLINGO-SUB%20id%3D%22lingo-sub-1470854%22%20slang%3D%22en-US%22%3ECan%20anyone%20write%20a%20VBA%20to%20automatically%20import%20data%20from%20a%20local%20Excel%20file%20to%20Google%20sheets%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470854%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI've%20found%20a%20half%20done%20code%2C%20I'm%20attaching%20here.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ESee%20if%20you%20can%20get%20an%20idea%20from%20it%20and%20make%20a%20full%20version%20working%20code.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EAlso%2C%20would%20the%20code%20work%20if%20we%20don't%20have%20chrome%20opened%20in%20the%20background%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Ebut%20there's%20an%20active%20internet%20connection%20at%20all%20times.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EData%20is%20being%20added%20to%20a%20local%20excel%20file.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1470854%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1479374%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20anyone%20write%20a%20VBA%20to%20automatically%20import%20data%20from%20a%20local%20Excel%20file%20to%20Google%20sheets%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479374%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20check%20out%20the%20link%20for%20an%20alternative%20method%20to%20get%20your%20Excel%20data%20into%20Google%20Sheets%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fwww.documentsnap.com%2Fconvert-excel-to-google-sheets%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.documentsnap.com%2Fconvert-excel-to-google-sheets%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I've found a half done code, I'm attaching here.
See if you can get an idea from it and make a full version working code.

Also, would the code work if we don't have chrome opened in the background,
but there's an active internet connection at all times.
Data is being added to a local excel file.

1 Reply
Highlighted
Hello,

You can check out the link for an alternative method to get your Excel data into Google Sheets

http://www.documentsnap.com/convert-excel-to-google-sheets/