![]() ![]() It will open a blank Google sheet in new tab. To do that just right click in Folder and select ‘Google Sheet Database’. ![]() Let us add a new Google Sheet to this folder and give the title as ‘Google Sheet Database’ and rename the ‘Sheet1’ to ‘Data’. To do that just click on + icon available on Top-left side in Google Drive and then click on Folder in available menu and then give the folder name as ‘Google Sheet Folder’ and then click on Create button. Creating a Folder in Google DriveĬreate a new folder. Sign in Google AccountĬlick on Google App icon available on the top-right side in window and select the Google Drive. Creating Google Sheet and Google Form in Google Drive So, let’s move to the next phase of our development. We will complete this coding after creating a Google Sheet and Form in Google Drive. Now, the only one Sub Procedure is pending and that is for Transferring data from Excel to Google Sheet. I = MsgBox("Do you want to reset this form?", vbYesNo + vbQuestion, "Reset") Write the below code in form code window. In this post, we will learn how to Use Google Drive and Google Sheet to transfer data from MS Excel.Īdding code on click event of cmdReset button It’s free of cost and fully secure hence, we don’t need to think about data protections and server maintenance.Īll the features of Google Drive and Google Sheet raise a question in our mind, Can we use Google Drive or Google Sheet as a database? And the answer is Yes, we can. Google Drive, Google Sheet and Google Form provide a dynamic solution to store data in a centralized way without worrying about user platform and location. To handle this scenario, we need a free and secure solutions. Getting a designated shared drive is costly and not possible in small companies or for individuals. In multi-user environment, we need a shared drive where we can keep our database or Excel file to get the user’s input in a centralized way. We always face challenges if multiple users are sitting at different locations and using MS Excel or VBA UserForm to transfer and save the records in a particular database. Most of the time, we use Microsoft Excel to process and store the data.
0 Comments
Leave a Reply. |