Hallo together,
im totally beginner in VBA. I create a button in my worksheet. Now i would like to write a macro, that after click on this button will upload my worksheet into Google Drive. Can somebody help me please?
Best regards,
Krisiace
Hallo together,
im totally beginner in VBA. I create a button in my worksheet. Now i would like to write a macro, that after click on this button will upload my worksheet into Google Drive. Can somebody help me please?
Best regards,
Krisiace
Look at this link https://stackoverflow.com/questions/...with-excel-vba
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you for your answer.
I have already saw this code and tried to do this in that way, but unfortunately it didn't work.
Maybe someone has other way how to solve this issue.
I would really appreciate any help!!!!!!!
if im correct if the excel file is located inside the google drive(now backup and sync program) folder
or any folder you chose to back-up in the backup and sync program
if you make any changes to the excel file it will automatically sync to your google drive
Thank you for your answer.
im working with Excel 2007 and im not sure if there such folder exist.
But nevertheless i dont want that my file autoticly changes. I need to have upload for every update of the file in google drive.
Any ideas?
the program is now called backup and sync it used to be google drive
if you install it on your windows pc
and then signing in your account
in the preferences/settings of the program
you can choose which folder to continuously sync to your actual google drive
put your excel file in that folder
while inside the folder
if you make any changes/update to that excel file
it will automatically sync to your google drive
in my company i cannot install this program.
I should make one button after click on it the active excel file will be uploaded to google drive. This excel file will be use all my colleagues. I should work with rest api and i have no idea how to code it.
Option Explicit
Public Sub Upload()
'Define http client
'Dim xmlhttp As Object
'Set xmlhttp = CreateObject("MSXML2.serverXMLHTTP")
Dim xmlhttp As New MSXML2.xmlhttp, myurl As String
myurl = "myurl"
'make request
xmlhttp.Open "POST", myurl, False
xmlhttp.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
xmlhttp.send "name =name&email=mail"
MsgBox (xmlhttp.responseText)
End Sub
this is my code and as result when i run this code i become the html code.
can please somebody help me what should i do next????!!!!
does the excel file contains complex data?
if not, why not use "google sheets"
im guessing your pc has internet connection
you can just use your internet browser to use "google sheets"
you can share the file to your colleagues
the file will actually be saved into your google drive
sadly i have no experience in coding
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks