Skip to content

KC's Blog

  • Home
  • About Me
  • Sitemap

Excel

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

How to repair a corrupted Excel spreadsheet

March 15, 2012March 15, 2012 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
  • Checking Why A Remote Computer is Shutdown or Restarted
  • MTRoW NewHome 1024x641 1 - Updating Microsoft Teams Room
    Updating Microsoft Teams Room
  • 74355385 d990 44fe 8a87 6c3639d1f63f - Microsoft 365 - What To Do When the Mailbox is Full
    Microsoft 365 – What To Do When the Mailbox is Full
  • Configuring Azure Active Directory Single Sign-On (SSO) with Azure AD Connect
  • Microsoft 365 Preventing Distribution Group from Receiving Outside Emails

KC's Blog

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