Results 1 to 3 of 3

Thread: opening and closing files

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2000
    Posts
    6
    how do i open, read and write to individual cells for microsoft excel in visual basic.
    where do i get information on how to do so.
    thanks
    Liam

  2. #2
    Fanatic Member VBKNIGHT's Avatar
    Join Date
    Oct 2000
    Location
    Port25
    Posts
    619

    Wink

    Hope this will help...

    Sub NewApp()
    Dim xlApp As Object
    Set xlApp = CreateObject("Excel.Application")
    xlApp.Visible = True
    With xlApp
    'u can use vba code here like
    Range("A1").Select
    ActiveCell.Value = "VBKNIGHT"
    ActiveCell.Offset(1, 0).Activate
    ActiveCell.Value = "VBKNIGHT"
    End With
    xlApp.Quit
    End Sub

  3. #3
    Fanatic Member
    Join Date
    Feb 2000
    Location
    The Netherlands
    Posts
    715
    VBKNIGHT, please format your code like this:
    [code]
    code goes here
    [/code]
    Oetje
    oetje@home.nl
    93606776
    Visual Basic 6, Windows 2000

    Never pet a burning dog

Posting Permissions

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



Click Here to Expand Forum to Full Width