What i am trying to do is this. I have a file1 box on my form. Is there a way to eliminate the file extention.
example:
test.doc
note.exe
look like
test
note
now I don't know if this is easier but I need a loop for textbox
I want a loop command that goes to the first word (which in this example is test.doc) copy word into textbox then another code will run. not sure what yet. Then go to the next word (note.exe) and copy it to the same text box and so on. It doesn't matter to me if the extension is knocked of in the filebox or textbox. I just has to be eliminate for the textbox.
Is this a possibility??
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
no, way off. I am sorry.
I have a filelistbox. That is directed to a directory. What I need is a way to have it go to the first name and copy it to the textbox. Then go to the next filename and copy it to the text box without file extention. And so one until no filenames exist. Has nothing to do with a combo box. Again I am sorry. Can you help.
kwalk,
A request has been made in Community Support to close this question:
http://www.experts-exchang
Asker found his own solution. If there are no objections, after 72 hrs, a moderator will finalize this question by:
- Saving this Q as a PAQ and refunding the points
Please leave any recommendations here.
Best regards,
YensidMod
Community Support Moderator @Experts Exchange
Business Accounts
Answer for Membership
by: kwalkPosted on 2003-07-21 at 20:37:56ID: 8973148
Are you using a textbox or a combobox? Are you trying to fill the list of a combobox?
How are the file names being stored? Are we looping through an array that you have already filled? Or a Dir$ function?
Once we have those specifics, I can answer that better.
But you'll basically be looping something like this (I'm guessing you're adding items to a combobox?):
Dim strFileName As String
Dim x as long
Dim strTemp as string
Dim lngPosition as long
For x = 1 to Ubound(strArray) (not sure what you're looping, but I'll assume an array)
strFileName = strArray(x)
'locate position of period (from right)
lngPosition = InStrRev(strFileName, ".")
' Check to see if it qualifies as an extension (assuming extension will always be 3 chars long)
If Len(strFileName) - lngPosition = 3 Then
strTemp = Left$(strFileName, lngPosition - 1)
Else
' not sure what to do with this - it doesn't have the "usual" extension
strTemp = strFileName
End If
combobox.additem strTemp
Next x