Templates

  • Thread starter Thread starter godfrey f
  • Start date Start date
G

godfrey f

What I need to do is (a) import an Ascii file on a regular basis and (b
apply a pre-saved Template onto the imported data. I've managed t
import the textfile without any problem. However, even though I'v
tried reading about templates, I only got so far as to save th
template but I have no idea how to apply it later on.

Additionally, it would be nice to automatically have the templat
applied to the data coming in via the Ascii file every time I impor
the data since the format will always be exactly the same, the onl
thing that changes is the data.

Is there a way, perhaps, of executing this whenever invoking Excel
such as from the Run command, by providing (a) Excel pathname (b) ASCI
filename (c) template-name to be applied?

Any help regarding this rather urgent problem will be appreciated
Regards and thanks,
Godfre
 
Any help regarding this rather urgent problem will be appreciated.
Click to expand...

For a lot of people, hearing someone else describe their problem as
'urgent' makes them not want to help. If you were paying them, it would be
a different story.

I think you have to use a visual basic macro for this. The macro would
open the template and then read the text file, putting the appropriate data
in the appropriate cells.

Could you give some more information about the details of this template and
what is the format of the data going in?
 
Back
Top