Previous Lecture Complete and continue  

  Activity: Export Data to Text file (Fix Delimiter to Semicolon)

Export Data to a Text File (and set a specific delimiter)

Open Excel File S12_Folders_Files_Start and jump to the Activity Tab.

Export the data on this tab to a text file and save that file in the same directory as the Workbook:

  • Delimiter should be a semicolon ";"
  • File name should be: "ProjectActivity.csv"

Don't forget to save the file as a macro-enabled Workbook.

The final macro is included in the completed version of the Workbook: S12_Folders_Files in Module ProjectActivity.