Results 1 to 11 of 11

Thread: Excel Exception...only on one computer?[RESOLVED]

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2004
    Location
    Utah, USA
    Posts
    353

    Excel Exception...only on one computer?[RESOLVED]

    Hello. This code give me an error, but only on one computer. It works fine on other computers, except the Account Managers computer...fun huh? Maybe it is an Excel setting on her computer?
    VB Code:
    1. If sfd.ShowDialog = DialogResult.OK Then
    2.             strExcelFile = sfd.FileName
    3.             xlWBook.SaveAs(strExcelFile) 'LINE 1188
    4.         Else
    5.             Exit Sub
    6.         End If

    Here is the error:

    System.NullReferenceException: Object reference not set to an instance of an object.
    at Excel.WorkbookClass.SaveAs(Object Filename, Object FileFormat, Object Password, Object WriteResPassword, Object ReadOnlyRecommended, Object CreateBackup, XlSaveAsAccessMode AccessMode, Object ConflictResolution, Object AddToMru, Object TextCodepage, Object TextVisualLayout, Object Local)
    at AZShower.frmIncomeExcel.btnExportToExcel_Click(Object sender, EventArgs e) in C:\VB.NET\AZShower\Accounting\frmIncomeExcel.vb:line 1188

    Thanks for your time!
    Last edited by brendalisalowe; Nov 29th, 2005 at 11:33 AM.
    Brenda

    If it weren't for you guys, where would I be?

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