Curiosity - can TCC be a VBA Add-In?

[Rick Reinckens]

Mainly just curiosity--is there a way to add TCC as a VBA add-in?

I do realize VBA can run external programs and values can be passed back and forth with environment variables.

I would mainly be interested in having Excel or Access interact. It wouldn't involve directly manipulating cells, fields, or records, it would involve a VBA Sub or Function that contains variables interact with TCC and then receive the results, or things like VBA sends a pathname and TCC processes it and does something, then "reports back" (e.g., with a modified path name).

Again, mainly just curiosity.

 

[Joe Caverly]

Take a look at Visual Basic Interface.

Maybe you could adapt this to VBA?

Joe

 

[Rick Reinckens]

That's way beyond my programming ability. I was just wondering if anyone has done it or knows whether or how it could be done. I also don't know how useful it would be.