topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Tuesday March 19, 2024, 4:32 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Create a template for converting flat files to Excel or DB  (Read 4793 times)

dementedmuppet

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 26
    • View Profile
    • Donate to Member
Create a template for converting flat files to Excel or DB
« on: January 25, 2008, 01:21 PM »
The obvious:  Working with any Microsoft product SUCKS

... but I have no choice because it is for work and my employer chose MS

The problem:  It is a waste of time to set the column widths every time I have to convert the flat files to Excel since there are 76 columns and the width is the same every time.

Question:  How do I create a template??

The files are .txt
I know the column width
I can manually set the column widths while converting from .txt to .xls
Can't I create a template to do this?

I keep searching Google and Microsoft but not finding any 'useful' answers

Is there a better place to search????  Or does someone actually know how to do this???
Impossible is nothing

David1904

  • Supporting Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 43
    • View Profile
    • Donate to Member
Re: Create a template for converting flat files to Excel or DB
« Reply #1 on: January 25, 2008, 01:59 PM »
Perhaps you could write a macro, or use one of the XL addin packages/utilities or one of the general macro recording utilities available (perhaps Google for "macro excel" or "macro excel utility")
That should give plenty of leads.
I haven't used AHK but lots of folk here have and maybe they can comment on using that.

Cheers,

David

dementedmuppet

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 26
    • View Profile
    • Donate to Member
Re: Create a template for converting flat files to Excel or DB
« Reply #2 on: January 25, 2008, 03:03 PM »
The macro works great & you rock  :-*
Impossible is nothing