With a lot of searching and adding together all kinds of code parts, I've managed to wirte a code that reads a google-doc spreadsheet into access! (9)I haven't done the last bit yet but I'll have the draw come out as a html file saved to my googledrive and then embedded in my googlesite. (8)I had to filter a bit because some guff came with it but I just used the timestamp field, ie if it doesn't have a timestamp then it isn't something I am interested in. Set appexcel = CreateObject("Excel.Application")Ī "C:\Users\base\Google Drive\blahblah\mystuff.xlsx" You might want it to refresh on open but I have a button with the following (7) I needed an "event" to refresh the spreadsheet. (6)Set up the excel spreadsheet as a linked table in my Access database Note:the Gsheet isn't a public document so only I can do this The result was a spreadsheet with a bit of guff around it but with the data I wanted (5)Opened a new excel sheet clicked on and used the above https: (4)The Gsheet with form responses is visible on my C drive, when I click on it my browser opens with (3)The form can be placed in my google site. (1)Set up Google drive so documents had a path in my local computer. I have seen a solution where the info from the form is published, I have one where it is private. Having manipulated information publish the draw etc to the web. Have the information from that sheet available to Access I want potential players to register using google forms.
0 kommentar(er)
