I am trying to save a worksheet into a different workbook as a .csv. When i open this saved file with notepad it looks corrupted (lots of squares and symbols but not my actual worksheet data). However, when I manually copy and paste it into a different workbook and saveas a csv then reopen in notepad everything looks as it should (my data separated by commas). Here is what I have been using.. am I missing something?
myFile1 = Application.GetSaveAsFilename("C:...\", "CSV comma delimited (*.csv), *.xls", , "Select location to save.")
myFile1 = Application.GetSaveAsFilename("C:...\", "CSV comma delimited (*.csv), *.csv", , "Select location to save.")
Bookmarks