Thread: How can I make Excel read a value from a textfile and assign it to a variable in my VBA code??
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
haakon haakon is offline
external usenet poster
  
Posts: 3
Default How can I make Excel read a value from a textfile and assign it to
Open fName For Input As #1
Do While Not EOF(1)
Line Input #1, LineofText
rw = rw + 1
if rw = 58 then
sStr = LineofText
exit do
end if
Loop
Close #1

This worked perfectly, cheers :)

Reply With QuoteReply With Quote