Hi,
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
Alt+H+O+I
Then stop the recording then in visual basic
in module you will get code
then copy this code in text file (notepad)
and save
then in uipath use Invoke VBA
import that text file and use function name which is Macro2 as highlighted
Mintu_Samanta
Raj_esh
dheephiga.am
ashokkarale