VBA for excel/word


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: VBA for excel/word

  1. #1
    Sam Rice Guest

    VBA for excel/word


    Hello,

    I am fairly new with VBA, so please excuse the misuse of words and terms.


    I am making a sales package with excel and word. I am using excel as a sales
    piece that allows the users to select various services. Each one of these
    services has a linked document, which I can get to embedd in the worksheet.
    The problem is that this excel sheet has several inputs and thus several
    documents.

    Using VBA I would like to compile all these documents into one master document.
    I have tried several Copy/paste methods, moving methods, creating documents
    and then pasting, but nothing seems to work.

    I am at a stopping point, so if anyone has some direction, I will be forever
    grateful.

    Thanks in Advance
    Sam Rice

  2. #2
    Paul Clement Guest

    Re: VBA for excel/word

    On 4 Jun 2001 12:58:42 -0700, "Sam Rice" <sgr105@hotmail.com> wrote:


    Hello,

    I am fairly new with VBA, so please excuse the misuse of words and terms.


    I am making a sales package with excel and word. I am using excel as a sales
    piece that allows the users to select various services. Each one of these
    services has a linked document, which I can get to embedd in the worksheet.
    The problem is that this excel sheet has several inputs and thus several
    documents.

    Using VBA I would like to compile all these documents into one master document.
    I have tried several Copy/paste methods, moving methods, creating documents
    and then pasting, but nothing seems to work.

    I am at a stopping point, so if anyone has some direction, I will be forever
    grateful.

    Thanks in Advance
    Sam Rice

    I guess it depends on how you want this to look to your user. Do you want the actual documents
    visible in Excel (embedded) or do you simply want links for them to click on to view the documents
    (linked)?


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center