ExecuteExcel4Macro to get value from closed workbook

by

It depends on how you use it. The open file dialog box is being showed to you because the “strPath” doesn’t have a “” in the end 😉

Try this code.

Option Explicit

Sub Sample()
    Dim wbPath As String, wbName As String
    Dim wsName As String, cellRef As String
    Dim Ret As String
    
    'wbPath = "C:\Documents and Settings\Siddharth Rout\Desktop\"
    wbPath = "C:\Users\my.name\Desktop\"
    
    wbName = "QOS DGL stuff.xls"
    wsName = "ACL"
    cellRef = "C3"
    
    Ret = "'" & wbPath & "[" & wbName & "]" & _
          wsName & "'!" & Range(cellRef).Address(True, True, -4150)
    
    MsgBox ExecuteExcel4Macro(Ret)
End Sub

More Related Contents:

  1. VBA comma separated cells, needt last entry only
  2. Test or check if sheet exists
  3. How to copy Outlook mail message into excel using VBA or Macros
  4. Does the VBA “And” operator evaluate the second argument when the first is false?
  5. Are there disadvantages in putting code into Userforms instead of modules?
  6. Save each sheet in a workbook to separate CSV files
  7. Is VBA an OOP language, and does it support polymorphism?
  8. Export each sheet to a separate csv file
  9. ShowAllData method of Worksheet class failed
  10. Detect if range is empty
  11. Checking if a worksheet-based checkbox is checked
  12. Assign keyboard shortcut to run procedure
  13. Faster way to remove ‘extra’ spaces (more than 1) from a large range of cells using VBA for Excel
  14. Uncheck all checkboxes across entire workbook via CommandButton
  15. return csv file as recordset
  16. VBA workbooks.Close without being prompted to if the user wants to save?
  17. VBA equivalent to Excel’s mod function
  18. Copy a selected range to another worksheet
  19. Benchmarking VBA Code
  20. Excel macro – paste only non empty cells from one sheet to another
  21. The MacScript function is not working well in Office for Mac 2016! Any ideas?
  22. Pointers needed for speeding up nested loop macro in VBA
  23. ‘1004’: “The sort reference is not valid.”
  24. Create hyperlink to another sheet
  25. Reducing WithEvent declarations and subs with VBA and ActiveX
  26. Trying to open the workbook in separate instance
  27. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  28. Function Overloading and UDF in Excel VBA
  29. VBA Excel simple Error Handling
  30. How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?

Leave a Comment