IkEcht
06-12-2007, 03:14 AM
Hi,
this is probably a simple question, but can't find the solution.
In my word document I paste loads of data from several excell worksheets, all with similar code like the one below:
Sub dir3g()
xl.Sheets("(deel)aspecttabellen").Select
xl.Range("b21").Select
xl.Selection.Copy
Selection.PasteSpecial DataType:=wdPasteText
End Sub
Now when I paste this, at most places in my document I get exactly what I want. But some places the field also gets replaced by a space and what I want to get from excell. This space is not in the excell sheet, nor in the sub, nor in the document, as far as I can see.
Anyone else who has this problem or anybody who can tell me where this stems from?
Thanks!
this is probably a simple question, but can't find the solution.
In my word document I paste loads of data from several excell worksheets, all with similar code like the one below:
Sub dir3g()
xl.Sheets("(deel)aspecttabellen").Select
xl.Range("b21").Select
xl.Selection.Copy
Selection.PasteSpecial DataType:=wdPasteText
End Sub
Now when I paste this, at most places in my document I get exactly what I want. But some places the field also gets replaced by a space and what I want to get from excell. This space is not in the excell sheet, nor in the sub, nor in the document, as far as I can see.
Anyone else who has this problem or anybody who can tell me where this stems from?
Thanks!