I have a quiz template that I acquired from a you-tube guy (Randy- Excel for Freelancers) Fantastic work. However I would like to make a couple of small changes to a macro he has set in there. I do not know VBA at all. I can follow along but understanding what to use or when to use it doesn't make any sense to me.
He has this auto create a file which goes through zapier and then creates a google sheet, then takes that sheet sends it to dropbox as a text file. Great.. i think.... The macro opens the dropbox folder and grabs the file (.txt) and as an array loops through and grabs each line and dumps it into the actual excel file...also Great!.... then kills the file....not so great! This means the file is gone so I cannot update a "master quiz log". Simply removing the "kill" option works except If I forgot that I clicked "check for results" button and click it again... well now I have double the info. I need an IF statement in there somewhere that looks at Column B- "Submitted On" and says IF in Column B any thing that matches what you already have Then skip or do nothing, or somthing... I do not know. But it needs to not import matching "submitted on" info. This info is DD/MM/YY HR/MIN time stamp. so simple IF equals "anything" wont work. IT would have to look at the .txt file first row and match or not match Column B.
Clear as Mud??? Hopefully I can attach the actual excel file...or a copy of the macro in a text form.
Thanks in advance for any help on this..
Bookmarks