@@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
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"
@@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
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
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.
valuable information. Thank you sir
Thanks
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. 👍
Excellent!!!!
Thanks
Excellent! a very good tutorial indeed!!
Thanks Rashid.
Thanks bro
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
Nice
Thanks Om.
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.
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"
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
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.
Hello Sir, is it workable in android mobile?
Hi Auntor, I haven't checked on Android. Any observation from your side ?
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 😊
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.
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
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.