Create PPT From Excel Macro

Sub CreateSlides() ‘Open the Excel workbook. Change the filename here. Dim OWB As New Excel.Workbook Set OWB = Excel.Application.Workbooks.Open(“E:\viratkohli.xlsx”) ‘Grab the first Worksheet in the Workbook Dim WS As Excel.Worksheet Set WS = OWB.Worksheets(1) ‘Loop through each used row in Column A For i = 1 To WS.Range(“B65536”).End(xlUp).Row ‘Copy the first slide and paste at […]

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *