+ Reply to Thread
Results 1 to 2 of 2

VB code that Opens a powerpoint, savesAs and closes the ppt

  1. #1
    Registered User
    Join Date
    09-15-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    35

    VB code that Opens a powerpoint, savesAs and closes the ppt

    Hi All,
    Ive been working on and mutilating code I've sourced from various places on the web. I cant seem to get the save as feature right. Appreciate any help.
    The error message I am getting is : "run time error "438". object doesnt support this property or method"

    Please Login or Register  to view this content.
    I am getting the error in this line
    Please Login or Register  to view this content.
    You will need to enable Microsoft Powerpoint xx.0 Object library under Tools-> References

  2. #2
    Registered User
    Join Date
    09-15-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    35

    Re: VB code that Opens a powerpoint, savesAs and closes the ppt

    For anyone interested, the line should have read
    Please Login or Register  to view this content.
    I used code posted on the spreadsheet guru (found here: http://www.thespreadsheetguru.com/bl...already-exists) to incorporate version control

    Full code here:
    Please Login or Register  to view this content.
    Last edited by ajm1991; 07-02-2015 at 01:23 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Speed up code that opens and pulls data from 30+ excel files and then closes file
    By chadwick140 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-06-2013, 09:58 AM
  2. Trying to open Access using VBA, opens quick then closes any Ideas?
    By Harrm034 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2011, 03:47 PM
  3. File opens then closes automatically due to filename
    By p4c970 in forum Excel General
    Replies: 8
    Last Post: 03-09-2011, 08:25 AM
  4. Macro that opens and closes many files uses too much memory
    By Whizbang in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2010, 04:31 PM
  5. excel opens file then closes automatically
    By jpruffle in forum Excel General
    Replies: 3
    Last Post: 09-21-2009, 04:02 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1