I'm stumped on where to go next.
I am retrieving information from a system and need to input the 3 data variables it gets into specific cells in the open spreadsheet the spreadsheet being used has the code. This is what I have so far. I can get it to get the information but do not know how to get it to write it into the open sheet. TIA
Goto_GEMTS_Screen "W1D", 6, 17
While Not EOF(InputFileNo) 'While not at the end of the file loop
Line Input #InputFileNo, InputToData
Wo = GetField(InputToData, 1, ",") 'Use's work orders from a .csv file
PutStringEOF Wo, 5, 24 'Inputs work order to the system
HitEnter
GetString Wo, 5, 24, 8 'Work Order Number
GetString PD, 6, 24, 47 'Problem Description
GetString PR, 12, 24, 1 'Priority
Sheets("Finalized").Select
Range("b3").Select
--- This is where I need it to input what it is pulling-----
Wend
Bookmarks