Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Set xlApp = New Excel.Application Set xlWbk = xlApp.Workbooks.Open("C:\EMR\drv_patient_list.xls") Set xlWks = xlWbk.Sheets(1) arv = xlWks.Range("A1:H" & xlWks.UsedRange.Rows.Count).Value lngRowCount = LastRowInSheet(xlWks) ReDim arrData(1 To lngRowCount, 1 To 3) For i = 2 To lngRowCount For j = 1 To 3 arrData(i, j) = xlWks.Cells(i, j).Value Next j Next i xlWbk.Close False xlApp.Quit
|Why am I getting "No Duplicate Values Found" on this spreadsheet when there very clearly ARE duplicates?||12||176|
|VB6 Compile Compatibility Issue||4||102|
|bit defender blocks good applications||2||93|
|Windows Script Host failed (Access is denied.) error||6||144|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!