Save sheet1 in .csv and sheet2 in .text - vba - excel

Status
Not open for further replies.

STEEL010

Board Regular
Joined
Dec 29, 2017
Messages
74
Hello,

Is there anyone that can tell me how to save sheet1 in .csv and sheet2 in .text file in one go with VBA.

Greetings,
Steel010
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,100,142
Messages
5,472,754
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top