shaikhstonevilla
New Member
- Joined
- Dec 5, 2012
- Messages
- 23
Hi,
I want your help creating a macro.
I have two excel file open on my computer. Say Book1 and Book2 accordingly
I want to perfom the task as under
1) save book2 file as csv at the specific path
2) file name shold be as per Cell no A5 in the book1
3) close the saved csv file without any prompt
If anyone help me, it would be a great.
Regards,
I want your help creating a macro.
I have two excel file open on my computer. Say Book1 and Book2 accordingly
I want to perfom the task as under
1) save book2 file as csv at the specific path
2) file name shold be as per Cell no A5 in the book1
3) close the saved csv file without any prompt
If anyone help me, it would be a great.
Regards,
