Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 2 of 2

Thread: Automate Powerpoint Presentation

  1. #1
    Join Date
    21st May 2008

    Automate Powerpoint Presentation

    Hi, I have a requirement which entails automating of powerpoint presentation. Currently, the user copies and pastes the files into powerpoint to generate the report.
    user interface that i created consists of a listbox and a couple of buttons. One button for user to browse & add files to the listbox, one to remove files from it and one to Generate Report.

    I m trying to save the file paths to a string array so that when user click the Generate Report button, the program can pick one file name from listbox, search it in the string array and if it finds the file, takes the path from that array index, creates an object for that file and then create a powerpoint slide object and using paste special, paste that file in powerpoint.

    I m having trouble making the string array hold its values between different button clicks.I'd appreciate whatever help I can get.

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    7th March 2003
    Essex, England

    Re: Automate Powerpoint Presentation

    If the variable is losing content then you need to check the scope of the variable.
    Or check that the contents are not cleared by some other part of your code.

    Any more help will need actual code example.


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Run Macros In Powerpoint Presentation
    By Jon_Smith in forum Excel and/or Powerpoint Help
    Replies: 3
    Last Post: June 3rd, 2008, 18:06
  2. Open Powerpoint Presentation With Vba
    By Jimmy.W.123 in forum Excel and/or Powerpoint Help
    Replies: 1
    Last Post: January 12th, 2007, 07:49


Posting Permissions

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