Results 1 to 3 of 3

Excel Macro to open, save embedded excel, pdf and word files

This is a discussion on Excel Macro to open, save embedded excel, pdf and word files within the Excel Questions forums, part of the Question Forums category; I have a question that has stumped me so far. Here is the scenario: I am dealing with a spreadsheet ...

  1. #1
    New Member
    Join Date
    Sep 2009
    Posts
    3

    Default Excel Macro to open, save embedded excel, pdf and word files

    I have a question that has stumped me so far. Here is the scenario: I am dealing with a spreadsheet that has several tabs on it. In each tab, there are several word, powerpoint, and pdf documents that are embedded as objects. My task is to write a macro, that will for each document (keep in mind its an embedded object that needs to be opened), open it with the appropriate program, and save it using a pre-assigned name (the name of the column heading and the row it is in) to a predetermined folder path. This process needs to be duplicated about 200 times. I'm not sure if this is even possible, but I know enough about vba to believe that it is. I've been working on it since yesterday, and I can't seem to tie the pieces together. Can anyone help on this? I would greatly appreciate it!

    Thanks!

    David

  2. #2
    New Member
    Join Date
    Sep 2009
    Posts
    3

    Default Re: Excel Macro to open, save embedded excel, pdf and word files

    Does anyone have any ideas on how to attack this? I understand its difficult. Would it be helpful if I attached an example of what I am working with?

  3. #3
    New Member
    Join Date
    Sep 2009
    Posts
    3

    Default Re: Excel Macro to open, save embedded excel, pdf and word files

    Are people just ignoring this question because I'm new? Or is it really that difficult? I'd love to get a response here.

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com