Will Excel import a spooled file to look the same every month?

T

teamo333

I take a "spooled" file from a DOS based program every month and I need to
open it into an Excel spreadsheet. Do I need to use a Macro or some other
function to make it import information into the same cells (and how would I
go about doing that) since the spooled file does not bring in the information
in the order I need it, or am I just going to have to do the worksheet over
and over. The worksheet is to show our customers in top buying order and
profit margins. We run Office XP.
 
F

Frank Kabel

Hi
this depends on the structure of your imported file. How do you import
it currently (maybe you could record these steps with the macro
recorder)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top