Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA with power point?
I have bunch if power point files in a folder C:\123
I want to list each slide in those powerpoint files in the excel sheet alongwith full path and filename. Is it possible? Regards, Malcom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA with power point?
Howdy Malcom
I'm in no position to provide code to use, however if you go he http://groups-beta.google.com/group/...l.programming/ and search (using the second search field - ie. search within this newsgroup) on 'listing files' there is tonnes of relevant examples eg. http://groups-beta.google.com/group/...g+files&qt_g=1 HTH Matt "Malcom Jazz" wrote in message ... I have bunch if power point files in a folder C:\123 I want to list each slide in those powerpoint files in the excel sheet alongwith full path and filename. Is it possible? Regards, Malcom |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA with power point?
Malcolm,
Here is some code to do it Sub FileListing() Dim i As Long Dim oFolder As Object Dim oFldr As Object Dim oFile As Object Dim oFiles As Object Dim sOld As String Set oFSO = CreateObject("Scripting.FileSystemObject") Set oFolder = oFSO.GetFolder("C:\myTest") a = 2 For Each oFldr In oFolder.subFolders Set oFiles = oFolder.Files For Each oFile In oFiles If oFile.Type = "Microsoft Powerpoint Presentation" Then sOld = oFile.Name Range("A" & a) = sOld a = a + 1 End If Next oFile Next oFldr End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Malcom Jazz" wrote in message ... I have bunch if power point files in a folder C:\123 I want to list each slide in those powerpoint files in the excel sheet alongwith full path and filename. Is it possible? Regards, Malcom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel spreadsheet in power point to email | Excel Discussion (Misc queries) | |||
link Excel / Power Point | Excel Discussion (Misc queries) | |||
pie charting through excel, using power point | New Users to Excel | |||
Challenge...Excel Chart to Power Point | Excel Programming | |||
Cant close Excel App from Power Point | Excel Programming |