Open folder in new instance

by

Try the

Application.Getopenfilename

This opens the dialogue for picking files. If you want to dispaly a specific folder, use this code before the Getopenfilename:

chdir "c:\whatever\wherever"

Are you sure you need a separate instance of Excel? It has many disadvantages, and only a few advantages.

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. How can I insert variable into formula in VBA
  4. Wait until ActiveWorkbook.RefreshAll finishes – VBA
  5. Code in VBA loops and never ends. How to fix this?
  6. Excel column number from column name
  7. Pop up the Excel Statusbar?
  8. VBA – destroy a modeless UserForm instance properly
  9. How To Speed Up VBA Code
  10. Execute a command in command prompt using excel VBA
  11. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  12. Copy data from another Workbook through VBA
  13. Excel VBA Load worksheet in Function
  14. Searching an excel with two search words (multiple lookup) using vba macro [closed]
  15. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  16. Load csv file into a VBA array rather than Excel Sheet
  17. Insert line break in wrapped cell via code
  18. Change color of certain characters in a cell
  19. Combine multiple Excel workbooks into a single workbook
  20. Excel Macro, inserting internationally valid formula during run-time
  21. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  22. Copy filtered data to another sheet using VBA
  23. VBA Macro crashes after 32000 rows
  24. How to create dynamic variable names VBA
  25. How to break a long string into multiple lines
  26. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  27. simple vba code gives me run time error 91 object variable or with block not set
  28. How do I get a list of unique values from a range in Excel VBA?
  29. How to get selected value in multicolumn listbox
  30. Query my excel worksheet with VBA

Leave a Comment