Questions about using the TT Toolbox components

Please post any questions you might have here... Thanks!

Replies to This Discussion

Permalink Reply by Jonatan Schumacher on March 26, 2014 at 8:02pm

I dont think it helps... Which version of Excel do you have installed?

Permalink Reply by Catherine Page Harris on April 1, 2014 at 11:08am

I have 2010.

Permalink Reply by Kris Spohn on March 25, 2014 at 2:46pm

Hi Group,

I am having trouble using the Write Data feature. To write to Google Docs. I have built a test document in GH and so far I cannot get the data to write in a GS. How can I solve this?

Permalink Reply by Kris Spohn on March 25, 2014 at 2:47pm

I have linked the gmail account. inside the @ sign

Permalink Reply by Jonatan Schumacher on April 4, 2014 at 2:43pm

Hi, you need to actually use the 'Credentials' component to connect to your gmail account once.

Permalink Reply by tim sullivan on March 25, 2014 at 5:15pm

Hi Kris.
From my understanding you need Microsoft excel installed. I think the plugin uses it to create and read the files.
Please anyone correct me if
I am wrong

Permalink Reply by Jonatan Schumacher on March 26, 2014 at 8:01pm

Tim, Kris, you don't need Excel installed to write to the Google spreadsheets. But you would need to set the 'run' trigger to true. Otherwise it looks correct - provided that a spreadsheet named 'GH' actually exists in your google drive already.

Permalink Reply by Kris Spohn on March 27, 2014 at 3:50pm

Jonatan, Tim. Thanks for your responses. The run trigger is set to true and on the write data tool. All of the input texts are set to a clean worksheet and spreadsheet w/ the right names.

Is there something I need to do in Google spreadsheets? I cant look at the build code for the Tool any leads there?

Permalink Reply by Jonatan Schumacher on May 6, 2014 at 7:24am

Kris, take a look at the image I posted to reply to you earlier in this threat. You NEED to use the credentials component in this definition in order to establish a connection to your google account, before you can write to it.

Permalink Reply by Chad Carpenter on April 21, 2014 at 12:41pm

Hello,

I'm trying to save data using the WriteXL component and am getting this error. I am using Office 2007, but it seems as though GH is trying to open a newer version of Excel.

Permalink Reply by Ninja on April 29, 2014 at 6:44pm

I used to have the same error until I unblocked the TTtoolbox.dll file. Now the component works with no errors.

Permalink Reply by Matthew Naugle on May 6, 2014 at 6:43am

Hi Chad,

First try what CD2005 said below by Unblocking the .dll's

You can do this by going to where you installed TT Toolbox, and right clicking each of the TT Toolbox files individually and in the properties choose "Unblock". Also make sure that the .dll files are located in the same folder that the TTToolbox.gha file is located.

Let us know if that doesn't fix the issue.