Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing multiple files? (Office XP)

    Is there a way to set up a macro to do the following actions? :
    On Click
    Go to C:/My PowerPoint Presentations
    SelectAll (select all files in folder)
    Import all selected files

    ?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Importing multiple files? (Office XP)

    You can open multiple files in PPT by using Shift Clicking to select multiple files when in the Open dialog. Use Ctrl Clicking to select files that aren't grouped together.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing multiple files? (Office XP)

    There's no way to set up a macro?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing multiple files? (Office XP)

    What exactly do you mean by import? Open in PowerPoint, or insert all slides from all presentations into the currently open presentation? (Neither seems particularly useful)

  5. #5
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing multiple files? (Office XP)

    Import all slides from particular presentations into current presentation....
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing multiple files? (Office XP)

    Does this do what you want?

    Sub InsertSlides()
    ' Path must include trailing backslash
    Const strPath = "C:My PowerPoint Presentations"
    Dim strFile As String
    strFile = Dir(strPath & "*.ppt")
    Do While Not (strFile = "")
    ActivePresentation.Slides.InsertFromFile strPath & strFile, ActivePresentation.Slides.Count
    strFile = Dir
    Loop
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •