PDA

View Full Version : import data to ms excel



Pete
10-27-2008, 08:38 AM
Hi Experts

How would you import a microsoft powerpoint file into ms excel...........using a macro.........

The user is asked via a pop up window the file name they wish to import into excel (the file is always saved in my documents - fixed position) run the macro.....import file.

I am sure this would be the complete opposite of importing from excel to powerpoint.............

data is enter into cell A1 in a new workbook in excel...........

RonMcK
10-27-2008, 09:28 AM
Pete,

Have you tried recording a macro as you step through importing a power point file into Excel? You can then edit the macro so it will work for any PPT that you want to import.

Cheers,