+ Reply to Thread
Results 1 to 11 of 11

API VBA Code

  1. 01-17-2019, 05:12 PM #1
    wannaBactuary
    wannaBactuary is offline
    Registered User
    Join Date
    01-11-2019
    Location
    CHI
    MS-Off Ver
    2013
    Posts
    22

    API VBA Code

    Hi Everyone! My code keeps breaking for different reasons, and I'm wondering whether its just using too much memory after looping through many times over. I find that I can pull data for 30 products or so before it crashes. Thought I would start by asking for any suggestions to this code! Appreciate the help and any discussion. I have quite a bit of pressure to have this run flawlessly and don't have many resources.

    Please Login or Register  to view this content.
    Last edited by wannaBactuary; 01-17-2019 at 06:31 PM.
    Reply With QuoteRegister To Reply
  2. 01-17-2019, 05:16 PM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: API VBA Code

    Hello
    Can you give more details about your problem?
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 01-17-2019, 05:19 PM #3
    wannaBactuary
    wannaBactuary is offline
    Registered User
    Join Date
    01-11-2019
    Location
    CHI
    MS-Off Ver
    2013
    Posts
    22

    Re: API VBA Code

    Sure! While I try and contribute elsewhere to get permissions to post the code in this thread, I have PM'd you the code.

    The errors vary, so I can't really specify where and what is going wrong. I am on a virtual server and it seems like some sort of resource is being exhausted.
    Reply With QuoteRegister To Reply
  4. 01-17-2019, 05:44 PM #4
    wannaBactuary
    wannaBactuary is offline
    Registered User
    Join Date
    01-11-2019
    Location
    CHI
    MS-Off Ver
    2013
    Posts
    22

    Re: API VBA Code

    Anyone know how many times you have to post in order to be able to post code? I've answered a couple questions on here and introduced myself
    Reply With QuoteRegister To Reply
  5. 01-17-2019, 05:49 PM #5
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: API VBA Code

    This is your code
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 01-17-2019, 06:10 PM #6
    wannaBactuary
    wannaBactuary is offline
    Registered User
    Join Date
    01-11-2019
    Location
    CHI
    MS-Off Ver
    2013
    Posts
    22

    Re: API VBA Code

    You're the man! Thanks for posting for me.
    Reply With QuoteRegister To Reply
  7. 01-17-2019, 06:12 PM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,448

    Re: API VBA Code

    There are no restrictions on posting code, only links. What happened when you tried?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  8. 01-17-2019, 06:13 PM #8
    wannaBactuary
    wannaBactuary is offline
    Registered User
    Join Date
    01-11-2019
    Location
    CHI
    MS-Off Ver
    2013
    Posts
    22

    Re: API VBA Code

    I was getting the message that I cannot post links, images, videos until I posted a few times. Not sure why that was happening with the code.

    edit: continue to get the same message
    Reply With QuoteRegister To Reply
  9. 01-17-2019, 06:15 PM #9
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,448

    Re: API VBA Code

    There must be something in the code that you are trying to post that the forum is interpreting as a link. Try again when you have at least 10 posts.
    Reply With QuoteRegister To Reply
  10. 01-17-2019, 06:30 PM #10
    wannaBactuary
    wannaBactuary is offline
    Registered User
    Join Date
    01-11-2019
    Location
    CHI
    MS-Off Ver
    2013
    Posts
    22

    Re: API VBA Code

    Ok thanks!
    Last edited by wannaBactuary; 01-17-2019 at 07:15 PM.
    Reply With QuoteRegister To Reply
  11. 01-18-2019, 02:57 PM #11
    wannaBactuary
    wannaBactuary is offline
    Registered User
    Join Date
    01-11-2019
    Location
    CHI
    MS-Off Ver
    2013
    Posts
    22

    Re: API VBA Code

    Any thoughts?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Web scraping issue - HTML code scraped in VBA differs from source code in the website
    By lubbamkt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2016, 12:25 PM
  2. [SOLVED] Need help with VBA code. Tons of code seperated in two, second part of code doesn't work.
    By FragaGeddon in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 11-30-2015, 11:46 AM
  3. [SOLVED] Pattern Building VBA Code - Working code, would like to use cleaner code
    By Benisato in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-10-2015, 03:05 PM
  4. [SOLVED] Excel VB code. Message pops up while code running asking question. Code must not wait.
    By Heinrich Venter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2014, 06:10 AM
  5. [SOLVED] VBA code for assigning a numeric code to text; then numeric code populates table
    By cteaster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2014, 08:01 PM
  6. [SOLVED] Pick up the Vendor code of a part code from looking the highest Qty of a part code
    By PRADEEPB270 in forum Excel General
    Replies: 2
    Last Post: 03-09-2013, 04:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1