Solved

Instr() error!!

Posted on 1998-06-13
5
282 Views
Last Modified: 2008-03-06
Hello
I try this, but gets an invalid procedure call or argument.
Do YOU know what I am doing wrong??


front = FreeFile
Open App.Path & "\temp\" & "file000.htm" For Input As #front

Do While Not EOF(front)

  Line Input #front, forside
  forside = LCase(forside)
  anker = InStr(0, forside, "<a href=")
  If anker < 0 Then
    ref = Mid$(forside, anker, InStr(anker, forside, ">", vbTextCompare) - anker)
  End If
 
Text1.Text = ref
Loop

---
that's it
0
Comment
Question by:freak022398
  • 2
  • 2
5 Comments
 
LVL 2

Accepted Solution

by:
marti earned 40 total points
ID: 1463224
anker = InStr(1, forside, "<a href=")
0
 

Expert Comment

by:topol
ID: 1463225
Where does it say it happenes?
What line?

0
 

Author Comment

by:freak022398
ID: 1463226
yep, that line.

No error now, but no input either....in the text1.text
??
what to do?
0
 

Expert Comment

by:topol
ID: 1463227
Try to put forside=Str(forside) before Instr function.
And whether reject or accept marti's question.
0
 

Author Comment

by:freak022398
ID: 1463228
ok marti
got it working
thanks!!
/freak
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now