Need to change the format of cells in EXCEL plz
@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
Hi
Did we try with MACROS which can be executed here with Execute Macro or Invoke VBA activity
@Soudios
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.
VBAForDateChangeInSelected.txt (723 Bytes) @Soudios… U can use these reference for other tasks that u r mentioned…
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 ?
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 :
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
@Soudios
Hope this would help
Cheers
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
Cheers @Soudios
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
Cheers @Soudios
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