Discussions

Expand all | Collapse all

pull in data from a QuickBase app into Excel

  • 1.  pull in data from a QuickBase app into Excel

    Posted 05-30-2014 13:47

    How can I write a vba code within an excel spreadsheet to pull in data from a QuickBase app. Goal: e.g. Field 1 into Cell A1, Field 2 into Cell B2.

    Cheers,

    Lukas



  • 2.  RE: pull in data from a QuickBase app into Excel

    Posted 05-30-2014 14:16
    If you used the QuNect ODBC driver, you can custom build reports in Excel that use QuNect to export the data in the format you have built. www.qunect.com (30 day free trial).


  • 3.  RE: pull in data from a QuickBase app into Excel

    Posted 05-30-2014 14:38
    Thank you for your fast answer, Laura. Is there a way without external drivers or plugins?


  • 4.  RE: pull in data from a QuickBase app into Excel

    Posted 05-30-2014 14:41
    I would have to leave the answer to that question to the rest of the expert community....


  • 5.  RE: pull in data from a QuickBase app into Excel

     
    Posted 05-30-2014 21:03
    Lukas, here's a link to an Excel/VBA download tool I created a few years ago. It does have the option to write to an existing Excel file. Link to Google Docs download of QBDownload.zip containing both the Excel file and brief instructions:

    https://drive.google.com/file/d/0B0msP83QbaCdSW4wdFNJY3I1bDA/edit?usp=sharing

    Ken


  • 6.  RE: pull in data from a QuickBase app into Excel

    Posted 07-14-2017 15:53
    I know this is a really old post, but I am trying to use this and it just says "Host Name Unknown" but the quickbase Domain is correct...


  • 7.  RE: pull in data from a QuickBase app into Excel

    Posted 06-01-2014 08:24
    Thank you Ken for your code. I work with mac and therefore excel for mac 2011. Opening your file after enabling macros shows: Compile error in hidden module:QuickBase. Any ideas?
    I suppose your code would be very useful as far as i concern, reading the instruction file.
    Cheers, Lukas


  • 8.  RE: pull in data from a QuickBase app into Excel

    Posted 06-01-2014 15:41
    I really need to get a Mac....Ken.


  • 9.  RE: pull in data from a QuickBase app into Excel

    Posted 10-28-2015 14:52
    Hi Ken. Is there any other way you can share the document, My company's firewalls block Google Docs


  • 10.  RE: pull in data from a QuickBase app into Excel

     
    Posted 10-28-2015 19:31


  • 11.  RE: pull in data from a QuickBase app into Excel

    Posted 07-12-2017 22:53
    Hi Ken.  Great code.  when I try to save to an existing workbook get the message 'Invalid destination Excel workbook name". I used the choose existing workbook button on the QB download tool. 


  • 12.  RE: pull in data from a QuickBase app into Excel

    Posted 07-21-2017 07:36
    How to enable the Existing Workbook option?