Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    33

    Question Unanswered: how to create excel file when clicking on the button.

    Hi All,

    I have one vb form in that one button is there.when I click on the button
    Excel file should create in "C:\Program Files\Admin\test" path.

    I don't want to open the excel file when click on the button just i want create the excel file in above specified path.

    This is the code iam writing under button _click event

    Dim objExcel As Excel. Application

    Set objExcel = New Excel.Application

    What are the next lines.

    Please help me on this.

    thanks,
    Amar...

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Use a workbook instead.

    go here for methods
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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