Word 2007 Automation using Tab Delimited Text File
$30-60 USD
Fullført
Lagt ut over 14 år siden
$30-60 USD
Betalt ved levering
? ? ? ? I need a VB.net application that Automates Microsoft Word 2007 based on the contents within a Tab Delimited Text File.? The Software will need to open an existing? Word 2007 Template and add rows to the main Table based on the number of unique material types from the Tab Delimited Text File.? ?
? ? ? ? After all rows have been added, the software will then sort through the tab delimited text file and input the values into the Word2007 template based on the Material .? ?
? ? ? ? The Last Column of the Main Table "Price/Weight" will need to be calculated based upon which ComboBox the Material came from.? ?
? ? ? ? For Example if my Material was "Tin" and "Tin" was an Item in ComboBox1 then the value inputed into the 5th column of the Word2007 template would be the (Total Weight/2000) / PricePaid & "/Ton"
If? "Tin" was? an item in? ComboBox2 then the value inputed into the 5th column of the Word2007 template would be the Total Weight/PricePaid & "/Pound"
If? "Tin" was? an item in? ComboBox3 then the value inputed into the 5th column of the Word2007 template would be the Total Weight/PricelPaid & "/Pound"
If? "Tin" was not an item in any of our ComboBoxes then the value inputed into the 5th column of the Word2007 template would be the Total Weight/PricelPaid & "/Pound"
There will be no more than 3 comboboxes to compare the items against the Tab delimited text file...
## Deliverables
? ? ? ? I need a VB.net application that Automates Microsoft Word 2007 based on the contents within a Tab Delimited Text File.? The Software will need to open an existing? Word 2007 Template and add rows to the main Table based on the number of unique material types from the Tab Delimited Text File.? ?
? ? ? ? After all rows have been added, the software will then sort through the tab delimited text file and input the values into the Word2007 template based on the Material .? ?
Word2007 Template
Column1 "Material"
Value will be the Unique Material Type found in Column 6 of the Tab Delimited Text File
Column2 "# Cust"
Value will be the the total number of times the particular material is listed in the Tab Delimited Text File in Column 6
Column3"Weight"
Value? ? will be the Unique Material Type? and all the values added for the particular material which is located in? Column? 7 of the Tab Delimited Text File
Column4"PricePaid"
Value? ? will be based on the Unique Material Type? and all the values added for the particular material which is located in? Column? 9 of the Tab Delimited Text File? ? ? ? The Last Column of the Main Table "Price/Weight" will need to be calculated based upon which ComboBox the Material came from.? ?
Column5 "Price/Weight" is a little more complicated
This Value will be based on which ComboBox has? the Material as an Item
? ? ? ? For Example if my Material was "Tin" and "Tin" was an Item in ComboBox1 then the value inputed into the 5th column of the Word2007 template would be the (Total Weight/2000) / PricePaid & "/Ton"
If? "Tin" was? an item in? ComboBox2 then the value inputed into the 5th column of the Word2007 template would be the Total Weight/PricePaid & "/Pound"
If? "Tin" was? an item in? ComboBox3 then the value inputed into the 5th column of the Word2007 template would be the Total Weight/PricelPaid & "/Pound"
If? "Tin" was not an item in any of our ComboBoxes then the value inputed into the 5th column of the Word2007 template would be the Total Weight/PricelPaid & "/Pound"
There will be no more than 3 comboboxes to compare the items against the Tab delimited text file...
After Inputting The Values into the Word 2007 Template the Word Document will be saved as a different file name...
The Whole point of this project is to be able to make a report based on a Tab Delimited Text File and an Unknown amount of Unique Material Types located within it, My current application is limited to the number of Material Types which has become unsuitable...
This Project must be completed in VB.Net and must include all Source code.? Code must be extensively documented...? I've included A VB.Net Project to uses as a template as well as a report created using my application and its corresponding tab delimited text file. I've also included a Word 2007 Template named "NewTemplate" of which I would like to have used for this project...