+ Reply to Thread
Results 1 to 2 of 2

Named Parameter error (Trying to batch save as xlsx files as xml data files)

  1. #1
    Registered User
    Join Date
    06-13-2019
    Location
    Boston, MA
    MS-Off Ver
    2016
    Posts
    1

    Named Parameter error (Trying to batch save as xlsx files as xml data files)

    Hi All,

    I am running into an error with my vba code. Basically I have about 200 xlsx files that have XML Mapping already in the xlsx file but wanted to create a vba code to open and save all the xlsx files as xml data files but I keep getting a Compile Error: Expected: named Parameter. I have included my code below for your reference. Any help would be appreciated. Thanks in advance!
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 06-13-2019 at 03:27 PM.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Named Parameter error (Trying to batch save as xlsx files as xml data files)

    Please nest your code in code tag using # button.

    Your issue is with below line.
    Please Login or Register  to view this content.
    If you qualify a parameter with name, you have to qualify all parameter with name.

    So...
    Please Login or Register  to view this content.
    Alternately drop the parameter name all together.
    Please Login or Register  to view this content.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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. Batch update of many XLS files to XLSX format?
    By MathUKTeacher in forum Excel General
    Replies: 1
    Last Post: 02-03-2016, 06:51 PM
  2. Run macro on several .csv files and save as .xlsx
    By pbd3mon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-03-2015, 11:41 AM
  3. [SOLVED] Save all xls files in directory as xlsx
    By StartRunMSPaint in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2014, 04:45 PM
  4. Batch files using save as
    By dezinezone in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2014, 10:26 PM
  5. Batch files using save as
    By dezinezone in forum Excel General
    Replies: 1
    Last Post: 01-02-2014, 05:16 PM
  6. Replies: 0
    Last Post: 03-13-2013, 09:08 PM
  7. Save all .xlsx files in a directory to .xls
    By paul00 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2012, 08:05 PM

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