How to save Excel Workbook to Desktop regardless of user?

by

I think this is the most reliable way to get the desktop path which isn’t always the same as the username.

MsgBox CreateObject("WScript.Shell").specialfolders("Desktop")

More Related Contents:

  1. Print function selecting wrong Type of Change option excel vba
  2. Format Cell Contents
  3. Excel formula checklist in employees
  4. How do I put double quotes in a string in vba?
  5. What is the difference between .text, .value, and .value2?
  6. Excel VBA – How to add dynamic array formula
  7. How can I URL encode a string in Excel VBA?
  8. VBA rounding problem
  9. VBA – Write all possible combinations of 4 columns of data [duplicate]
  10. Remove duplicates from array using VBA
  11. 2 ways for “ClearContents” on VBA Excel, but 1 work fine. Why? [duplicate]
  12. Excel 2013 VBA Clear All Filters macro
  13. How to automatically insert a blank row after a group of data
  14. Get File Path (ends with folder)
  15. Email a single attachment from folder of files each to a different person
  16. Sum function in VBA
  17. Excel error 1004 “Unable to get …. property of WorksheetFunction class” appearing inconsistently
  18. How can I install/use “Scripting.FileSystemObject” in Excel 2010 for MAC?
  19. How to get the path of current worksheet in VBA?
  20. Excel VBA to match and line up rows
  21. Change font color for a part of text in cell
  22. Create a new object using the text name of the class
  23. Excel cell from which a Function is called [duplicate]
  24. How to extract text within a string of text
  25. GET pictures from a url and then rename the picture
  26. Excel VBA – select multiple columns not in sequential order
  27. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  28. Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
  29. Delete all data rows from an Excel table (apart from the first)
  30. Excel telling me my blank cells aren’t blank

Leave a Comment