@@SessionsbySaurabh sir aapse sikhkr maine isme aur kuch bhi add kiya hai. Jab hum data add krte hai to sath me excel file ke TABLE RANGE me bhi data add hota hai many time people scared about data loss, thats why i added the thing for data maintain. Bs ab UPDATE AND DELETE function add krna hai so aur bhi acha perform kr sake ye process.
sir I have an excel sheet which import data from another database I want it to automatically get submitted to Google sheet as soon as excel sync with database how can I
To delete a row in a Google Sheet from Excel using VBA, we can use the Google Sheets API. Since Excel VBA doesn’t directly support the Google Sheets API, we usually rely on Google Apps Script as a workaround.
@@SessionsbySaurabh thanks for that. So there is no way to delete rows from BEFORE uploading data from Excel using your code WITHOUT having processes running in two different place?
If your Excel sheet is saved locally on your desktop instead of in a cloud environment like Google Drive or OneDrive, it won’t automatically update in Google Sheets unless you re-upload it each time.
Instead of using User form field name, use Excel Cell reference. Check below. name = Sheets("Sheet1").Range("B2") desig = Sheets("Sheet1").Range("B3") URL_firstpart = "docs.google.com/forms/d/e/1FAIpQLSdI_se_iGLg8ezTVAKt7rqKWDzdJ2Bp0ep7nXgaTbDsLyYRhw/formResponse?ifq" url_secpart = "&entry.1629020134=" & name & "&entry.385413323=" & desig & "&submit=Submit"
What do you think is causing that Excel sends the info to Google Sheets but when I check in Google Sheets all the boxes are blank except for the timestamp box?
I have uploaded another file which checks the Internet Connection first. Download the file from : drive.google.com/file/d/1tTsWJTr8v8kbzT9g_iMPPPW0pERlEYN6/view?usp=sharing
@@SessionsbySaurabh sir now it's working fine due to some mistakes it was not working but i corrected that mistakes after watching video carefully Thanks you again
Sir salute you and i am happy that god gives me a teacher like you..❤
Thanks a lot. Your words made my day.
@@SessionsbySaurabh welcome sir always.🙏
@@SessionsbySaurabh sir aapse sikhkr maine isme aur kuch bhi add kiya hai. Jab hum data add krte hai to sath me excel file ke TABLE RANGE me bhi data add hota hai many time people scared about data loss, thats why i added the thing for data maintain. Bs ab UPDATE AND DELETE function add krna hai so aur bhi acha perform kr sake ye process.
thank you for this valuable information sir... just want to know if this code still working.
Thank you for asking. The issue was in version 2, but I’ve modified the file, and it’s now working perfectly. 👍
valuable information. Thank you sir
Thanks
sir I have an excel sheet which import data from another database I want it to automatically get submitted to Google sheet as soon as excel sync with database how can I
Excellent!!!!
Thanks
Do you know if there a similar was to delete rows of data in the GoogleSheets using VBA code in an Excel workbook?
To delete a row in a Google Sheet from Excel using VBA, we can use the Google Sheets API. Since Excel VBA doesn’t directly support the Google Sheets API, we usually rely on Google Apps Script as a workaround.
@@SessionsbySaurabh thanks for that.
So there is no way to delete rows from BEFORE uploading data from Excel using your code WITHOUT having processes running in two different place?
Excellent! a very good tutorial indeed!!
Thanks Rashid.
Can you refresh google sheet from excel sheet every second automatically ? thanks
If your Excel sheet is saved locally on your desktop instead of in a cloud environment like Google Drive or OneDrive, it won’t automatically update in Google Sheets unless you re-upload it each time.
Hi sir I tried same as you shown but I am getting error in username=.txtusername
It's showing object required
If the Internet gets disconnect while updating n entry will the entry will be updated to Google sheet as soon as the internet is connected
Haven't faced this issue but as per me it would not update.
Thanks, i want you show how edit a single line
Hi Yaw, thanks for your comment. Please elaborate your query.
@@SessionsbySaurabhAfter import from excel, i want stay on excel and Select a row in google sheets and modify from excel
Thanks bro
How to transfer without user form
Is there a way to directly transmit any letter or word that I write in any cell?
Instead of using User form field name, use Excel Cell reference. Check below.
name = Sheets("Sheet1").Range("B2")
desig = Sheets("Sheet1").Range("B3")
URL_firstpart = "docs.google.com/forms/d/e/1FAIpQLSdI_se_iGLg8ezTVAKt7rqKWDzdJ2Bp0ep7nXgaTbDsLyYRhw/formResponse?ifq"
url_secpart = "&entry.1629020134=" & name & "&entry.385413323=" & desig & "&submit=Submit"
Nice
Thanks Om.
sir please how to only sync excel sheet to google sheet
how to transfer data excel to googlesheet not used VBA...??? thanks
We used power query in this video. From excel to Google Sheets we have to use Google API.
What do you think is causing that Excel sends the info to Google Sheets but when I check in Google Sheets all the boxes are blank except for the timestamp box?
Don't worry. I got it. I missed the dots in the "With frmProductSurvey" entries.
Great. Thanks for confirming.
Hello Sir, is it workable in android mobile?
Hi Auntor, I haven't checked on Android. Any observation from your side ?
Sir , without internet the code debug , please solved this . I would be very grateful if you could solve this problem please.
Are you saying the code go into debug mode?
I have uploaded another file which checks the Internet Connection first. Download the file from : drive.google.com/file/d/1tTsWJTr8v8kbzT9g_iMPPPW0pERlEYN6/view?usp=sharing
Now code working but the MSG box check internet connection showing data is not entering please help
Hi Kailash, can you please share the sheet.
@@SessionsbySaurabh sir now it's working fine due to some mistakes it was not working but i corrected that mistakes after watching video carefully
Thanks you again
@@kailashsoni676 great.
@@SessionsbySaurabh 😊
why give me ( CHECK INTERNET CONNECTION ) ? WHAT'S RONG
Need to check the code. Email your sheet if you can.
How to automatically update Google sheet form Excel sheet data
I haven't tried but you can check Google sheets API to update data.