This is a part of my excel macro where it opens a text files from mentioned path.I want to pass the directory path where the file is present from a paramter through the execute macro activity.Can you please help the changes i have to do in this macro?
The highlighted part should come through as paramter from Macro Activity.
Hi @kirankumar.mahanthi1 Thanks for your reply my issue here is how to implement that macro code and i tried some methods but it is failing not sure about the syntax to follow.(i had gone through the process already)
Could you share your requirement and what you are trying to achieve with macro code. I suggest we should go for vb code so that we can handle it in invoke code activity and we don’t need to use execute macro. Thanks.