|
Could somebody post vb script for an excel macro that does the following
1)Accept the Input i) a string and ii) a test file with path (say C:\ip.txt)
Output should be written to say C:\op.txt mentioning
how manu instances of the case sensitive string occurs in each line of the file
Eg: C:\ip.txt has the following lines and the search is for the string 'any'
any many
many anyone ANY
nany
Output file C:\op.txt should display
Line # Number of instances
1 2
2 2
3 1
2) Same requirement as above but string is non-case sensitive
3) Same requirement above but seach for a character and not a string
4) Same requirement as above but the Input is a word .doc file
instead of .txt file
5) What changes should I make to the code to run the macro from Word instead of Excel
Thanks
itnovice
|
|
|
|
|
itnovice wrote: Could somebody post vb script for an excel macro that does the following
You're kidding right? You expect this free, gratis, for nothing, zip, zero?
Besides - you should post this in the correct forum.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
Steve,
If you don't intend to help why do you even waste our time with your insults? Yes, there are many helpfull people here that will go out of their way to help others! That is what this forum is all about, one person helping another. I have gotten tons of help from great people on this forum and if I can help someone with my limited abilities I will. Yes, that is what this is all about. People helping other people FREE, GRATIS, FOR NOTHING, ZIP, ZERO except for the possible return of someone else helping them.
I have had people send helpfull code to me and I have sent code to others. I have never been charged for the help that I've received and I've never asked anyone to pay me. If you want paid then I think that you are on the wrong sight.
|
|
|
|
|
Garner T wrote: If you don't intend to help why do you even waste our time with your insults?
I do intend to help - but I'm not going to do ALL the work for them as has been CONSTANTLY been requested by many people on this forum.
Insults? I don't think I insulted anyone with my previous post? You'd certainly know an insult if I penned one.
Garner T wrote: Yes, there are many helpfull people here that will go out of their way to help others! That is what this forum is all about, one person helping another. I have gotten tons of help from great people on this forum and if I can help someone with my limited abilities I will.
I know - I am one of those people - if you just go back and check my post history. I'll admit though that the last few weeks have been skewed towards the 'unhelpful' posts due to the influx of people wanting a free ride.
Garner T wrote: People helping other people FREE, GRATIS, FOR NOTHING, ZIP, ZERO except for the possible return of someone else helping them. I have had people send helpfull code to me and I have sent code to others. I have never been charged for the help that I've received and I've never asked anyone to pay me.
Indeed I do help others - but only those who show that they are willing to help themselves (read my signature lines if you have not already). Posts like the one that triggered this tirade just don't cut the mustard. They basically demand that the work be handed to them on a platter. No way Jose - not from this little black duck. I also notice the lack of responses to this person's request for help. Looks like no one else was willing to do this guy's homework either.
If everyone actually read this post from Chris Maunder[^] there would be no need for me or anyone else to state the bleeding obvious everytime.
And while I'm at it, I am not the only person on this forum that thinks the same way. I am a little more vocal than most - and for the record have got it wrong at times and have apologised where appropriate - but I'm certainly not 'Robinson Crusoe'.
Garner T wrote: If you want paid then I think that you are on the wrong sight.
I'm already doing quite well thanks.  I do not solicit payment or any kick-back at all. I am happy to help those who need it, but only - and I do mean ONLY - when that person has shown that they are willing to get off their arse and help themselves.
Finally, unless and until I am told to sod off by the guys that run The Code Project, I will continue to help those in real need and reserve the right to crticise those that expect a free lunch.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
We would like to develop a windows application for a Samsung I700 PDA. The application needs to get data from a remote sql server.
Can anyone recommend any good starter articles for this type of project. The part I don't understand is how the PDA will get data from the remote database and store it locally.
Thanks for any help on this matter.
|
|
|
|
|
|
|
Compiler Error Message: BC30455: Argument not specified for parameter 'strBiaya' of 'Public Function DBAuthenticate(strUsername As String, strPassword As String, strTajuk As String, strObjektif As String, strSokong1 As String, strSokong2 As String, strBiaya As String) As Boolean'.
Source Error:
<br />
<br />
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As Handles Button1.Click<br />
If IsValid Then<br />
If DBAuthenticate(txtnama.Text, txttajuk.Text, txtobjektif.Text, txtsokong1.Text, txtsokong2.Text, txtbiaya.Text) = True Then<br />
FormsAuthentication.RedirectFromLoginPage(txtnama.Text, False)<br />
Response.Redirect("homelec2.aspx")
anybody can help?
|
|
|
|
|
If you compare the parameters in your call against the parameters in the function declaration, you see that you have missed the password parameter.
---
b { font-weight: normal; }
|
|
|
|
|
It means that DBAuthenticate requires 7 variables and you passed it six.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
The parameters in calling function doesn't match with
with called function parameters
Signature of ACtual paraments should match formalparameters
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
|
Note: message in English and Spanish
me you that in a console application the sub main () it exists for defect and it is the first point of entrance of the application, but like I can have a sub main () in a windows,siendo application this the first entrance point, to call doesn't unite video presentacion(un or image) before the main Form.
thank you
**************************
yo se que en una aplicacion de consola el sub main() existe por defecto y es el primer punto de entrada de la aplicacion, pero como puedo tener un sub main() en una aplicacion de windows,siendo este el primer punto de entrada, para llamar no se una presentacion(un video o imagen) antes de la Form principal.
Gracias
|
|
|
|
|
Auto translated text seldom give a correct translation. I added some apropriate spaces in your text and translated it using Babel Fish, and then it looks like this:
"I that in an application of console sub main() exists by defect and is the first entry point of the application, but as I can have sub main() in an application of Windows, being the this first entry point, to call not a presentation (a video or image) before the main Form."
It's slightly better, but still I can't tell from it what it is that you are trying to do, or what it is that you have problems with. Can't you try to translate it manually?
---
b { font-weight: normal; }
|
|
|
|
|
With what little spanish I can read, I think ronnie_leo wants to know how to go about creating a splash screen, or a form with an Image or Video on it before the main form loads.
If that is correct ronnie_leo, This may help:
http://www.codeproject.com/vb/net/quickguide.asp[^]
progload
|
|
|
|
|
I am working with three datagrids in VS 2003, visual basic. I am importing numerical data from an excel spreadsheet I select
using a show dialog and connect using an OleDb data adapter to import the selected data into datagrid1 and datagrid2.
The data is displayed on these two datagrids. Then I have a routine to add the first field in datagrid1 with the first field in datagrid2
and show the results in datagrid3. I notice that if I manually insert the values I get the proper results when I push the button but when
the data was imported and displayed to the datagrids, I only get zeros when I press the button. I even tried showing the results to
a textbox but I still get zeros. Basically, I want to perform some math operation from data imported from excel into two datagrids
and show the results in a third datagrid.
Any help is much appreciated.
|
|
|
|
|
I am using a Barcode ActiveX control downloaded from fathsoft but i have a trial version it expires after 30 days i have made a simple way to crack it but thats not the proper way can any one tell me of another control that can display barcode usin Code39 format. i have designed the whole IMS with that Need help please somone.
Everthing is Not what it seems!
|
|
|
|
|
hi to all ..
i am reposting my question agine , but this time in a better format ,
i wanna know how can get or count the rows in a datagrid when i have multi selection in it ..
thxx
|
|
|
|
|
Dim dgCount As Integer
dgCount = DataSet1.Tables[0].Rows.Count
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
|
hi everyone
I'm writing an applciation in wich I use a toggle button. On the button is a picture:
me.ToggleButton.picture = new bitmap(application.startuppath & "\afbeeldingen\min.png"
Now the button has to be set disabled on startup. So i write the following code:
me.Togglebutton.enabled=false
It works, but the picture on my button becomes a gray rectangle??? (so I don't see my picture anymore when disabled)
Anyone any ideas
thx in advance
|
|
|
|
|
Sure when u set enabled to false picture get grayed but try to set visiblity insetad enabled
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
Hi all,
am passing a varaible STD in an sql statement... its returning me type mismatch... DIM STD As Integer
ictRecordset.Open "select * from ICTConcepts where stdID = '$[STD]' ", myConnection, adOpenStatic, adLockOptimistic
help me plz
Arshaad
|
|
|
|
|
You can't use a VB variable in an SQL query, the database can't access the variables that you have declared in your program. You have to put the value of the variable into the string.
---
b { font-weight: normal; }
|
|
|
|
|
You can pass them with no problem. You just ned to format them correctly for example, if the value is an integer you pass it like this:
"select * from table where colID = " & IntVar & ""
if it is a string
"select * from table where Colval = '" & StringVar & "'"
There are more but i cant remember them all. If you google you should be able to find more.
Jon
|
|
|
|
|
Hi Arshaad,
Plz specify the database ur querying.
I think u'll need to check the datatype of the variable STD and the field stdID in the table ICTConcepts, and also ur connection that it is pointing to the correct database.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
