Skip to content

KC's Blog

  • Home
  • About Me
  • Sitemap

VBA

How To Export Excel Spreadsheet To A Fixed-Width Text File

September 4, 2013September 4, 2013 Kent ChenTips & Tricks

The easy way is to Save As to a Formatted Text file (Space Delimited)(*.prn). But you will be struggled to find out that it’s really hard to precisely specify the fixed-width, almost impossible to use to export the data into a perfect space aligned text file. What I am luck to find out is this with VBA. It’s a far […]

Read more

Recent Posts

  • image - How To Print Test Pages on All Printers
    How To Print Test Pages on All Printers
  • Storage splash - SAM-SD
    SAM-SD
  • password login hands concept 700px - Password Manager
    Password Manager
  • mysqlhero - Fixing Unknown Collation utf8mb4_unicode_520_ci
    Fixing Unknown Collation utf8mb4_unicode_520_ci
  • basic dart paper plane - Paper Airplane
    Paper Airplane

KC's Blog

  • Home
  • About Me
  • Sitemap
Powered by WordPress | Theme: Astrid by aThemes.
Advertisment ad adsense adlogger