How to save the excel file

#2
@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.
 
#3
@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