password to VBA macro is 'emerson'
I have a buggy VBA script that scrapes information from Bloomberg. I dump the output to a text file that I parse with a perl program and format to excel.
The problem is the VBA script is unreliable. For example, if I ask it to pull information from bloomberg for 10 companies, it might succeed with 1 and get only partial information for the other 9.
I need this script fixed.
The excel file with the VBA macros is at [[login to view URL]~bda/suraj/][1][[login to view URL]][1]
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
If you can fix the VBA script so that it works 100% of the time, that would be fine. I would prefer if you could can the VBA part and do the whole thing from perl. I have left a lot of info about the project out. Examining the excel file above will show you the intended output. I will make the project much clearer when I receive bids from people who have access to Bloomberg.