ESdat Forums
»
Forums
»
ESdat
»
Custom VBA Module
Rank: Newbie
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.
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498 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
|
|
|
|
Rank: Newbie
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 :-)
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Custom VBA Module
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.