This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello, I would like to ask if there is any way to run a vba macro(protected by password, because there are the credentials from the database), in this workbook the user must input two dates(from - to). I would like to run this code in alteryx and input these dates in alteryx as well. Really appreciate if anyone can help me on it. Thanks!!
Hi Charlie, thanks for you reply! I'm trying to run the following VBscript, however it is not updating (seems that its not running my macro)... I don't know if I wrote anything wrong or if I'm not able to run since this spreadsheet is protect (I know the name of the macro because I asked the guys from Technology team)... thank you very much! Sub a() dim objExcel set objExcel = CreateObject("Excel.Application") objExcel.Visible = TRUE objExcel.DisplayAlerts = False Path1="(...)spreadsheet.xlsm" objExcel.Workbooks.Open Path1 objExcel.Run("spreadsheet!Macro") objWorkbook.Saved=True objExcel.quit end sub