+ Reply to Thread
Results 1 to 6 of 6

Save file syntax error

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Save file syntax error

    Hi friends,
    I’m getting syntax error on the following line.

    Please Login or Register  to view this content.
    Thanking you,
    Sincerely,

    mso3

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Save file syntax error

    Try adding the FileFormat parameter,

    Please Login or Register  to view this content.

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Save file syntax error

    Or (click F2 in VBEditor and then type FileFormat in searchbox)
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Save file syntax error

    Hi berlin,
    Thank you. Perfect. I forgot to add file format parameter.

    Hi Bakerman2,
    Thank you for additional solution in short. However I tried your suggestion but unable to get the file formats. Please suggest me the steps to get the various file codes using f2-search box.

    Thank you to both of you for solving my problem.

    Have a nice time.

  5. #5
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Save file syntax error

    See Screenshot.
    Attached Images Attached Images

  6. #6
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Save file syntax error

    You're welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Correct save path and syntax to save workbookdirectly into ONEDRIVE subfolder
    By osbertdebroilg in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-29-2015, 06:27 PM
  2. [SOLVED] Syntax Compile Error - How to work around this (file path doesn't exist)
    By Harribone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2015, 08:19 AM
  3. Excel Error on file save
    By Ninjataktikz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2012, 04:55 PM
  4. What is the syntax to save a file to the working directory with VBA
    By laguna92651 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2012, 02:18 PM
  5. Syntax Error in VBA and Cannot save .xlsx with Macro - Formulas too long I think?
    By Belhadj in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-07-2010, 09:54 PM
  6. Saving a file - syntax error
    By Foxcan in forum Excel General
    Replies: 0
    Last Post: 07-20-2009, 06:35 PM
  7. Error when trying to save file as xml data
    By hegisin in forum Excel General
    Replies: 0
    Last Post: 08-21-2007, 12:33 AM

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