It clearly shows that wdPasteMetafilePicture is not.wait for it.not a valid data type. Did you look up PasteandFormat in Help? It would be a good idea. Why are you doing all that Selecting in Excel?Ĥ. "that contains the word file for this project.")ģ. MyFile = InputBox("Please copy and paste the file path " & _ This would be detected if you were using Option Explicit. Also, the syntax for the Inputbox is missing an ending ". It apears you are not using Option Explicit - MyFile is not declared.Ģ. If I use wdPasteMetafilePicture instead of 3 the copy is blurry.ġ. When I do that I get a 5342 error saying data type unavailable.
Type:=3 'This is for wdPasteMetafilePicture Worksheets("UnderstandingChart").Range(rngT4, rngD4).CopyPicture xlScreen, xlBitmap MyFile = InputBox("Please copy and paste the file path that contains the word file for this project.) Set oWord = CreateObject("Word.Application")
I tried the following and it doesn't work
Paste info from excel to word for labels full#
The new document contains a full set of labels based on the first label in your original document. Word creates a new document using the label format you specified in steps 7 and 8.Īt this point you should have two documents-one that is your original (Avery 5162 format) and one that is your new document (Avery 5163 format). Make sure the Full Page of Same Label radio button is selected.Word closes the Label Options dialog box.
In the Product Number list, choose 5163.Using the Label Vendors drop-down list, choose Avery US Letter.Word displays the Label Options dialog box. The Labels tab of the Envelopes and Labels dialog box. Word displays the Labels tab of the Envelopes and Labels dialog box. Click the Labels tool in the Create group.Press Ctrl+c to copy the selection to the Clipboard.Press Ctrl+A to select the entire document.Open the existing document, the one that contains your labels in the Avery 5162 format.If your labels are all the same, then the easiest method of converting to the desired label format is simply to use much of the same process you used to create the labels in the first place. As long as you don't copy the table structure-just the data-you should have no problem. Because you change the table settings to match what is required for the new labels, you should be able to print on them with no problems.Īnother idea is to create a new document consisting of empty Avery 5163 labels and then copy the data from the old Avery 5162 document to the new document. Understanding this, you could easily examine the table settings used in creating Avery 5163 labels and then change the table settings in your old document to match them. It is important, though, to remember that a label document is nothing but a large table that is formatted to match the dimensions of your labels. There are a couple of ways you can approach this problem. She wonders if there is a way to change label size without the requirement of recreating the entire document. The document is intended to be printed using Avery 5162 labels, but Veronica wants to change the document so it uses Avery 5163 labels. Veronica has a document that contains labels, with names already in place.
0 kommentar(er)
