How to save the excel file

arjunk3110

New Member
How to save the Attached file name Consultant Tracker with following file name in local driver "FileName&Consultant Names.xlx"
 

Pallavivalunj

New Member
@arjunk3110 Hi,
Use MS-Excel VBO for ur work.
In that use Save as Action for saving the file with the name u want.
1. Create instance
2. Open/Create the workbook
3. Save as action in MS EXCEL VBO give the handle and workbook name and file name as path and name that u wanna use. Eg. "D/RPA/File_Name.xlsx".
4. Close the instance.

U have done with ur work.
 

rajeev2509

New Member
@arjunk3110 Hi,
Use MS-Excel VBO for ur work.
In that use Save as Action for saving the file with the name u want.
1. Create instance
2. Open/Create the workbook
3. Save as action in MS EXCEL VBO give the handle and workbook name and file name as path and name that u wanna use. Eg. "D/RPA/File_Name.xlsx".
4. Close the instance.

U have done with ur work.

You also can keep the instance opened if you wish to deal with another excel in same process / object. This will save up memory n ensure quicker execution....
 
Top