Hi all,
I got some help from DonkeyOte a while back to help extract data from my ERP database, using info available in my Spreadsheet...
http://www.excelforum.com/excel-prog...variables.html
Try to adapt it a little to another spreadsheet I am working on, but can't seem to nail it.
Here is the code I have changed around from the above thread..
The red items are the one's I have changed...![]()
Please Login or Register to view this content.
The data I am trying to reference on my worksheet is in column C and consists of text like: WB0507-10
I need to separate that into 2 separate variable to link to 2 fields in the OPERATION table... the first field would be for WORKORDER_BASE_ID and should be B0507, the second for SEQUENCE_NO should be 10...
These 2 variable are looked up to return the USER_1 to USER_10 fields.
The code runs, but returns no results at all, and I can't figure out where I have gone wrong... the MID() functions should be extracting the info correctly.. I think...
Bookmarks