Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Unanswered: Excel Macro Help?

    Can anyone help me debug this section of code?

    today = Format(Now, "ddmmmyy")
    ActiveWorkbook.SaveAs Filename:="F:\folder\my_file_" & today & ".txt", FileFormat:=x1Text, CreateBackup:=False

    I'm stumped

  2. #2
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72

    Re: Excel Macro Help?

    Hi

    This works:

    ActiveWorkbook.SaveAs Filename:= _
    "C:\Documents and Settings\Pierre\Mes documents\Book1" & Day(Now()) & Month(Now()) & Year(Now()) & ".txt", FileFormat:= _
    xlText, CreateBackup:=False

    Many other free tips on
    http://www.excel-vba.com





    Originally posted by FuzzyLogic
    Can anyone help me debug this section of code?

    today = Format(Now, "ddmmmyy")
    ActiveWorkbook.SaveAs Filename:="F:\folder\my_file_" & today & ".txt", FileFormat:=x1Text, CreateBackup:=False

    I'm stumped
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •