Main Area and Open Discussion > General Software Discussion

Create a template for converting flat files to Excel or DB

(1/1)

dementedmuppet:
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???

David1904:
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:
The macro works great & you rock  :-*

Navigation

[0] Message Index