+ Reply to Thread
Results 1 to 5 of 5

Macro not available

  1. #1
    Registered User
    Join Date
    08-17-2015
    Location
    Reading, England
    MS-Off Ver
    2013
    Posts
    4

    Macro not available

    Getting this error message

    http://i.imgur.com/6m87hLg.png

    I need it to refresh the command every 30 minutes, and the rest of the code seems to be working. Is there an easy way to solve this? If not, I will need to divulge a bit into what this project entails
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    08-17-2015
    Location
    Reading, England
    MS-Off Ver
    2013
    Posts
    4

    Re: Macro not available

    I think the person in this thread might've encountered a similar problem. Can someone please help

    http://www.excelforum.com/excel-gene...-workbook.html

  3. #3
    Registered User
    Join Date
    08-17-2015
    Location
    Reading, England
    MS-Off Ver
    2013
    Posts
    4

    Re: Macro not available

    Bump. Need this answered.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,731

    Re: Macro not available

    I need it to refresh the command every 30 minutes,
    What command? What are you doing?

    and the rest of the code seems to be working.
    How do you know the rest of the code is working?

    Is there an easy way to solve this?
    Based on the information provided, who knows?

    If not, I will need to divulge a bit into what this project entails
    Probably would have saved yourself some time if you'd done that in the first place

    I would suggest that you post a sample workbook with some typical but non-sensitive data ... and the code in place in the workbook. Please explain the process that you are trying to set up.




    To attach a sample workbook: Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Registered User
    Join Date
    08-17-2015
    Location
    Reading, England
    MS-Off Ver
    2013
    Posts
    4

    Re: Macro not available

    Okay, sorry for the vague first post.

    Basically I am using an XML feed, for which I am hoping to get data every 30 minutes. I have 5 headers, including a Date+Time one. When I hit the command button, the first set of data appears between A2 and E14, as expected, and I am hoping that after every 30 minute refresh, this new XML data will appear in the cells directly underneath.

    I don't know for sure that the rest of my code is working, but when I hit the command button, the first set of data appears and only after 30 minutes, an error occurs. Also, everytime I cancel after the error, then click the command button once again, the new set of data appears where it should (A15 to E27 etc etc). It is a problem around the RefreshXML function.

    9b5965beba4dd0ca5ebcbbda27de51c4.png

    I have replaced all the data (not that it really mattered, but to be safe). So every 30 mins, I am hoping to refresh the XML and the new XML data should appear in A15-E27. One necessity is every time the XML refreshes, the Time/Date are posted in the 5th column, as you can see.

    I'll upload an attachment aswell, and I've tried to desensitive the data as much as possible. The attachment will hopefully show a Before and After, but it may be hard to replicate. I've changed the refresh time to 1 minute, so I didn't have to wait 30 to see if the error message shows. I hope this helps.

    Excel Forum.xlsm

+ 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. Using a macro on workbook1 to create a button in wb2 and assigning macro "wb2!macro"
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2014, 11:39 AM
  2. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  3. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  4. Macro using file dialog opener - Cannot delete or rename folder when excel macro is
    By startrekremo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2011, 01:57 AM
  5. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  6. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 AM
  7. Macro calling another Macro: "The macro 'Personal.xls!FindChar"
    By William Benson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2005, 09: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