So I need a tool, I am going to explain it in complete depth :
1. I need a interface where I should be able to give the following data:
[login to view URL] Name & Other Project related details
[login to view URL] to locally saved excel sheet which contains the test details
[login to view URL] to the locally saved different word document. There can be word doc from 10-15 so for every doc file path there should be a text box where I can place the path also along side every doc file there should be an option to put a denotion name for the doc. For example doc1 can be entered as "DC1-" and so on.
[login to view URL] these details are filled and the submit button is clicked the tool should pull the template excel sheet(which is already made) and fill in the details as follows.
[login to view URL] Sheet 1 of the excel sheet it should fill the project details in correct cells.
b. In Sheet 2 it should pull data from the locally saved excel sheet and paste accordingly.
c. In Sheet 3 it should pull the Table of content from the doc file and paste accordingly.
3. Once all the pasting is done, the tool must run a macro which is in Sheet 2 and then throw the excel workbook out with a particular name as per the project name.
The good news is ai have already written the VB codes to pull the data from locally saved excel sheet and locally saved word doc. It just needs to be soft coded so that it can take up any document path and work accordingly.
Please let me know what it will cost and we can talk about other stuff later.
12 freelancers are bidding on average ₹2753 for this job
Hey I am not that great with visual basic ... I have understood the requirements and I can help you with the application ... and I will building the web application ...