Hi all,
Having some problems with some code that is no longer working as it should. Has been working fine for a while and suddenly it has issues. The workbook downloads a bunch of stock tickers from Yahoo and then formats the results. The original workbook was downloaded from Invest Excel and the sub that exchanges information with Yahoo came with the download. I have tweaked it so that it can download multiple tickers and then format in a way that I can do further searches through the data.
Issue 1: It seems that Application.Screenupdating has stopped working. Initially I have a Application.Screenupdating = False and in the subs that are called from the main sub I do not have any Application.Screenupdating =True in them so it should not be set back to true until the end of the main sub. This is not occurring. Any suggestions?
Issue 2: When I am downloading numerous tickers sometimes I get a random error, generally on one of these two lines of code:
which is in the main sub. The reason I use a paste special is because downloading form Yahoo attaches a lot of links to the data that I do not want and when you download multiple tickers rapidly increases the size of the workbook. This is why I also delete the Data worksheet when finished in the main sub, or:Please Login or Register to view this content.
in the delete columns sub.Please Login or Register to view this content.
When I click ok to the message generated form either of these lines I get a DDL 'COMCTL32.DLL' could not be loaded msg and when I click ok to this I get an out of memory warning.
I have been using this code for many weeks and it has been working fine so finding it very frustrating as to why it would cease to work.
Any suggestions would be much appreciated.
Cheers,
Marcus
Bookmarks