how can i auto fit all the excel columns without using the custom actvities?
select all data and use hotkeys as : alt+h+o+i or same thing using invoke vba by recording select all data and use : alt+h+o+i in macro and use code.
what should i do with invoke VBA?
First in excel → developer tab → Record Macro
in recording mode
select all data then use shortcut keys
Then stop the recording then in visual basic
in module you will get code
then copy this code in text file (notepad)
then in uipath use Invoke VBA
import that text file and use function name which is Macro2 as highlighted