+ Reply to Thread
Results 1 to 6 of 6

Need help converting Excel 2013 command into Excel 2010

  1. #1
    Registered User
    Join Date
    02-21-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2014
    Posts
    14

    Need help converting Excel 2013 command into Excel 2010

    Hello lovely people,

    I've been using a spreadsheet for an online game to pull prices from the market and make some basic calculations with it.
    I figured I'd share the spreadsheet with other members of the game, most of whom use Excel 2010, and every single one of them has reported the spreadsheet not working.

    Basically, I am asking you guys to help me "convert" my Excel 2013 document in a working Excel 2010 document.

    Spreadsheet 2013.xlsx (The Excel 2013 spreadsheet).
    The command I am using to import the code is
    =FILTERXML(WEBSERVICE(CONCATENATE(Sell_Swap,TypeID,B5)),"//sell/min")

    Probably because this is a new command added to Excel 2013, I can't get it to work on 2010.
    Could someone, please, rewrite this bit of code to get it working for Excel 2010?

    I hope to hear from you guys.

    Yours sincerely,

    Maximus.

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,842

    Re: Need help converting Excel 2013 command into Excel 2010

    I don't know how to convert those new commands to Excel 2010, but apparently they are included in the 'Excel PowerUps Premium Suite' available to download from CNET.com, and other places. It is a free 30-day trial, $39.95 to buy, and includes the new functions introduced in Excel 2013, along with a bunch of others.

    Disclaimer: I haven't tried it. I am not endorsing it. As always, use on a backup copy of your data!

    - Moo

  3. #3
    Registered User
    Join Date
    02-21-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2014
    Posts
    14

    Re: Need help converting Excel 2013 command into Excel 2010

    Quote Originally Posted by Moo the Dog View Post
    I don't know how to convert those new commands to Excel 2010, but apparently they are included in the 'Excel PowerUps Premium Suite' available to download from CNET.com, and other places. It is a free 30-day trial, $39.95 to buy, and includes the new functions introduced in Excel 2013, along with a bunch of others.

    Disclaimer: I haven't tried it. I am not endorsing it. As always, use on a backup copy of your data!

    - Moo
    Thank you for taking the time to reply to my thread.
    The reason I want to be able to just have it in the spreadsheet, is because I share the spreadsheet with other people. I'm pretty sure none of them would want to install any extra things.
    What if I gave you the code from a working Google Spreadsheet? Will you be able to convert that into Excel 2010?

  4. #4
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,842

    Re: Need help converting Excel 2013 command into Excel 2010

    Not likely... considering I don't know how the new functions actually work/process the data, I'm not going to be much help in that regard. Sorry. There may be others on the boards here that can help. I'll pass this on to the guru's here and see if anything comes up.

    - Moo

  5. #5
    Registered User
    Join Date
    02-21-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2014
    Posts
    14

    Re: Need help converting Excel 2013 command into Excel 2010

    Has anyone got any ideas?

  6. #6
    Registered User
    Join Date
    09-03-2015
    Location
    seattle, wa
    MS-Off Ver
    2010
    Posts
    1

    Re: Need help converting Excel 2013 command into Excel 2010

    The add-in talked about is available at http://officepowerups.com/downloads/...premium-suite/.

    It's still free for the first month. I use it, works just as I expected. Totally worth the quick install.

+ 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. Macros written in Excel 2010 don't work in Excel 2013
    By Bukovnik in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-03-2015, 01:24 AM
  2. VBA charts work fine in excel 2013 but not in excel 2010
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2014, 08:05 AM
  3. Code created in Excel 2010 does not work with Excel 2013
    By Steve@Rugby in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2014, 10:14 AM
  4. Excel 2013 Webservice function
    By vanells in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2013, 02:28 PM
  5. [SOLVED] Excel 2003: Grabbing a dataset from a webservice and then sending to a webservice?
    By gjn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2005, 11:05 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