topic Access Macro in Talend Studio

Access Macro

Anonymous — Fri, 09 Feb 2018 16:18:31 GMT

My company has an access Macro that is manually run every week. Part of the process is deleting files and copying files between folders. I would like call this macro from Talend. Could someone please show me how to call an access macro from talend?

Re: Access Macro

vapukov — Sat, 10 Feb 2018 06:47:11 GMT

do You really need this?!

why not re-create this functional with Talend? much more relevant system for this

in worst case - use tSystem component

https://answers.microsoft.com/en-us/office/forum/office_2007-access/running-access-macro-from-batch-file/899d3f77-a450-46f4-b4ef-996cbd4821c8?auth=1

https://social.msdn.microsoft.com/Forums/office/en-US/8cd7fe59-e204-4657-9386-1a5ad3663ca7/batch-file-to-execute-access-a-macro?forum=accessdev

https://stackoverflow.com/questions/15220462/batch-file-to-run-an-ms-access-query-and

Re: Access Macro

aashish_21nov — Wed, 13 Jun 2018 09:49:39 GMT

Hello @Robert_gill

you can call macro from talend by tSystem Component.

In tSystem, we call a batch file and in batch file we can call .vbs (visual basic script).