Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by matt4305

  1. matt4305

    Excel File Attributes

    Thanks as soon as you posted this worked for me. With ofdExcel .Title = "Please Choose File" .Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*" .FilterIndex = 1 End With
  2. matt4305

    Excel File Attributes

    I was wondering how I could set up the file filer to only show Excel documents. Nothing I have tried has worked.
  3. matt4305

    Excel File Attributes

    Thanks it worked well 'Excel App Dim excelApp As New Excel.Application ' you dont want to see it excelApp.Visible = False 'Open File original = excelApp.Workbooks.Open(FileName) WorksheetName = CStr(excelApp.ActiveWorkbook.Sheets(1).Name()) 'close the workbook 'The entire excel app should...
  4. matt4305

    Excel File Attributes

    I have an application that loads a dataset from an Excel document. For the dataadpater I use Dim odaExcel As New OleDbDataAdapter("SELECT * FROM [Sheet1$]", conn) I would like to get the actual value of Sheet1 before I pull the dataset. Is their a way to get the value by opening the...
  5. matt4305

    When printing .pdf it prints with a gray background

    Whenever I print a document from acrobat it prints with a gray background, however when I print the same document from any other computer it prints fine. I have the same version of Acrobat. Any suggestions on how to lose the greay background?

Part and Inventory Search

Back
Top