Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
rsiebenmann  
#1 Posted : Thursday, November 13, 2014 12:36:36 PM(UTC)
rsiebenmann
Rank: Newbie

Reputation:

Groups: Registered
Posts: 2

Is it possible to use custom VBA modules in ESdat?

I've written a set of functions that apply significant digit rules in a custom query, but it doesn't look like it's being recognized by ESdat.

Warwick Wood  
#2 Posted : Thursday, November 13, 2014 4:47:24 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hello,

You can certainly apply custom vba functions to the Chem Table after export.

However, a custom vba module can't be included in the Chemistry Table Template Workbook.  When producing a Chem Table ESdat copies the Template worksheet into another workbook, so any other sheets or vba modules in the Template Workbook are left behind.

However, you can save your custom functions in your own workbook (or Excel Add-In file), and run them against the Chem Table, modules don't need to be run against the same workbook they are saved in.

Warwick 

rsiebenmann  
#3 Posted : Thursday, November 13, 2014 4:52:42 PM(UTC)
rsiebenmann
Rank: Newbie

Reputation:

Groups: Registered
Posts: 2

Thanks Warwick -

That's exactly what I ended up doing.  I was hoping to include the VBA module in Access and perform the computations on the Concentration field of LChem1 so that the raw input data would flow down to the Chem Table export, but it all got formatted at the end instead :-)

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.