How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?

by

Most likely the path you are trying to access does not exist. It seems you are trying to save to a relative location and you do not have an file extension in that string. If you need to use relative paths you can parse the path from ActiveWorkbook.FullName

EDIT:
Better syntax would also be 

ActiveWorkbook.SaveAs Filename:=myFileName, FileFormat:=xlWorkbookNormal

More Related Contents:

  1. How to add a custom Ribbon tab using VBA?
  2. filter out multiple criteria using excel vba
  3. Closing Excel Application using VBA
  4. How to add parameters to an external data query in Excel which can’t be displayed graphically?
  5. Cannot VBA write data to cells in Excel 2007/2010 within a function
  6. VBA equivalent to Excel’s mod function
  7. Excel VBA to match and line up rows
  8. Excel: the Incredible Shrinking and Expanding Controls [closed]
  9. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  10. How to programmatically code an ‘undo’ function in Excel-Vba? [duplicate]
  11. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  12. Delete all data rows from an Excel table (apart from the first)
  13. How to insert a picture into Excel at a specified cell position with VBA
  14. Save multiple sheets to .pdf
  15. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  16. How can I create a calendar input in VBA Excel?
  17. Merge values of column B based on common values on column A
  18. How to import a table from web page (with “div class”) to excel?
  19. Range limit conundrum
  20. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  21. How to give a time delay of less than one second in excel vba?
  22. Changing the date format to yyyy-mm-dd
  23. Delete all duplicate rows Excel vba
  24. Select Newest Record and Create New Table of Unique Values in Excel
  25. Are ActiveX Controls Disabled?
  26. VBA copy rows that meet criteria to another sheet
  27. VBA Dialog box to select range in different workbook
  28. Extract URL From Excel Hyperlink Formula
  29. What is the different between IsNull, IsEmpty, =Empty, and an empty string ie “” and why might I use variants
  30. How to detect if user select cancel InputBox VBA Excel

Leave a Comment