Save sheet as CSV while keeping original file open?

Hello,

I have a small workbook with a few sheets where people enter purchase orders, for which I have a userform. Sometimes people will enter 1, sometimes they could enter up to 10 at a time. Everything is working really well, many thanks to my lurking the forum. I have hopefully my final problem before my project is complete. I have two modules, one where it saves a specific sheet as a pdf in a specific location which works great. I also have a module where it saves another sheet as a CSV, which works, just not the way I need it to, and I am not even sure I can get it to work that way.

I have a dependent cell that calls the module with the following code:

Please Login or Register  to view this content.

My problem is that when this module is called, the original file PO.xlsm switches to the new file name in the J drive and is now a csv, making all the vba incompatible. The file is protected so I am not concerned about losing the file, my concern is that if a person has multiple purchase orders to process they have to close the csv file and then reopen the original xlsm file. I would be fine having the csv emailed or saved in the directory, I just hope there is a way to prevent the file switch on the save.

Grant

Please Login or Register  to view this content.