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!

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

Search results for query: *

  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