Adding VB code to an excel

[Moonscarlet]

Hello,

Is it possible to create a macro and add it to my excel using autoit?

Or executing the whole visual basic function itself from the autoit script?

Thanks in advance.

[water]

Welcome to AutoIt and the forum!

To handle general tasks I suggest to use the Excel UDF that comes with AutoIt.

1. I think this subject has been discussed before. Search the forum for VBE as describd here: https://msdn.microsoft.com/en-us/library/ff840360(v=office.14).aspx
2. Use the Run method to execute a VBA macro. https://msdn.microsoft.com/en-us/library/ff197132(v=office.14).aspx

[Moonscarlet]

On 11/15/2016 at 0:06 AM, water said:

Welcome to AutoIt and the forum!

To handle general tasks I suggest to use the Excel UDF that comes with AutoIt.

1. I think this subject has been discussed before. Search the forum for VBE as describd here: https://msdn.microsoft.com/en-us/library/ff840360(v=office.14).aspx
2. Use the Run method to execute a VBA macro. https://msdn.microsoft.com/en-us/library/ff197132(v=office.14).aspx

Thanks.