MI pack including Excel and Word sheets

cornflakegirl

Well-known Member
Joined
Nov 4, 2004
Messages
2,023
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?
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
L

Legacy 98055

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

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,709
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
If you don't need it editable (and I guess if it's for management you may not) then you could use Acrobat?
 

cornflakegirl

Well-known Member
Joined
Nov 4, 2004
Messages
2,023
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,709
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

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

Legend
Joined
Jun 19, 2002
Messages
63,650
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,709
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

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

Well-known Member
Joined
Nov 4, 2004
Messages
2,023
(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 :))
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,709
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
No, I try to divide my time between about 5 forums! :) (not always equally - this is probably one of my 2 most active ones).
 

Watch MrExcel Video

Forum statistics

Threads
1,129,814
Messages
5,638,493
Members
417,029
Latest member
lingx86

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top