hi i want to hide few columns in Excel …i dont want to invoke hers is there any other method to it
Business will send excel file daily to process …inbulit macro will not there in business input file
macro needs not be in file…it can be saved as .vba file and can be called using invoke vba activity on any excel file
cheers
we can write code in text file and call that file …
Hi @T_Y_Raju
You can use macro for this. As macro can be used in other files to.
- Open notepad and put this code as per your need to hide the column.
Range("A:A").EntireColumn.Hidden = TRUE
- Save file as yourname.txt
- Use Invoke VBA activity to invoke this vba code to hide columns.
Thanks,
Ashok