Convert Macros to VBA Office Automation for Read-Write Allocations to Multiple Files
$30-5000 USD
キャンセル
投稿日: 15年以上前
$30-5000 USD
完了時にお支払い
Convert the following Excel Macro Project to Office Automation
The attached file [login to view URL] contains the allocation hierarchy, the Column Area GO with the X on the row for a store indicates the store that values will be taken from and the other stores in the same group are the stores that the amounts will be allocated and put to. The macros in the [login to view URL] illustrate the allocations to be made.
What you would do is read through the macros found in the [login to view URL] and rewrite those in Office Automation and then write a master page based on the file [login to view URL] so that the user can click one button and apply all allocations or select one as described in the sheet Automation Method Master Page. Buttons on the top row execute all allocations as labeled. Buttons in the area rows execute the allocations for that area. The button in the All Allocations column executes all allocations for the area. The button in the specif allocation column executes that specific allocation.
Create the Summary of Allocations on the Automation Method Summary sheet. The old summary Macro Method Summary is only in the file for reference.
If you want to do the project in two phases you can create the automation code for the “All Allocations All Areas?? column and then do the column for each individual allocation and the "Automation Method Summary" in another request to be posted later.
## 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
Excel
Microsoft Office
VBA