Skip to content

KC's Blog

  • Home
  • About Me
  • Sitemap

VBA

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

September 4, 2013January 24, 2023 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
  • M365 – How To Stop SPF-Failed Emails From Passing Through
  • How To Manage Edge uBlock Origin Trusted Sites via GPO
  • Retrieving Logon/Logoff Activities from A Remote Domain-Joined Computer
  • Preventing Read Receipts From Sending Out on Microsoft 365
  • Microsoft 365 Restrict Sending Emails to Certain Distribution Groups

KC's Blog

  • Home
  • About Me
  • Sitemap
Powered by WordPress | Theme: Astrid by aThemes.