kweaver
Well-known Member
- Joined
- May 12, 2009
- Messages
- 2,934
- Office Version
- 365
- 2010
I save a sheet via VBA as a CSV file. When I try to open it in Excel, I get a warning message that the format and extension of the file didn't match.
I have the option to open it anyway. But, how do I avoid getting this warning?
The CSV file when open has the correct file name. However, there are two tabs. The first one is the one I want. The 2nd one is labeled "Sheet1".
Should I delete that sheet before saving via VBA?
I have the option to open it anyway. But, how do I avoid getting this warning?
The CSV file when open has the correct file name. However, there are two tabs. The first one is the one I want. The 2nd one is labeled "Sheet1".
Should I delete that sheet before saving via VBA?