Insert Excel

A

Anders Winther

I want to inset an unnamed excel document and use this macro for this

Sub TT_InsertObject(
With Dialogs(wdDialogFileOpen
.Displa
If .Name <> "" The
NytNavn = .Nam
End I
End Wit

If NytNavn <> "" The
Selection.InlineShapes.AddOLEObject ClassType:="Excel.Sheet.8", FileName:=
NytNavn, LinkToFile:=True, DisplayAsIcon:=Fals
End I
End Su

But how to only inset only one row ?
 
P

Peter Hewett

Hi ?

Try using the following instead:

Selection.InsertFile FileName:= _
"My File.xls", Range:="A1:E5", _
ConfirmConversions:=False, Link:=False, Attachment:=False

Check out the Range objects use here, it's inserting cells A1:E5.

HTH + Cheers - Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Loop through pages and insert header image 0
Using Sound Recorder in Word VBA SOMETIMES does not work 0
Macros for Microsoft Excel Worksheet in Microsoft Word Document 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
using program to record audio comment and compress audio to MP3 0
insert linked file and link icon, but frompt for file location 2
InsertObject Macro blocking access to other Insert Menu Items 2

Top