Skip to main content
Question

pull in data from a QuickBase app into Excel

  • May 30, 2014
  • 0 replies
  • 156 views

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

This topic has been closed for replies.

Forum|alt.badge.img+12
  • Registered
  • May 30, 2014
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).

  • Author
  • Registered
  • May 30, 2014
Thank you for your fast answer, Laura. Is there a way without external drivers or plugins?

Forum|alt.badge.img+12
  • Registered
  • May 30, 2014
I would have to leave the answer to that question to the rest of the expert community....

  • Registered
  • May 31, 2014
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

  • Author
  • Registered
  • June 1, 2014
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

I really need to get a Mac....Ken.

Hi Ken. Is there any other way you can share the document, My company's firewalls block Google Docs

  • Registered
  • October 28, 2015

  • Registered
  • July 13, 2017
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. 

  • Registered
  • July 21, 2017
How to enable the Existing Workbook option?