Re: Append Documents

>So is the only way to do what I want ..

No, but...

>>There are however many issues.

Just as Jean-Guy stated, if the styles are different, it really can
throw your document into chaos.

Having said that, you can...

Selection.EndKey Unit:=wdStory
Selection.InsertBreak Type:=wdSectionBreakNextPage
Selection.InsertFile FileName:= _
"C:\My Documents\" & Selected_Array(Counter), Range:="", _
ConfirmConversions:=False, Link:=False, Attachment:=False

Of course, you'll have to built a userform to list the files (probably
in a listbox) so users can pick the files they want. Then loop through
the selected list, adding the files with the above code. (It probably
would work better with Range instead of Selection, but one thing at a
time.)

.

Relevant Pages

  • Debug suggestions?
    ... I've created a workbook with 2 userforms and my macros; ... However, when she clicks on a commandbutton on the userform, it crashes her ... clear a listbox, a for-next loop, and in the loop, a line of code that adds ... names into the listbox. ...
    (microsoft.public.excel.programming)
  • DELETING DATA FROM USERFORM
    ... I have a program that uses a userform to display data, ... if there any good code that will remove a row from a listbox, ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • How to glance at other workbook while remaining in MyForm.Listbox?
    ... User has some item selected in a listbox of a userform. ... If possible I would like to control behaviour of the other workbook so it ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • vlookup
    ... Would it be possible to use a variable returned by a ListBox, on a UserForm, ... to place a value in a TextBox on the same UserForm? ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • LIST BOX ON USERFORMS
    ... I HAVE A PROGRAM THAT USES A LISTBOX ON A USERFORM, ... IT SEEMS THAT ON SOME PEOPLES PC THE LIST BOX MOVE TO A DIFFERENT ... Prev by Date: ...
    (microsoft.public.excel.programming)