Marco to create .CSV

Copper Contributor

This is one of my first macros so please be nice:).  I have pieced it together through recording and Google searches.  It performs as expected but the program/website used to import the file does not recognize the file type.

If I open the file and select "save" and "yes" to keep using CSV format and then close the file and select "no" to save file, the program/website will import the file.  

 

I think this is the piece that is not saving the file correctly.

clipboard_image_0.png

I appreciate any input.  Thanks.

0 Replies