Copying from Excel - pasting in Publisher

To all,

Hoping someone can help me.

I have a series of spreadsheets in excel that I use for calculations. Once I impute my data and have the formulae calculate my data, I copy these spreadsheets into MS Publisher, format them and make my reports. This has never caused me a problem until now.

Today I was working along as usual but when I pasted one of my spreadsheets into Publisher, one particular cell (appearing about 30 times in one spreadsheet) had changed sizes. I checked the size of the cells (column) and verified that nothing had changed, I checked all the formatting and all was good, I checked my settings in Publisher and nothing out of the ordinary.

Then I tried to paste more sections of the same spreadsheet (Actually 1 spreadsheet with different calculation tables down through the worksheet). And some of the pastes pasted fine while others within the same sheet didn't (larger sized cell). I pasted to the same Publisher file as I always have and some sections of the worksheet pasted like always while others had the larger cells (on the same Publisher file).

I tend to think that it is a problem with the clipboard. Has anyone else ever run into this, and can anyone advise.

Thank you very much in advance,

Vaughan Martin


To all,

Hoping someone can help me.

I have a series of spreadsheets in excel that I use for calculations.
Once I impute my data and have the formulae calculate my data, I copy
these spreadsheets into MS Publisher, format them and make my reports.
This has never caused me a problem until now.

Today I was working along as usual but when I pasted one of my
spreadsheets into Publisher, one particular cell (appearing about 30
times in one spreadsheet) had changed sizes. I checked the size of the
cells (column) and verified that nothing had changed, I checked all the
formatting and all was good, I checked my settings in Publisher and
nothing out of the ordinary.

Then I tried to paste more sections of the same spreadsheet (Actually 1
spreadsheet with different calculation tables down through the
worksheet). And some of the pastes pasted fine while others within the
same sheet didn't (larger sized cell). I pasted to the same Publisher
file as I always have and some sections of the worksheet pasted like
always while others had the larger cells (on the same Publisher file).

I tend to think that it is a problem with the clipboard. Has anyone
else ever run into this, and can anyone advise.

Thank you very much in advance,

Vaughan Martin

--
vman252
------------------------------------------------------------------------
vman252's Profile: http://www.excelforum.com/member.php...o&userid=17612
View this thread: http://www.excelforum.com/showthread...hreadid=524109

What i'm trying to do is create a Macro in Excel that will copy UPS tracking
numbers and paste them into the fields provided on the UPS tracking webpage.

Is it even possible to have a Macro that copies from Excel & then pastes
into a webpage?

Thanks ahead of time for any info,

--
Eric

What i'm trying to do is create a Macro in Excel that will copy UPS tracking
numbers and paste them into the fields provided on the UPS tracking webpage.

Is it even possible to have a Macro that copies from Excel & then pastes
into a webpage?

Thanks ahead of time for any info,

--
Eric

Hi,

Can someone please help me with a macro. It is driving me crazy.

Thank you very much

I would like the macro to copy data from excel, open outlook message, paste the data as text and send message to me:

Copy cells B1:C20. Open Outlook. Open New Mail Message. Carriage Return x 2.

Edit, Paste Special, Text, OK. (Copied excel data is pasted into Outlook as text)

In Subject Box Type "Approval Form –" then copy and paste tewxt from message into Subject box: Business Centre Collingwood so that subject box reads: "Approval Form – Business Centre Collingwood"

Then enter email address into To: "fakeblahblah@hotmail.com"

Thank you very much

Example of text to be copied from excel and pasted as text into Outlook:

State VIC
Business Centre Collingwood
District fdsgfdxhg
State Manager sxhh

1 Is the cost of the property spend above $5,000?
Yes

2 Has the State Manager sighted this property spend request?
0

3 Have you obtained a quote for the property spend?
0

4 What is the approximate cost of the property spend?
$20,000.00

I have an excel file. I want to copy data from this excel file into a
ppt file. But this ppt file has a table on it's slide. I want to copy
from excel to a specific cell in the ppt's table.

I just know that you can paste in a Shape in ppt but how can I paste in
a specific cell in ppt?

thanks
Sadia

Hi,

I have some data in a particular format in notepad (Source code of a webpage) which when I copy into excel does not come up the way it should. It might look the same, but when I copy from excel back into notepad it gives double quotes where it shouldnt.
However when I do it by using word as a translator then it does it perfect. i.e. when I copy notepad file into word then copy the word file into excel, the result is as desired.

Is there any macro that would do this automatically. I will just have to select the notepad file and the data will be pasted into excel in the same format. The macro would simply copy the data into word first and then the word data will be copied into excel. If you know of codes that does the conversion please share.

Or also, if there is some way to import the notepad data into excel by keeping the formatting intact would be great. You might not see the harm in formatting in excel but when you re-copy the excel data into notepad, it gives all the unnecessary double quotes.

Thanks,
Vaibhav

Hope someone can suggest something...

My aim: I want to copy sections of a worksheet across to Word, then paste the columns but not as an Excel Object or as cells, but as a Word Table, then change the page layout within Word to landscape.

The set up of the spreadsheet is as follows: Column B has the sections headers such as "A", "B", "C" through to "M". When you reach a section heading I want to copy from the row above that heading across to column U and down as far as the next section heading ("B") for example. The actual headings for each of the columns is given on row 3 and these must also be copied for each section and pasted on each new page within Word.

Once copied, I want to open a document called Template Report.doc which is on my desktop, create a new page at the end of the document and then paste the section copied from Excel into a Word table format, then for the page to be placed in landscape view.

The spreadsheet is attached.

Any help will save me a lot of copying and pasting.

MZP

Greetings all!

I am running Excel 2000 on a Windows XP Pro machine. I have two
workbooks. Each row in either workbook is a description of a document
with a date by which a review of that document is due (among other
things) and, in workbook1, a date by which the final review of the
document is due. This date is in the last cell of the row, and is
calculated using a formula.

If the document is *not* reviewed by the final review date, the row with
the document's entry is cut from workbook1 and pasted into workbook2.
The only difference between the two workbooks is that the last cell in
the row from workbook1 doesn't appear in workbook2.

The employee, who shall remain nameless, who cuts and pastes has, in the
past, selected cells in the row up to, but not including, the last cell
in workbook1 before pasting the data into workbook2. Then the employee
deletes the contents of the last cell that was left behind, and deletes
the empty row. What we have discovered is that Excel is creating an
automatic link between workbook1 and workbook2 when we go through this
process. We don't want that.

Is the best answer the obvious one, which I think is select the entire
row in workbook1, cut, and paste in workbook2, and ignore the last cell?
Or is it simply a matter of copying from workbook1, pasting in
workbook2, and *then* deleting the row in workbook1? Are there other
options? Is Excel *supposed* to be creating this link automatically? Can
I turn off automatic link generation?

Thanks,

Mike Bro.

I have a range of cells that I'm trying to copy from Excel and bring into Word. The range in Excel contains a few text boxes as well as an image, and when I paste the range into Word, everything is jumbled and ugly. Is there a way to get around this?

Thanks.

Hi friends,

I have a unique question about copying from excel and pasting to SAP (frontend)

need your help on this.

I have four data columns mentioned below, the data will be almost around 2000 to 3000.

what i will do is after opening SAP session, i will manually copy each cell (i.e, copying item number,refer #, then CC number and Year)and paste the same in SAP, and given enter,
the SAP will give some more data relating to that item, then i will again click on OK button,
then the proceedure Continues. for next row.

(ie., after 202, 205,...etc)

Item ID Reference CC No. Year
202 3425653 1532 2009
205 3425652 1532 2009
305 3425651 1444 2010
305 3425655 1021 2010

Can i get a VBA code, which i can use for copy/cut paste from the excel and paste the same in SAP.

It will be really really helpfull.

Thanks in advance.

Baig.

How do I create a Macro to copy from Excel and paste into a form on IE or Firefox? Is this possible? I would be most grateful for any help or advice.

Best Regards

Hello
I am writing VBA code for a macro which can evaluate cells in the selected range, row by row. If the cell is not blank, the cell is copied.
For destination, the cell immediately to the right of the specific cell in another sheet is checked. If the cell is blank, the value of the copied cell is pasted in.
If the destination cell is not blank, the cells below it are checked, until there is a blank. A row is inserted immediately above this blank and the value (not the formula) of the copied cell is pasted in.
The effect would be that all values in the selected range, row by row, are copied down into the nice column immediately to the right of a specific cell in another sheet. The new cells cannot overwrite or skip cells already living in that column.
I have managed to get parts of this working, but it just won't come together.
Can this be done at all?

Many thanks in advance for your time and expertise.
Best regards,
Larisa

I am trying out the 2007 Excel, and want to copy from Excel to a database file, but when I paste it, it just says "picture..."

I could do this easily with my old Excel. I tried looking through the different options of copying but haven't found an answer.

Why can't I just copy data and paste it elsewhere???

Hello,

In the attached i have 2 sheets in sheet bf is how the data is and in sheet af is how the data has to look.

I am looking for a code to copy/cut and paste in the same sheet.

Instance 1
Copy I2:U2 and paste it at I9:U9 and delete I2:U2 or cut instead of copy
same way I3:U4 and paste I11:U12 and delete I3:U4 or cut instead of copy
Copy I7:U7 and paste I13:U13 and delete I7:U7 or cut instead of copy

the blank row between the 2 instances can variate from 1 row to 4-5 rows also
the headers in column H are constant for each instance.

Can any 1 help me as i have multiple sheets running down till row 2500+

Thanks,

Satyam

#ref in a linked cell (with formula in it), when i copy/cut and past in original cell

i have an order entry sheet that feeds a invoice sheet...

the invoice sheet has formulas that refer to the order entry sheets data (e.g., quantity)

when i move data around (cut/copy and paste) as i change/modify the order, my formulas in the invoice sheet turn to #ref...

?what can i do to stop the #ref...?

thank you.

Need VB code to check if value from Excel exists in Access before importing vaule to Access.
I have data from Excel bing imported into Access from Excel.
Before the data is to be imported into Access I need a safeguard in place.
This would check to see if the data from the excel file(book1) in worksheet (sheet1) exists in the access file (db1) and table (table_1).
What it also needs to do is look for a line match
So what I mean is I need it to look for a row match not just to see if 1 item matches
example does row#16 in the excel file (556, 125, 8) match any rows in access (table_1) (556, 125, 8) in that combination match?
I have attached the files to make things easier

Hi

I am using Excel 2003

I would like to use macro to do the following.

I have a few Excel files in a folder and I would like to copy the same range
from each file, and paste it in a specific workbook/template.

Please help.

i have encounter this problem in excel tables even though they are not very
big tables, somehow when I copy from excel (using shift key "copy picture" or
normal copy & paste special) part of the columns never appear in in
powerpoint... y is that so?

Hi guys!

Newbie here and don't have a programming background but i'm lucky to understand some basic excel macro or vba by looking at examples.

1. I wanted to write or to have a vba or macro to copy tables/pages from a specific HTML (i'm using win XP & IE) automatically. Please take into consideration that I have many open application running or in standby, let us say, i have 5 open web pages, 2 excel spreadsheet, windows explorer.

2. If I manually selected datas from one of the open IE and press CTRL+C or copy, can I paste it to excel using a macro?
- anyone knows the location where XP temporarily save the data when I press CTRL+C on the IE?
- what's the basic code to change to another application & activate it?

Thank you in advance for your assistance and I look forward for your valuable inputs.

regards,
StreetTrader_13

Hello
I'm using the macro below, but I can't get it working the way I
like it. (A macro I found on the net) The first problem happens while
paste in the name bookmark, there it paste the Excel cell with text and
not only the text. Why?
And why do I sometimes have to start the macro 2 times before the word
file will open?

Sub TilMerke()
Dim appWrd As Object
Dim objDoc As Object
Dim FilePath As String
Dim FileName As String
Dim LastRow As Long
Dim Prompt As String
Dim Title As String
'Turn some stuff off while the macro is running
Application.ScreenUpdating = False
Application.EnableEvents = False
Application.DisplayAlerts = False
'Assign the Word file path and name to variables
FilePath = ThisWorkbook.Path
FileName = "WorkWithExcel.doc"
'Determine the last row of data for our loop
LastRow = Sheets("Sykemeldinger").Range("A65536").End(xlUp).Row
'Copy the data from Thisworkbook
ThisWorkbook.Sheets("Sykemeldinger").Range("aa17").Copy
'Create an instance of Word for us to use
Set appWrd = CreateObject("Word.Application")
'Open our specified Word file, On Error is used in case the file
is not there
On Error Resume Next
Set objDoc = appWrd.Documents.Open("C:testsoknad2.doc")
On Error GoTo 0
'Tell Word to goto the bookmark assigned to the variable
BookMarkRange
appWrd.Selection.Goto What:=wdGoToBookmark, Name:="kommune"
'Paste into Word
appWrd.Selection.Paste
'Copy the data from Thisworkbook
ThisWorkbook.Sheets("Sykemeldinger").Range("t17").Copy
'Tell Word to goto the bookmark assigned to the variable
BookMarkRange
appWrd.Selection.Goto What:=wdGoToBookmark, Name:="navn"
'Paste into Word
appWrd.Selection.Paste
'Copy the data from Thisworkbook
ThisWorkbook.Sheets("Sykemeldinger").Range("w17").Copy
'Tell Word to goto the bookmark assigned to the variable
BookMarkRange
appWrd.Selection.Goto What:=wdGoToBookmark, Name:="Fnummer"
'Paste into Word
appWrd.Selection.Paste
'Make our Word session visible
appWrd.Visible = True
'Clean up
Set appWrd = Nothing
Set objDoc = Nothing
End Sub

i have encounter this problem in excel tables even though they are not very
big tables, somehow when I copy from excel (using shift key "copy picture" or
normal copy & paste special) part of the columns never appear in in
powerpoint... y is that so?

Hi,

I've searched the threads for some code that would allow me to address my needs, but have had mixed success.

Goal: I've got a data set that's copied into Excel for which I need to do some basic formatting, text to columns work, then have a loop run to copy from one row, paste to a column, and delete the empty row.

For example the data is first pasted into Excel as:
First Name: [firstname1]
Last Name: [lastname1]

First Name: [firstname2]
Last Name: [lastname2]

First Name: [firstname3]
Last Name: [lastname3]

First Name: [firstname4]
Last Name: [lastname4]

And I want it to look like:
First Name Last Name
[firstname1] [lastname1]
[firstname2] [lastname2]
[firstname3] [lastname3]
[firstname4] [lastname4]

I'm new to Macros and so I was able to record a Macro to properly handle text to columns, removal of the unnecessary column resulting from text to columns, inserting a row with appropriate headings, and resizing the columns. In the following code, I relayed the pattern I was trying to accomplish through all values starting with the first value after "First Name" heading until there was no more data in that column:

	VB:
	
 NameCleanup() 
     '
     ' NameCleanup Macro
     '
     
     '
    Columns("A:A").Select 
    Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ 
    TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ 
    Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _ 
    :=":", FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True 
    Selection.Delete Shift:=xlToLeft 
    Columns("A:A").Select 
    Selection.SpecialCells(xlCellTypeBlanks).Select 
    Selection.EntireRow.Delete 
    Rows("1:1").Select 
    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove 
    Range("A1").Select 
    Selection.Font.Bold = True 
    ActiveCell.FormulaR1C1 = "First Name" 
    Range("B1").Select 
    Selection.Font.Bold = True 
    ActiveCell.FormulaR1C1 = "Last Name" 
    Columns("A:B").Select 
    Selection.ColumnWidth = 38 
     
    Range("A3").Select 
    Selection.Cut 
    Range("B2").Select 
    ActiveSheet.Paste 
    Rows("3:3").Select 
    Selection.Delete Shift:=xlUp 
    Range("A4").Select 
    Selection.Cut 
    Range("B3").Select 
    ActiveSheet.Paste 
    Rows("4:4").Select 
    Selection.Delete Shift:=xlUp 
    Range("A5").Select 
    Selection.Cut 
    Range("B4").Select 
    ActiveSheet.Paste 
    Rows("5:5").Select 
    Selection.Delete Shift:=xlUp 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
As you can see, I separated the formatting code from where the loop code would live in this macro. Any guidance in handling the loop syntax for the copy, paste, delete row experience would be greatly appreciated!

Thanks in advance.

I often copy a (relatively small) worksheet from Excel into Word, usually no more than 12 - 15 columns and 30 - 40 rows. There's plenty of room on the page in Word, but for some reason, there's a point at which the size (number of columns?) causes the last columns on the right to be missing when I paste it into Word. This happens whether I use normal paste, paste special (picture), or even as a worksheet object. This has been bugging me for years, and I used to think it was a memory problem. But now, with Windows XP, a 200GB hard drive and a gig of RAM, I know it ain't a memory problem! (currently using the Office 2000 versions of Word and Excel).

Does anybody know what's causing this and how to fix and/or work around it? Thanks.

Hi,
i need your help people

this is the code:
Sub ControlWord()
Dim appWD As Word.Application
Dim wddoc As Word.Document
Set appWD = CreateObject("Word.Application")
Set wddoc = appWD.Documents.Add

FinalRow = Sheets("Data").Range("A9999").End(xlUp).Row
For i = 2 To FinalRow
Sheets("Data").Range("A" & i).Copy
Destination:=Sheets("Template").Range("C4")
Sheets("Data").Range("B" & i & ":E" & i).Copy
Sheets("Template").Range("C10").PasteSpecial Transpose:=True
Sheets("Template").Range("A1:F15").CopyPicture
appWD.Selection.Paste

Next i
appWD.ActiveDocument.SaveAs Filename:="c:File.doc"
appWD.ActiveDocument.Close
appWD.Quit
End Sub

i copy data from excel to word by certain format,the problem is that
the data in excel devided to groups (from "Data-->Group and Outline" in
the menu).
how can i change this code to copy the data with groups?
And how can i copy the data without table but not as a Picture?

--
wmax77
------------------------------------------------------------------------
wmax77's Profile: http://www.excelforum.com/member.php...o&userid=31355
View this thread: http://www.excelforum.com/showthread...hreadid=511465