locked
Is it possible to build such a application using Microsoft Excel or should I stick to googlesheets? RRS feed

  • Question

  • I posted on another MSDN Excel forum, but Yuki Sun told me that you guys know a lot more about the extent of VBA and Microsoft Excel capaiblities, so I should post here instead.

    For a personal project, I am trying to build an application for data collection. This is the idea for the application:


    1.The user enters data into the spreadsheet template using either an android mobile phone or chrome browser
    2. Each week, the user creates a new spreadsheet from the spreadsheet template and uses it for entering the data for that week
    3. The application (google spreadsheet currently) then gathers data from multiple spreadsheets created in google drive and enters it into another spreadsheet similar to a dashboard.

    Since this is a personal project and I don’t have a lot of time to learn a lot different languages, I am trying to figure out whether it is possible to implement this using Microsoft office excel and its online version (excel online). I have implemented a simpler version of this in google spreadsheet, and I think this is possible to do using google spreadsheet.

    However, the sheets have got complex enough that I think I have to start reading up on the google drive API etc.

    At work, I am already learning about VBA and excel. So I am wondering if I can just stick to excel and VBA and accomplish this. I think this would have been definitely possible if I was just entering data using my laptop. However, I am wonder if excel online has the functionality to gather data from multiple “Excel online” spreadsheets in a similar fashion as that of google spreadsheets.

    Thanks for your help

    Jeff

    Thursday, October 27, 2016 1:33 PM

All replies

  • Hi Alpha,

    you can try to use excel online and store your documents on Microsoft OneDrive.

    then you can upload your Excel file template to Microsoft OneDrive and user can create a documents using that templates.

    then you can create a Workbook with VBA code that open that workbooks created by the user with in a week and copy all the data to Dashboard workbook.

    yes, it is possible to fulfil your requirement by using Excel and VBA.

    you can try to start developing it and when you feel that you got stuck somewhere then you can post your issues and question's on this forum. you will get solution by our community members.

    Regards

    Deepak 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, October 28, 2016 4:59 AM
  • Hi Alpha,

    is your issue solved or still you have the issue with the above mentioned question?

    if the suggestion helped you to solve your issue then I suggest you to mark the suggestion as an Answer.

    if your issue is exist then let us know about that so that we can try to give you further suggestion.

    if you find the solution by your self then please share the solution with us so that other community members can know that your issue has been solved now and it can help others in future.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, November 11, 2016 9:46 AM