Hide columns in excel

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

@T_Y_Raju

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 …

@T_Y_Raju

yes we can…vba will be in that file and we can call

cheers

Hi @T_Y_Raju

Please check this

Regards,

Hi @T_Y_Raju

You can use macro for this. As macro can be used in other files to.

@T_Y_Raju,

  1. Open notepad and put this code as per your need to hide the column.
Range("A:A").EntireColumn.Hidden = TRUE
  1. Save file as yourname.txt
  2. Use Invoke VBA activity to invoke this vba code to hide columns.

Thanks,
Ashok :slight_smile: