Hi In the VBA Scrip the line- intTotalRows = ThisWoekbook.Sheets("data").Cells(Rows.Count, 1).End(xlUp).Row It say run time error 424 object required And after I fixed it (dont know how) it shows me error on my first line strFname
this line of code: intTotalRows = ThisWorkbook.Sheets("Data").Cells(Rows.Count, 2).End(xlUp).Row is causing a run-time erro'9': subscript out of range message. how do I fix this?
I need few help regarding the same , If I have 60 team members and they all work on their own workbook just need to update all the data on the separate workbook just like in this video.
This is the wonderful video thanks a lot for i hope you will link a post for example file , it is the first video in TH-cam which have posted , thanks many many times
@@AutomationMadeEasy hi sir. I watch and learn your video. And I find some different of code with in your blog. Is your video’s right? Or your blog’s right?
Hi, sir I have email my question to you about the “ Automatically Sync Excel With Google Sheets error message”error message. And I also email the Google sheets link and excel file to you. Have you find the problem? Recently I have not run the excel file and google sheets, and I have not receive error message notify email too. Do you have the answher for why show error message ? Thank your help.
Reason for bad request error could be: incorrect url (even a missing ? or spelling error will cause this error) incorrect data or data format incorrect data mapping If above points are correct it must work.
Excel part is unlimited. App script has some per day limitations. Per day maximum execution time is 1 hr which is enough for normal use. For heavy use G-Suite license may be needed.
Thank you for the video Dear, can have the app script code As a reply by this command I had searched your website as you informed in your vedio, couldn't find If you can share here it will be grateful. Rest of the things are working very well
@@AutomationMadeEasy Dear I have been using two months this trigger, so far there is no issue with this , but now there is a problem came up Some entries did not Transferred to The data sheet, as per the failure notification tells "exceeding maximum exicution time limit" Because of data increase It will take time to complete the exicution?
you are correct there are certain time restrictions. One continuous execution must be less than 5 minutes and in 24 hrs max execution time is 60 minutes. To increase quota g suite license is needed
Function DeleteRows (ThisWorkbook.Sheets("Data").Rows (arrRowsToBeDeleted(arrRowNo) & ":" & arrRowsToBeDeleted) This code is not fully understood in your video. Please share the code. Thanks.
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A:O")) Is Nothing Then colNo = Target.Column If colNo 5 And deletedFlag True Then rowNo = Target.Row ThisWorkbook.Sheets("Q1 - 2023").Cells(rowNo, 16) = "" End If End If End Sub Hi Sir, Could you please explain the parameters in this code? Because I'm not able to achieve the auto-delete of SYNCED status while changing the value. ThisWorkbook.Sheets("Q1 - 2023").Cells(rowNo, 16) = "" :- In this line of code 16 is the status column number in my sheet Also, May I know, what is this 5 in this line of code : If colNo 5 And deletedFlag True Then
Thank You @Automation Made Easy
Really helpful tutorial! and thank you for solving the issue for which I tried from morning.
Glad it helped!
You are the real deal! thank you for all your step by step videos!
You are so welcome!
I want to sync over Mon & Wed from my excel doc but when I do it, it doesn’t seem to recognize “&” and only syncs Mon. Can you help me?
can you please share me the link I cant find your blog
Thank you so much mate. This is really brilliant!!!!
Glad it helped!
I'm facing trouble populating the data from google form to the Google Sheet. Any changes to be made in the App script?
Hi - this is excellent, just what I was searching for. Please can you send a link to the Blog of paste the link here. Thanks
When I enter the script into Google Sheet, I get an error message
The data does not appear completely in the data sheet
Just one row
Hi
In the VBA Scrip the line- intTotalRows = ThisWoekbook.Sheets("data").Cells(Rows.Count, 1).End(xlUp).Row
It say run time error 424 object required
And after I fixed it (dont know how) it shows me error on my first line strFname
this line of code: intTotalRows = ThisWorkbook.Sheets("Data").Cells(Rows.Count, 2).End(xlUp).Row is causing a run-time erro'9': subscript out of range message. how do I fix this?
SO SO BRILLIANT..THNAKS THANKS SO MUCH, SIR....BTW ENTERING DATA WHILE OFFLINE, WILL THE DATA BE UPDATED WHEN BACK IN ONLINE LATER.
you shall be online when you are syncing the data
its really helpful thanks for sharing
Thank you so much... appreciated ❤
You're welcome 😊
Is there a way to not synch the entire Excel sheet, but only synch the rows that have a date in Column A
I am getting unauthorized message box instead of ok message box Reference VB for app., ME16.0 Obj. Liab.,Microsoft xml v3.0
I need few help regarding the same ,
If I have 60 team members and they all work on their own workbook just need to update all the data on the separate workbook just like in this video.
for custom requirements, training and consultation write into info@automationandagile.com
@@AutomationMadeEasy So you provided a online classes? if yes then please confirm mode language and fee and structure.
share your email id or write into info@automationandagile.com I will share the details
Hi am getting an error Unauthorized kindly assist
need to see the form
Kindly how can I share the data with you@@AutomationMadeEasy
in the form setting below option turn it off : Restrict to users in ***** and its trusted organizations
Is there a way to synchronize an total excel form instead of a table?
thank you sir for the valuable knowledge. each time when i do it, am getting the message as "bad request".
did u select the correct reference from tool/references
Same issue
@@AutomationMadeEasy yess sir i have selected all the same tools in this video
This is the wonderful video thanks a lot for i hope you will link a post for example file , it is the first video in TH-cam which have posted , thanks many many times
solution is on the blog.
@@AutomationMadeEasy what blog? where?
Been following all the way through Step 6 and learned that this is for Windows, not Mac
Thankyouuuu very much !!!!!!!!!!!!!!!!
Welcome!
only last entry in response sheet is coming can u plz help me in dat at 36:16 what is value of Z1 at line no. 50
Can you write a appscript for to sync a excell sheet with google spreadsheet
sorry sir want to ask why the UniqueID between Excel and Spredsheet is different for the first input
If i have an excel file in my laptop's drive folder how to make sync with google sheets? Kindly help with this query.
The tutorial has detailed steps as to how it can be achieved. If further support is needed write into info@automationandagile.com
Thank you very much for the valuable content. Can I get the example VBA code excel workbook and the script?
refer the blog
@@AutomationMadeEasy Thank you. I refer it. But I couldn't find the excel workbook. Can you put the excel workbook link?
thank you for teach it. that's my want and find.
if have file can learn it that's be better.
thank you again.
Glad it was helpful!
@@AutomationMadeEasy hi sir.
I watch and learn your video. And I find some different of code with in your blog.
Is your video’s right?
Or your blog’s right?
@@AutomationMadeEasy Hi, sir , I still have not success. first step at 15:45 , can't work. can you share your excel file and google sheet ?
@@AutomationMadeEasy HI, sir . I find what's problem of me. it's can work. thank you a lot.
all the best
Thank you for the video
Dear, can have the app script code
As a reply by this command
you can find it on the blog automationandagile.com
Hi, sir
I have email my question to you about the “ Automatically Sync Excel With Google Sheets error message”error message.
And I also email the Google sheets link and excel file to you.
Have you find the problem?
Recently I have not run the excel file and google sheets, and I have not receive error message notify email too.
Do you have the answher for why show error message ?
Thank your help.
Getting unauthorized msg box, instead of OK @ 15.14, selected correct Tools as shown on 11.12
is your form accepting email id's automatically?
buenas noches como puedo consegir este ejemplo
its on the blog automationandagile.com
Cool...
Doesn't work for me, at last I am getting Document sheet
I am getting unauthorized message box instead of ok message box @ 15:14
what all options have you selected under Tools/References
Hi, I am getting Runtime error and the issue stands at http.send the last step, could you please assist
whats the error description?
Did you select correct reference in tools/reference
Sir it shows Bad request
When i execute the module
Reason for bad request error could be:
incorrect url (even a missing ? or spelling error will cause this error)
incorrect data or data format
incorrect data mapping
If above points are correct it must work.
Can I consult with you about my google sheet project. ?
sure write into info@automationandagile.com
Is there a short version
unfortunately no
Hi please send me vba code or linkg to download. Thanks
sir I need you help, I try to do but getting error every time.
how can I help you?
@@AutomationMadeEasy it's not working in my system, I getting a error (Compile error, fix length strings)
@@AutomationMadeEasy I also mailed you with screen shot.
iam getting No found message instead of OK
check tools references if correct reference is selected
Very nice ...Pls share the link
all the steps along with the script is provided on the blog
Blog or code please?
automationandagile
Sir , please send me your blog page link . Please
same here
Is this free and unlimited?
Excel part is unlimited. App script has some per day limitations. Per day maximum execution time is 1 hr which is enough for normal use. For heavy use G-Suite license may be needed.
Where is the code?
on the blog automationandagile
Thank you for the video
Dear, can have the app script code
As a reply by this command
I had searched your website as you informed in your vedio, couldn't find
If you can share here it will be grateful.
Rest of the things are working very well
its on the blog. Its too big to put it on comment. Share ur email id will send.
@@AutomationMadeEasy
Thank, you
Finally got it from your website,
You are doing amazing lessons, keep rocking...
Glad you found it helpful
@@AutomationMadeEasy
Dear
I have been using two months this trigger, so far there is no issue with this , but now there is a problem came up
Some entries did not Transferred to The data sheet,
as per the failure notification tells "exceeding maximum exicution time limit"
Because of data increase
It will take time to complete the exicution?
you are correct there are certain time restrictions. One continuous execution must be less than 5 minutes and in 24 hrs max execution time is 60 minutes. To increase quota g suite license is needed
Function DeleteRows
(ThisWorkbook.Sheets("Data").Rows (arrRowsToBeDeleted(arrRowNo) & ":" & arrRowsToBeDeleted) This code is not fully understood in your video. Please share the code. Thanks.
code is available on the blog automationandagile
@@AutomationMadeEasy thank you sir.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A:O")) Is Nothing Then
colNo = Target.Column
If colNo 5 And deletedFlag True Then
rowNo = Target.Row
ThisWorkbook.Sheets("Q1 - 2023").Cells(rowNo, 16) = ""
End If
End If
End Sub
Hi Sir,
Could you please explain the parameters in this code? Because I'm not able to achieve the auto-delete of SYNCED status while changing the value.
ThisWorkbook.Sheets("Q1 - 2023").Cells(rowNo, 16) = "" :- In this line of code 16 is the status column number in my sheet
Also, May I know, what is this 5 in this line of code : If colNo 5 And deletedFlag True Then
Function DeleteRows
(ThisWorkbook.Sheets("Data").Rows (arrRowsToBeDeleted(arrRowNo) & ":" & arrRowsToBeDeleted)
automationandagile blog how to find ThisWorkbook.Sheets("Data").Rows (arrRowsToBeDeleted(arrRowNo) & ":" & arrRowsToBeDeleted) code