MI pack including Excel and Word sheets

[cornflakegirl]

I'm not really sure if this is the right place for this question, so if not, apologies in advance.

My colleagues produce a monthly MI pack which includes Excel spreadsheets they produce, spreadsheets others supply to them, and commentaries in Word. All the disparate sheets makes it hard to get page numbering right. They also want to be able to send the pack out electronically, and lots of individual files obviously isn't ideal for this.

The last time I had to do a similar thing was several years ago, and I used Binder, which wasn't great, but was better than nothing. But it seems to have been discontinued. Has anyone got a neat solution?

 

[Legacy 98055]

I don't know what an MI pack is. Maybe this disqualifies me from answering your question. Please provide more info.

 

[RoryA]

If you don't need it editable (and I guess if it's for management you may not) then you could use Acrobat?

 

[cornflakegirl]

Right Click - MI = management information. The month-end reporting pack.

Rory - nice idea. I've never used Acrobat to produce documents - is it straight-forward? (Btw - I completely love your sig )

 

[RoryA]

Thanks - I'm completely mystified by yours!
It's fairly straightforward though I've only used it occasionally so I can't guarantee how reliable the conversion process may be.

 

[VoG]

I've done something similar recently using Acrobat and it is straightforward if a trifle tedious.

Basically save all your sheets and Word docs as PDF files. Then open the first page in Acrobat and use Document > Insert pages to add each of the other PDFs in sequence. Finally you can use Document > Add Headers & Footers to add page numbers.

That is for Acrobat 6.0 - it is slightly different in other versions.

 

[RoryA]

Using Acrobat 8 you can select the Excel and/or Word documents you want to combine and then it will convert them all for you. Still quite a tedious process though!

 

[cornflakegirl]

(Mine's a West Wing quote. I won't attempt to explain it.)

Well, definitely worth having a play with, I think.

(I've just noticed your post count. Do you actually spend your entire life on here? Not that I'm complaining )

 

[cornflakegirl]

Still quite a tedious process though!

How tedious are we talking? I think the pack is about 20 pages long.

 

[RoryA]

No, I try to divide my time between about 5 forums! (not always equally - this is probably one of my 2 most active ones).