jabawalkie5000
New Member
- Joined
- Jun 13, 2011
- Messages
- 41
Hi All
I have a list of file names with extension name, eg mrexcel.xls, in a tab called "list". They are excel, word and powerpoint files only.
a) How can I open these files in the exact order they are listed
AND
b) How do I open a new powerpoint file and import the contents of each file in the order they are listed there
Note: if an excel file has 3 tabs, each should be exported to PowerPoint in turn in the same order. If a word document, each page to a slide, obviously if powerpoint, slide for slide
Can the macro close all files at the end and ask you to save the new powerpoint file?
Thanks
I have a list of file names with extension name, eg mrexcel.xls, in a tab called "list". They are excel, word and powerpoint files only.
a) How can I open these files in the exact order they are listed
AND
b) How do I open a new powerpoint file and import the contents of each file in the order they are listed there
Note: if an excel file has 3 tabs, each should be exported to PowerPoint in turn in the same order. If a word document, each page to a slide, obviously if powerpoint, slide for slide
Can the macro close all files at the end and ask you to save the new powerpoint file?
Thanks