Need to change the format of cells in EXCEL plz
Hai @Soudios… Use Change Cell Type Activity that will available in UiPath version 2019.4.0
@Soudios… Feed ur inputs properly ,provide cell range within quotes that u want to change , provide cell format … & Path of the Excel file
i think i have all oh that, but i don’t know what is the sentence to change a cell
I want to extend cell, and change policy and size plz
Did we try with MACROS which can be executed here with Execute Macro or Invoke VBA activity
i don’t know how to set a macro
you can use macros to change the colour and font of the selected Range.
@vishnuvarthanp attaching an example macro which you can take it as reference &selecting the particular range and changing its format and colour.
ok but how macro works ??
Can you show me step by step what i have to do plz ?
With one example if you can plz ?
https://docs.uipath.com/activities/docs/invoke-vba Learn from above I’ve mentioned…
don’t really understand, did a need to open a new excel file and copy the "VBAForDateChangeInSelected.txt"code or what ? can you give me more detail plz ?
that what i did for the moment, i opened the VBA on the file i wanted to modify and copied the code you sent me :
Sry for the inconvenience…@Soudios… this may help u to change size and color…
You don’t need to create a macro buddy
Excel has an option for that
Go to Excel where in View option we can see Macro option and in that we could Record what we want to change which will get converted to a vb script
Hope this would help
Ok i finish recording the macro, but i can’t find it to use invokeVBA
Copy that script and date it in a txt file
Pass that txt file path as input to INVOKE VBA ACTIVITY
it works thant you, but i need to use this macro for every excel file i want, and when i try this it doesnt work for the other excel file
Fine is the cell position changing or any other changes is found between those excel
but how can i do without create a new process for every excel i want to change, can i just select the excel file with a input message or something like that ?
What i want is :
Lanch the process
select the excel file i want the change
Let the robot change the new excel file