Skip to content

KC's Blog

  • Home
  • About Me
  • Sitemap

Excel

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

How to repair a corrupted Excel spreadsheet

March 15, 2012January 24, 2023 Kent ChenTips & Tricks

I store all my documentations in my Dropbox so I can get access to them at anytime from anywhere. But this morning I found that one of the excel sheet I have in the Dropbox corrupted. And because it’s in the Dropbox, the corrupted version was on every single device I have Dropbox installed. Ooops, even on the Dropbox web […]

Read more
  • How To Change the Owner of A User’s OneDrive Data
  • RE4ncJa - Deploying Microsoft Edge Extensions via Group Policy
    Deploying Microsoft Edge Extensions via Group Policy
  • Download Large VMDK Files Faster from VMware Host Faster
  • Email Stopped Working in Spiceworks HelpDesk Server
  • Prepare Windows 10/11 ISO for MDT

KC's Blog

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