Results 1 to 3 of 3

Powerpoint: Import Cell Value from Excel

Threaded View

4Ferdinand Powerpoint: Import Cell Value... 10-02-2010, 06:13 AM
Andy Pope Re: Powerpoint: Import Cell... 10-02-2010, 06:37 AM
4Ferdinand Re: Powerpoint: Import Cell... 10-02-2010, 07:20 AM
  1. #1
    Registered User
    Join Date
    10-02-2010
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    7

    Powerpoint: Import Cell Value from Excel

    Hello everyone, it's my first post so nice to meet you.


    So here goes the question:
    Assume i have C:\book1.xls file; and textbox1 & commandbutton1 in powerpoint slide 1.

    How to change the text in textbox1 (in powerpoint) to match the value of A1 Cell in book1.xls when i click commandbutton1?

    Private Sub commandbutton1_Click()
    textbox1.text = (????).workbooks("C:\book1.xls").Worksheets("Sheets1").Range("A1").formular1c1
    end sub


    Thanks for your help.
    Last edited by 4Ferdinand; 10-02-2010 at 07:21 AM.

Thread Information

Users Browsing this Thread

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

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