How to publish 10000 x 4 table?

  • Thread starter Thread starter The Horny Goat
  • Start date Start date
T

The Horny Goat

I have a LONG price list (about 4 columns each and roughly 10000
items) that I am trying to publish 3 or 4 columns per page.

I am using Excel 2003 - is there any way to do this or do I have to
port the whole thing over to Word? (Aaaack!)
 
David McRitchie has some code to do this kind of thing at:
http://www.mvps.org/dmcritchie/excel/snakecol.htm

But just an observation. If this table consists of nothing but text values--and
you don't need to do any calculations, maybe it belongs in MSWord.

MSWord handles inserting and deleting of rows very nicely (when you have those
columns "snaked").
 
If its 4 columns wide and you want to print 4 columns wide then just select
the lot in the page setup set it to print 1 page wide by 999 long and then
print preview. You might want to set rows to repeat at the top in the page
setup options if you want the same headings repeated on every page.
 
If its 4 columns wide and you want to print 4 columns wide then just select
the lot in the page setup set it to print 1 page wide by 999 long and then
print preview. You might want to set rows to repeat at the top in the page
setup options if you want the same headings repeated on every page.
Click to expand...

Sorry - what I meant was that I have 10000 stock items with 4 bits of
info apiece and I want to publish it telephone book style with 4
vertical columns per page.

It's really an MS word function BUT the file came from my supplier in
Excel format and I want to do a minimal amount of changes to it (e.g.
I want to add a column to mark what is regularly stocked items and
what is a special order) and I don't _think_ Word will allow direct
import of such a file...
 
David McRitchie has some code to do this kind of thing at:
http://www.mvps.org/dmcritchie/excel/snakecol.htm

But just an observation. If this table consists of nothing but text values--and
you don't need to do any calculations, maybe it belongs in MSWord.

MSWord handles inserting and deleting of rows very nicely (when you have those
columns "snaked").
Click to expand...

My main problem is that the file came to me in Excel format and trying
to copy and paste the file ended up causing a memory overflow crash
(i.e. Word ended up - Not Responding fairly quickly) and I've been
trying to avoid having to copy and paste the whole file 500 records at
a time. Meanwhile Word Mailmerge doesn't do what I want either.

I've also tried saving to HTML or plain text without a lot of success.

It's the proverbial 3000 lb marshmellow - no single part of it is all
that hard but the sum total is rather intimidating!
 
Per The Horny Goat:
My main problem is that the file came to me in Excel format and trying
to copy and paste the file ended up causing a memory overflow crash
(i.e. Word ended up - Not Responding fairly quickly) and I've been
trying to avoid having to copy and paste the whole file 500 records at
a time. Meanwhile Word Mailmerge doesn't do what I want either.

I've also tried saving to HTML or plain text without a lot of success.

It's the proverbial 3000 lb marshmellow - no single part of it is all
that hard but the sum total is rather intimidating!
Click to expand...

Without thinking through the real-world-end-game need...

I'd create an itty-bitty MS Access application.

In that app, I'd create a link the the Excel spreadsheet.

Then I'd write a little function that instantiated a copy of MS Word, created a
new MS Word doc, then opened up the link to the Excel spreadsheet and looped
though the sheet - creating lines in the MS Word doc as it went.
 
Did you try David McRitchie's macro?
My main problem is that the file came to me in Excel format and trying
to copy and paste the file ended up causing a memory overflow crash
(i.e. Word ended up - Not Responding fairly quickly) and I've been
trying to avoid having to copy and paste the whole file 500 records at
a time. Meanwhile Word Mailmerge doesn't do what I want either.

I've also tried saving to HTML or plain text without a lot of success.

It's the proverbial 3000 lb marshmellow - no single part of it is all
that hard but the sum total is rather intimidating!
Click to expand...
 
Back
Top