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

[mcledavid]

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 <NOBR id=itxt_nobr_1_0 style="FONT-WEIGHT: normal; FONT-SIZE: 100%; COLOR: darkgreen">documents</NOBR> 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

 

[mcledavid]

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?

 

[mcledavid]

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