So I have done some reading and began construction of my macro. As of now, I have accomplished the following
- Open specified drawing file
- Activate Sheet with BOM
- Activate the BOM
- Find the column headers "PART NO." and "QTY." and their corresponding column numbers
- Find the last row that contains data
- Store the data in those two columns in an array
- Created a text file to store the values in the array
Entire code is attached.
I now need to put the array values into the created text file, but I am not exactly sure how. Can anyone help me with this?
I know this is not necessarily a forum for asking coding type questions, so please let me know if there is a more appropriate forum to seek help on my visual basic needs.