jabawalkie5000
New Member
Hi All
I just joined. I need some help with constructing a macro
I have a sheet in excel called list. This list contains only word, excel and powerpoint files including extension tags eg .xls
I need a macro to open each file and export the tabs/ pages/ slides to a new powerpoint presentation in the exact order the files are listed
eg if the first file is an excel file, open and export the sheets from left to right to powerpoint (sheet per slide)
Also for word, each page per slide
For powerpoint slide for slide
I want the macro to prompt at the end to save new file and then close all the other opened files used to export data.
If its possible, can there be a dynamic cell in a sheet called "control" that allows excel to scale down or up the data before it exports to powerpoint . Maybe a percentage eg 75%
Thanks
I just joined. I need some help with constructing a macro
I have a sheet in excel called list. This list contains only word, excel and powerpoint files including extension tags eg .xls
I need a macro to open each file and export the tabs/ pages/ slides to a new powerpoint presentation in the exact order the files are listed
eg if the first file is an excel file, open and export the sheets from left to right to powerpoint (sheet per slide)
Also for word, each page per slide
For powerpoint slide for slide
I want the macro to prompt at the end to save new file and then close all the other opened files used to export data.
If its possible, can there be a dynamic cell in a sheet called "control" that allows excel to scale down or up the data before it exports to powerpoint . Maybe a percentage eg 75%
Thanks