Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Paste in Word

Posted on 2016-08-09
15
Medium Priority
?
88 Views
Last Modified: 2016-08-17
Say, I've tried pasting the attached in word 2013 and experienced an issue where the right margin is cropped and the document spans much more than 2 pages. Please can you assist with how to achieve this.
TelecareSubcription2016-Shiur-On-Sa.xlsx
0
Comment
Question by:shaunwingin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
  • 2
15 Comments
 
LVL 18

Expert Comment

by:xtermie
ID: 41748511
You could try to:
1) Insert this as a spreadsheet document into word
Insert --> Table --> Excel Spreadsheet, then copy paste your excel file in word and manipulate directly in word

2) Save as PDF (if to be used as a paper form - see attachment)

3) Clip an image of the application and paste onto Word (if to be used in paper format and not electronically)

In any case you have many rows and I do not think it would fit in 1 page, unless you made smaller fonts, which may not be readable...2 page form printed front and back would look good
TelecareSubcription2016-Shiur-On-Sa.pdf
0
 
LVL 33

Expert Comment

by:Paul Sauvé
ID: 41749044
The size of your table is too big for a standard letter sized page (or A4 page)

In fact, it requires 2 pages...
Copy-of-TelecareSubcription2016-Shiu.pdf
0
 

Author Comment

by:shaunwingin
ID: 41749272
I need this as a 2 page form but editable in word. Excel is not as user friendly to edit this form.

How can I achieve this?

PS I've tried this but have same issue as described in question:
1) Insert this as a spreadsheet document into word
Insert --> Table --> Excel Spreadsheet, then copy paste your excel file in word and manipulate directly in word
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 33

Expert Comment

by:Paul Sauvé
ID: 41749415
I don't think it is possible without changing the size of the table since it is 9" wide.

Here is the table in docx format, A4 size, landscape orientation (on 4 pages).
TelecareSubcription2016-Shiur-On-Sa.docx
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41750019
Take a look at the attached doc
2 pages, Portrait
Hope this is close to what you want :)
TelecareSubscription_Shiur-FORM.docx
0
 

Author Comment

by:shaunwingin
ID: 41750023
amazing xtermie
How did you achieve this - in broad terms...

PS Is there any way to get the formula to work towards the very bottom of the 2nd page?
Tx
Shaun
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41750037
Glad it looks like what you want :)
FYI, I did it manually as I initially had inserted your spreadsheet as and Excel spreadsheets in Word (as per my suggestion), then manipulated in the spreadsheet, copied it as a Word table and changed size to Arial 9, which made the rows a bit narrower and it fitted in two pages

Sorry I do not understand what you mean when you write Is there any way to get the formula to work towards the very bottom of the 2nd page?
0
 

Author Comment

by:shaunwingin
ID: 41750127
Tx. If you look in the excel sheet page two there are prices and a formula to calculate the subtotal. Its the subtotal formula that needs to work...
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41750135
Let me try to get table functions in Word to do that and get back to you
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41753628
check the attached file
Just note that you need to add a value in all columns you want added, even if that is a zero (0)
TelecareSubscription_Shiur-FORM_v2.docx
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41753939
let us know if that works for you :)
If there are any more calculated fields let me know (didn't spot any other ones though)
0
 

Author Comment

by:shaunwingin
ID: 41756049
tx - is it possible to make the formula update automatically?
0
 
LVL 18

Accepted Solution

by:
xtermie earned 2000 total points
ID: 41757457
Word fields usually do not update automatically, as Word updates them on opening the document.
If you want to update them manually all you have to do is right click on the field and select Update field or select everything on the document and press F9.  Another option would be to add an onOpen and onClose macro to do this or have a macro that will update your fields when you use it (we can assign a button to it on the quick access toolbar or the ribbon for example).  In the attached document copy paste the following macro, save as docm and then the macro that can be assigned to a button (on the quick access toolbar I'd propose).
The macro is as follows:
Sub UpdMyCalcFields()
    ActiveDocument.Fields.Update
End Sub

Open in new window

To add a button that will do this to the quick access toolbar:
1) Right click the quick access toolbar and select More Commands...
2) In the Choose commands from drop down list, select Macros
3) In the macros list, select the UpdMyCalcFields() macro
4) Click Add
5) Click Modify and give it a symbol and a meaningful display name
6) Click OK to exit the modification of the button
7) Click OK to exit the Options window

Please note that since this is a form specific macro and is from your document the button wont work on any other document.

I've also enabled the option to update fields before printing in the attached document.
1) File, Options
2) Display, Printing Options
3) Check Update fields before printing
TelecareSubscription_Shiur-FORM_v3.docx
0
 

Author Comment

by:shaunwingin
ID: 41758551
Tx for the most helpful replies.
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41758986
No prob...glad we could help :)
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

661 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question