Thanks John, But after adding this into the VBA module & running it ( with the location changed to mine) , it doesn't work.

The only thing which happens is opening up a PPT which is blank. Nothing else happens. Was this the only thing in the macro ?

I am not very familiar with the VBA coding so not sure if that is what you have suggested for now.

If not, is it possible for you to send me the PPT & the excel file with macro enabled in a zip file ? post it here or may be mail me at tmaster81@gmail.com

Thanks a a ton for your help.