I need an example of what code string to use to have excel
add page breaks automaticly when the user open a CSV file.

I need the csv file to contain the code string to add page
breaks before it is opened in excel.
i.e.
report of account
3/30/2004

user , acct number , amt
1 , 1 , $1.00
..
..
..

(page break code)
report of account
3/30/2004

user , acct number , amt
..

etc.

TIA

CSV files are plain text.

Can you provide your users a macro that would import the .csv file and then add
the page breaks?

Maybe you could provide some other formatting/subtotals/print setup and really
make it worthwhile.



tim wrote:
>
> I need an example of what code string to use to have excel
> add page breaks automaticly when the user open a CSV file.
>
> I need the csv file to contain the code string to add page
> breaks before it is opened in excel.
> i.e.
> report of account
> 3/30/2004
>
> user , acct number , amt
> 1 , 1 , $1.00
> .
> .
> .
>
> (page break code)
> report of account
> 3/30/2004
>
> user , acct number , amt
> .
>
> etc.
>
> TIA

--

Dave Peterson
(E-Mail Removed)

I wish I could use either of these options.
but I have to code to the worst possible users and it also
hard to tell the managers that they need training without
it coming back on a review.

is there a format that could be use, that would format the
data when loaded?
it needs to do this when the user doubleclicks the file ,
it's the only way that most know how to open these files.

having them open excel or running a macro is not
acceptable to them. ( they get a e-mail with a link to the
file and doubleclick it to open)

>-----Original Message-----
>CSV files are plain text.
>
>Can you provide your users a macro that would import
the .csv file and then add
>the page breaks?
>
>Maybe you could provide some other
formatting/subtotals/print setup and really
>make it worthwhile.
>
>
>
>tim wrote:
>>
>> I need an example of what code string to use to have
excel
>> add page breaks automaticly when the user open a CSV
file.
>>
>> I need the csv file to contain the code string to add
page
>> breaks before it is opened in excel.
>> i.e.
>> report of account
>> 3/30/2004
>>
>> user , acct number , amt
>> 1 , 1 , $1.00
>> .
>> .
>> .
>>
>> (page break code)
>> report of account
>> 3/30/2004
>>
>> user , acct number , amt
>> .
>>
>> etc.
>>
>> TIA
>
>--
>
>Dave Peterson
>(E-Mail Removed)
>.
>

I think anything you embed into a text file will be treated as text by excel.

Any chance you could do the import yourself and have the link point to the .xls
file?

===
I create a few .txt files that I have to share.

I dump the .txt file to the same location and the same name every morning. (A
common network drive.)

I've given them a workbook with a giant button (from the Forms toolbar) on the
single sheet in the workbook.

It says: Click Here to Import Your Data

They click the button and the macro opens that file and formats it the way I
like. And then saves it their harddrive using today's date as part of the
filename.

They have historical data if they need it and if they don't, they can just dump
it later.

When the .txt file changes format, I send out a new importer workbook.



tim wrote:
>
> I wish I could use either of these options.
> but I have to code to the worst possible users and it also
> hard to tell the managers that they need training without
> it coming back on a review.
>
> is there a format that could be use, that would format the
> data when loaded?
> it needs to do this when the user doubleclicks the file ,
> it's the only way that most know how to open these files.
>
> having them open excel or running a macro is not
> acceptable to them. ( they get a e-mail with a link to the
> file and doubleclick it to open)
>
> >-----Original Message-----
> >CSV files are plain text.
> >
> >Can you provide your users a macro that would import
> the .csv file and then add
> >the page breaks?
> >
> >Maybe you could provide some other
> formatting/subtotals/print setup and really
> >make it worthwhile.
> >
> >
> >
> >tim wrote:
> >>
> >> I need an example of what code string to use to have
> excel
> >> add page breaks automaticly when the user open a CSV
> file.
> >>
> >> I need the csv file to contain the code string to add
> page
> >> breaks before it is opened in excel.
> >> i.e.
> >> report of account
> >> 3/30/2004
> >>
> >> user , acct number , amt
> >> 1 , 1 , $1.00
> >> .
> >> .
> >> .
> >>
> >> (page break code)
> >> report of account
> >> 3/30/2004
> >>
> >> user , acct number , amt
> >> .
> >>
> >> etc.
> >>
> >> TIA
> >
> >--
> >
> >Dave Peterson
> >(E-Mail Removed)
> >.
> >

--

Dave Peterson
(E-Mail Removed)