Open Excel file for reading with VBA without display

by

Not sure if you can open them invisibly in the current excel instance

You can open a new instance of excel though, hide it and then open the workbooks

Dim app as New Excel.Application
app.Visible = False 'Visible is False by default, so this isn't necessary
Dim book As Excel.Workbook
Set book = app.Workbooks.Add(fileName)
'
' Do what you have to do
'
book.Close SaveChanges:=False
app.Quit
Set app = Nothing

As others have posted, make sure you clean up after you are finished with any opened workbooks

More Related Contents:

  1. Get File Path (ends with folder)
  2. Print function selecting wrong Type of Change option excel vba
  3. What is the difference between .text, .value, and .value2?
  4. Excel VBA – How to add dynamic array formula
  5. VBA check if file exists
  6. How can I concatenate strings in VBA?
  7. Copy/Paste/Calculate Visible Cells from One Column of a Filtered Table
  8. Loading addins when Excel is instantiated programmatically
  9. Trying to use variables as values vba to sql
  10. How to call a macro from a button and pass arguments
  11. Copy Excel range as Picture to Outlook
  12. VBA (Excel) Dictionary on Mac?
  13. Return RGB values from Range.Interior.Color (or any other Color Property)
  14. Refresh Excel VBA Function Results
  15. excel VBA run macro automatically whenever a cell is changed
  16. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  17. VBa conditional delete loop not working
  18. Translate text using vba
  19. Concatenate column headers if value in rows below is non-blank
  20. Update excel sheet based on outlook mail [closed]
  21. Sending mail using Outlook where the Send method fails
  22. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  23. Using a variable for row in (row,column) for a range in VBA
  24. Unicode string literals in VBA
  25. How to get the path of current worksheet in VBA?
  26. How to open a workbook specifying its path
  27. How can I loop through a subset of worksheets?
  28. How to run a string as a command in VBA
  29. How to Send Email When Computer is Locked?
  30. VBA, Combine PDFs into one PDF file

Leave a Comment