We are looking for someone with experience writing VBA code or script in MS Excel 2003.
The VBA code would be in the form of a macro accessible via an Excel spreadsheet.
We need the VBA code to be able to open a specific .html or .php file and scan the HTML code to parse some strings, perform some simple math and copy the results into an Excel spreadsheet. The HTML file consists of a fixed set of underlying code that contains inventory from our local vendors. The HTML code does NOT need to be changed. We just need it to be read by the VBA script.
The VBA script needs to look for specific part numbers that are already in the HTML code. The part numbers are searched individually. For each part number found, what follows is a block of code that shows the names of our vendors who carry the part and the quantity they have in stock. There are usually several vendors who have the part number in stock.
There would be a specific list of vendor names to search for and this list would likely have to be included in the underlying VBA script. If the vendor name is located, the quantity would be parsed and added to a variable. If the vendor name is NOT located, the script would move on to the next vendor name and if found, parse the quantity and add it to the previous quantity and so forth. Vendor names will be listed in the HTML code as long as they have at least quantity 1 of the part number in stock.
Looking at the HTML code, the unique string “Part #: “ (no quotes) seems to proceed each block of code for a particular part number, for example, “Part #: X1563”. Note that there is a space between the colon and the first character of the part number. What follows is the name of a vendor in a unique string in the form “>Flagship Technologies<” (no quotes). The quantity is always proceeded by the code “<td align="right" class="search">X</td>” (no outer quotes) where X is the quantity as an integer.
So it would seem to us that the VBA script would have to look for the part number following “Part #: “ and perform a loop operation to scan the rest of the code in that block to look for each vendor name on the list and then parse the quantity for that vendor and add it to the quantity variable. The end of the search for that part number would be when another “Part #: “ string is reached containing a different part number. Prior to moving to the next part number, the VBA script would put the part number and the total quantity of all vendors for that part number on a single line in an excel file. The VBA script would then proceed to the next part number and the process continues until the end of the file. There would be hundreds to thousands of part numbers to process. The result is an Excel file with hundreds to thousands of lines. Each line is a part number and quantity. The vendor names to NOT need to be copied to the Excel file.
I have included a sample file of the HTML code to parse called main.php. This file would be included on the hard drive of the computer that is to run the Excel VBA script.
I believe the VBA script would start something like the following, although there might be a better way.
Dim FilePath As String
FilePath = "C:\Users\[url removed, login to view]\Desktop\[url removed, login to view]" 'the path to the HTML file to parse
Open FilePath For Input As #1
row_number = 0
Do Until EOF(1)
We would like to pay a one-time fixed price to get this project completed in about a week or so.
29 freelancers are bidding on average $183 for this job
Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [url removed, login to view] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..
Hi, I have lots of experience with automation in Excel using vba macros or with php and can help you in short terms with this project. I will work on a demo with provided requirements.
Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat Mere