Getting this error message
\1
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
Getting this error message
\1
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
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
Bump. Need this answered.
What command? What are you doing?I need it to refresh the command every 30 minutes,
How do you know the rest of the code is working?and the rest of the code seems to be working.
Based on the information provided, who knows?Is there an easy way to solve this?
Probably would have saved yourself some time if you'd done that in the first placeIf not, I will need to divulge a bit into what this project entails
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 - Retired Excel/VBA Consultant
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks