How to open "PPT file with new" option in Excel VBA

ganesh kumar

I have below code to open the ppt file, but I need to open that file with new option (Refer image). So that existing file will not be disturbed unknowingly. Any help please.

Sub openfile()
Dim objPP As Object
Dim objPPFile As Object
Set objPP = CreateObject("PowerPoint.Application")
objPP.Visible = True
Set objPPFile = objPP.Presentations.Open("E:\Test\Tempplate.pptx")
End Sub
Radhish Thekkute
Sub openfile()
Dim objPP As Object
Dim objPPFile As Object
Set objPP = CreateObject("PowerPoint.Application")
objPP.Visible = True
ts = Format(Now(), "MMDDYYYY_HHMM")
fn = "E:\Test\New_" & Trim(ts) & ".pptx"
FileCopy "E:\Test\Tempplate.pptx", fn
Set objPPFile = objPP.Presentations.Open(fn)
End Sub 

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0

関連記事

分類Dev

How to open a file using Excel VBA and turn off updating links

分類Dev

How to open ionicPopup on click of ionicActionSheet option?

分類Dev

How to open ods files in Excel?

分類Dev

How to set option button in excel as rating

分類Dev

Ms Excel VBA - Using Shell command to open files

分類Dev

excel 2011 mac VBA open file - error 75

分類Dev

How to make onchange dropdown option-url to open in my page

分類Dev

How to open new terminal and run script and sent the option

分類Dev

¿How to copy & paste information from an OPEN excel?

分類Dev

How to code Excel VBA equivalent of INDIRECT function?

分類Dev

how to export a custom query to excel in access/vba

分類Dev

How to submit form data excel vba

分類Dev

How to check & remove space in VBA excel

分類Dev

How to return multiple values in an Array - Excel VBA

分類Dev

How to automatically correct certain words in Excel (VBA)?

分類Dev

How uniquely populate vba combobox from excel?

分類Dev

How to write a VBA collection to an Excel sheet

分類Dev

How do you reference Ranges in Excel VBA?

分類Dev

How to append text to comment in Excel VBA?

分類Dev

How to write Excel function array selection/creation formula in Excel VBA

分類Dev

How to change the order of open "tabbed forms" in MS Access via VBA

分類Dev

Adding list of open workbooks to combo-box and related worksheets to a list-box (VBA Excel)

分類Dev

Excel 2016 VBA Workbooks.Open Loss Debug Step Mode ..再考

分類Dev

How to open an excel file with write protection using C#

分類Dev

How Do I Convert an Integer to a String in Excel VBA?

分類Dev

How to remove spaces from an entire Excel column using VBA?

分類Dev

How to get MSP subproject statusdate in a masterplan from Excel VBA

分類Dev

VBA Excel - How to fix code for filter on list box form

分類Dev

How to create a function to accept concatenated source value - Excel VBA

Related 関連記事

  1. 1

    How to open a file using Excel VBA and turn off updating links

  2. 2

    How to open ionicPopup on click of ionicActionSheet option?

  3. 3

    How to open ods files in Excel?

  4. 4

    How to set option button in excel as rating

  5. 5

    Ms Excel VBA - Using Shell command to open files

  6. 6

    excel 2011 mac VBA open file - error 75

  7. 7

    How to make onchange dropdown option-url to open in my page

  8. 8

    How to open new terminal and run script and sent the option

  9. 9

    ¿How to copy & paste information from an OPEN excel?

  10. 10

    How to code Excel VBA equivalent of INDIRECT function?

  11. 11

    how to export a custom query to excel in access/vba

  12. 12

    How to submit form data excel vba

  13. 13

    How to check & remove space in VBA excel

  14. 14

    How to return multiple values in an Array - Excel VBA

  15. 15

    How to automatically correct certain words in Excel (VBA)?

  16. 16

    How uniquely populate vba combobox from excel?

  17. 17

    How to write a VBA collection to an Excel sheet

  18. 18

    How do you reference Ranges in Excel VBA?

  19. 19

    How to append text to comment in Excel VBA?

  20. 20

    How to write Excel function array selection/creation formula in Excel VBA

  21. 21

    How to change the order of open "tabbed forms" in MS Access via VBA

  22. 22

    Adding list of open workbooks to combo-box and related worksheets to a list-box (VBA Excel)

  23. 23

    Excel 2016 VBA Workbooks.Open Loss Debug Step Mode ..再考

  24. 24

    How to open an excel file with write protection using C#

  25. 25

    How Do I Convert an Integer to a String in Excel VBA?

  26. 26

    How to remove spaces from an entire Excel column using VBA?

  27. 27

    How to get MSP subproject statusdate in a masterplan from Excel VBA

  28. 28

    VBA Excel - How to fix code for filter on list box form

  29. 29

    How to create a function to accept concatenated source value - Excel VBA

ホットタグ

アーカイブ