Results 1 to 3 of 3

command SaveAs

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-10-2011
    Location
    swindon, england
    MS-Off Ver
    Excel 2010
    Posts
    317

    command SaveAs

    HI

    I am trying to save a file as a CSV file into a specific location and the code i am using for some reason takes 3/4 of the file location andputs the rest as the filename.

    ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\SeymourJ\Desktop\Tasks\HondaExtractMacro" & "DealerExtract" & Format(Date, "yyyymmdd"), FileFormat:=xlCSV
    Can anyone help

    Thanks

    Jeskit
    Last edited by jeskit; 02-03-2011 at 11:49 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1