+ Reply to Thread
Results 1 to 3 of 3

Live exchange currency VBA code

  1. #1
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Live exchange currency VBA code

    Good evening all
    im looking for code that can be used in excel to live update of currency

    i found code online but its still give me error
    first they need access key and i register with site and now have access key but not understand how can add to code
    second
    its give error in the following line
    response= "1 " &a& "=" & replace(exRate,:""":","") &""&b


    i appreciate your support and help
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Live exchange currency VBA code

    Excel 365 has a live currency exchange rate built in. See the link below.

    Get a currency exchange rate
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: Live exchange currency VBA code

    dear Alphafrog
    thank you so much for your replying and concern
    the problem it will not available with office 2019 that why looking for another solution

+ 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. Insert live exchange rate?
    By ADB in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 03-29-2021, 06:04 AM
  2. Replies: 2
    Last Post: 09-05-2020, 01:11 AM
  3. Coinbase Pro (crypto exchange) How to get live prices in Excel ?
    By mamba76 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2018, 07:47 PM
  4. Excel 2007 : Live exchange rate data feed?-
    By benoj2005 in forum Excel General
    Replies: 4
    Last Post: 03-22-2012, 10:40 AM
  5. live feed from stock exchange recording change every 15mins
    By JonoCook in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2012, 09:29 AM
  6. Currency exchange using VLOOKUP
    By BlueLobster in forum Excel General
    Replies: 10
    Last Post: 06-14-2010, 06:45 PM
  7. Currency Exchange Forumla
    By gaspower in forum Excel General
    Replies: 4
    Last Post: 09-29-2007, 11:28 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