[EXCEL] Print as booklet
Solved
adrien67400
Posted messages
5
Status
Membre
-
jeanlouis -
jeanlouis -
Hello,
Having transferred my business documents from PUBLISHER to EXCEL, I would like to know if it is possible to print an EXCEL WORKBOOK (with several tabs) in booklet form. Thank you
Having transferred my business documents from PUBLISHER to EXCEL, I would like to know if it is possible to print an EXCEL WORKBOOK (with several tabs) in booklet form. Thank you
Configuration: Windows XP Firefox 2.0.0.6
6 réponses
??????????
Hello
What are you doing there?
Publisher is meant for DTP: desktop publishing (newspapers, brochures, ...)
Excel is a spreadsheet: it does calculations and charts
Don't mix them up!
That said, it should be possible to insert an Excel workbook into a Publisher file: to be tested (insert/menu/file)
--
(_Usul of Arrakis
Serial_Dreamer_)
Hello
What are you doing there?
Publisher is meant for DTP: desktop publishing (newspapers, brochures, ...)
Excel is a spreadsheet: it does calculations and charts
Don't mix them up!
That said, it should be possible to insert an Excel workbook into a Publisher file: to be tested (insert/menu/file)
--
(_Usul of Arrakis
Serial_Dreamer_)
Hello,
Indeed, I confirm what Usul from Arrakis said: it is possible to insert an Excel file into a Publisher file.
If it's from an existing Excel file, you need to go to "Insert"----->"Object"-----> in the dialog box that opens, select "Create from file" then "Browse" to find the desired file and "Open".
Otherwise, use "Insert"----->"Object"-----> in the dialog box that opens, select "Create New"------> scroll through the list and choose "Microsoft Office Excel Worksheet". An Excel sheet will appear on the composition, and you can create the table you want.
Have a good evening
Indeed, I confirm what Usul from Arrakis said: it is possible to insert an Excel file into a Publisher file.
If it's from an existing Excel file, you need to go to "Insert"----->"Object"-----> in the dialog box that opens, select "Create from file" then "Browse" to find the desired file and "Open".
Otherwise, use "Insert"----->"Object"-----> in the dialog box that opens, select "Create New"------> scroll through the list and choose "Microsoft Office Excel Worksheet". An Excel sheet will appear on the composition, and you can create the table you want.
Have a good evening
Oh yes! I'm innovating....
The advantage of EXCEL over PUBLISHER is already the file size when images are compressed. A catalog of over 40 pages weighs less than 4MB (I was at 72MB on uncompressed PUBLISHER). The other advantage is that a large majority of clients have EXCEL, while they didn't even know PUBLISHER. Therefore, they can open the file on their computers.
The EXCEL file consists of tables with the retail prices of the items, product images, technical descriptions, and a percentage discount system that will directly calculate the net price based on product families.
The goal of switching to EXCEL is to be able to send the catalog by email, and the client can directly enter their discounts into the file and print it themselves. However, in the interest of the company, we also need a paper catalog without discounts for clients who are not price-sensitive.
So, wouldn't there be a macro or anything else to print in booklet format?
The advantage of EXCEL over PUBLISHER is already the file size when images are compressed. A catalog of over 40 pages weighs less than 4MB (I was at 72MB on uncompressed PUBLISHER). The other advantage is that a large majority of clients have EXCEL, while they didn't even know PUBLISHER. Therefore, they can open the file on their computers.
The EXCEL file consists of tables with the retail prices of the items, product images, technical descriptions, and a percentage discount system that will directly calculate the net price based on product families.
The goal of switching to EXCEL is to be able to send the catalog by email, and the client can directly enter their discounts into the file and print it themselves. However, in the interest of the company, we also need a paper catalog without discounts for clients who are not price-sensitive.
So, wouldn't there be a macro or anything else to print in booklet format?
Hi
you have 2 completely distinct objectives (go see a printer with your excel file, you'll see what they think ;-)
-a catalog to send by email: ok for excel but you don't need a "booklet" print format
-a paper catalog: excel is not really made for that, on the other hand publisher or even word YES (and they have the booklet printing function)
and in my opinion you need to create 2 different files, one .xls and one .pub or .doc
or convert your .xls to pdf and then see how your printer can handle the "booklet" print format
--
(_Usul from Arrakis
Serial_Dreamer_)
you have 2 completely distinct objectives (go see a printer with your excel file, you'll see what they think ;-)
-a catalog to send by email: ok for excel but you don't need a "booklet" print format
-a paper catalog: excel is not really made for that, on the other hand publisher or even word YES (and they have the booklet printing function)
and in my opinion you need to create 2 different files, one .xls and one .pub or .doc
or convert your .xls to pdf and then see how your printer can handle the "booklet" print format
--
(_Usul from Arrakis
Serial_Dreamer_)
Hi
To print in "Booklet" format (among other options since there are multiple possibilities), install ClickBook. This creates a "virtual printer" that can be used in any software where there's an "print" option, and you'll be able to print booklets with signatures every X pages if there are too many pages in the booklet.
To print in "Booklet" format (among other options since there are multiple possibilities), install ClickBook. This creates a "virtual printer" that can be used in any software where there's an "print" option, and you'll be able to print booklets with signatures every X pages if there are too many pages in the booklet.
ClickBook didn't convince me. Everything in English, but also a huge number of error messages, I've had enough of it. However, for printing Catalogs, I will use the PDF Creator software which also uses a virtual printer to convert the document to PDF. Much better than going through OPEN OFFICE.ORG because there is no delay, however slight!
It seems that my problem is solved. Thank you for your help, if any of you want to see the final EXCEL file, feel free to ask me.
It seems that my problem is solved. Thank you for your help, if any of you want to see the final EXCEL file, feel free to ask me.