Read .csv data without opening in excel

Hi,

I am looking for help in doing the below things

If ap.csv has Positive Netqty then InputBox
In InputBox Stock Name will be there & That InputBox will only be closed by putting paasword

& Code will not Open Ap.csv in Excel
ap.csv will not be opened in excel

so plz help me in solving this problem

in the below file Vedl has positive netqty So inputbox will come & in that inputbox Vedl name will be there

Thnx For the Help

try

Please Login or Register  to view this content.

Originally Posted by Leonardo1234

Jindon Sir plz Hardcode the path in the code
C:\Users\WolfieeeStyle\Desktop\ap.csv

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Originally Posted by Leonardo1234

Instead of msgbox I need a inputbox like below inputbox

Pass = InputBox(" < Result > " & vbLf & x(0, i) & " : " & x(1, i)

Do While UCase(Pass) <> UCase("U")
Pass = InputBox(" < Result > " & vbLf & x(0, i) & " : " & x(1, i)
Loop

No idea about what you are trying to say.

Thnx Tms Sir Path Problem is Solved
ut Msgbox Problem is there ,I need inputbox Only If It has positive Netqty
Suppose It doesn't has positive Netqty then no inputbox,no msgbox

Jindon Sir If It has positive Netqty then the code create msg box But i need inputbox
And if It doesn't has positive Netqty then the code Create a msgbox But i dont need msgbox & inputbox when It doesn't has positive Netqty

Still no idea.

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thnx Alot Jindon Sir
Have a Lovely Day Sir
Problem Solved

Hi I am having problem in the below lines , Getting runtime error 70 ,permission denied
Error Highlighted line-

Please Login or Register  to view this content.

Please Login or Register  to view this content.

you need to close both recordset and connection objects before Kill statement.

I putted

Please Login or Register  to view this content.

Code ran perfectly

But I haven't closed rs.close
Will it be fine if I don't put rs.close ?

& When I put rs.close I got error runtime error 3704 operation is not allowed when object is closed

Got it

Please Login or Register  to view this content.

Thnx Alot Jindon Sir For giving ur Precious Time
Have a Great Day