Windows().Activate works on every computer except one

by

Whether or not you can leave off the file extension when calling (eg)

Windows("MyxlsbFile")

or

Workbooks("MyxlsbFile")

depends on whether the Windows Explorer setting “hide extensions for known file types” has been checked or not: if file extensions are shown in Windows Explorer then you must include the extension when calling WorkBooks().

I’m guessing this is the issue on the one PC where you have the problem.

Including the file extension always works (as long as there’s no other error of course)

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. Wait until ActiveWorkbook.RefreshAll finishes – VBA
  4. Pop up the Excel Statusbar?
  5. Excel VBA deleting rows in a for loop misses rows
  6. Execute a command in command prompt using excel VBA
  7. What is the lifetime of a global variable in excel vba?
  8. Download attachment from Outlook and Open in Excel
  9. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  10. Embed picture in outlook mail body excel vba
  11. How to check for empty array in vba macro [duplicate]
  12. Use autofilter on more than 2 criteria
  13. Where does VBA Debug.Print log to?
  14. What is the function of FormulaR1C1?
  15. Compiler Error: User-defined types not defined
  16. Open a workbook using FileDialog and manipulate it in Excel VBA
  17. Vba Excel do vlookup from a closed file
  18. excel hyperlink to nothing
  19. How to add headers to a multicolumn listbox in an Excel userform using VBA
  20. How to send files via HTTP_POST with Excel using VBA?
  21. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  22. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  23. VBA Macro crashes after 32000 rows
  24. TextJoin UDF For Excel 2013
  25. Open an Excel file from SharePoint site
  26. How to create dynamic variable names VBA
  27. How to break a long string into multiple lines
  28. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  29. simple vba code gives me run time error 91 object variable or with block not set
  30. VBA inheritance, analog of super

Leave a Comment