How to specify the worksheet for the new dat file, and a comma in English, at last, by dat file dial
As shown in figure in sheet1 worksheet insert two buttons, button in one of the content of the "output" worksheet data column (5) save as dat file (the pop-up box, prompted for dat file name), button 2 calls file dialog box, select the output dat file, read the content to sheet1. The range (A: "E")
CodePudding user response:
Save as CSV (comma separated) data format:
Activeworkbook. Saveas "c: \ output data. CSV," xlCSV
