Results 1 to 6 of 6

Thread: open a specific excel worksheet from powerpoint

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Feb 2018
    Posts
    10
    Location

    open a specific excel worksheet from powerpoint

    Hi,
    I want open a specific excel worksheet from powerpoint.
    I try:
    Sub ApriExcel()
        Dim xlApp As Object
        Dim xlWorkBook As Object
        Dim ExcelValue As Double 
        Set xlApp = CreateObject("Excel.Application")
        xlApp.Visible = True
        Set xlWorkBook = xlApp.Workbooks.Open("C:\Users\Microsoft\Desktop\Formazione light\Formazione\Start formazione\Slides Ended\AvvioCorso.xlsm", True, False)
        xlWorkBook.Worksheets("Start").Range("B2").Value 'give me a debug Error
    End Sub
    But debug does not like it . Where am I wrong?

    Thanks in advance
    bg66
    Last edited by Aussiebear; 03-22-2025 at 04:16 PM.

Posting Permissions

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