Search:

Thx jayinthe813! Your suggestion works, but there is one problem though. I must recalculate RMS for each row because it isnt static as the value will change for each row. Like in my picture. 122941

Hi all!

I got a datagridview with values in a col named "INJ1". I want to add one column with the RMS value from each row in "INJ1". Sometimes it can be a LOT of rows. The formula for Excel looks...

Private Sub CreateTable()
Dim con1 As New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & Application.StartupPath & "\projekt\" & prjNameTxt.Text & ".mdb;Jet OLEDB:Database...

TY jmcilhinney! I tried with OLEDB instead as you told me 2. Now it seems to read the data as i want. Here is my connection now:



Dim MyConnection As System.Data.OleDb.OleDbConnection
...

Hiya!

Im using this code to populate a datagridview:


Private Sub PopGrid(ByVal Filename As String)

Dim ConnectionString As String = "Driver={Microsoft Excel Driver...

Please be kind. This forum IS for helping each other. He didnt ask for code, did he??

Someone else??

Sorry, i will show more of my code.



Dim Countnr As Integer
For x = 0 To ListBox1.Items.Count - 1
ListBox1.SelectedIndex = x
File =...

I got this code:



If File.Contains(Searchwhat) Then
Countnr = Countnr + 1
VinBox.Items.Add(filename)
...

I want to look for a char in a cell with a big string and return true if found. In VB.net we have the excellent ".contains", how should i do in VBA?? (Excel) :confused:

Koolsid> Your code did the trick. Thx alot m8.

Excel 2007
I got an Excel sheet with 2000 rows. Each cell looks like:



Sometext
Somemoretext


What i want is:

On my work, we have an application that picks together some files. And with that files the app create a *.zip-archive. It will also add a file to that archive with fileextension *.tbl. If i open that...

Of course, didnt even think about that. Thx alot!!!!

I got a string like "HOE KOP MUT WER HYT LIT POK GHU". I know how to write that out to a textfile, but i want it like this when i am about to output it to a file:
HOE
KOP
MUT
WER
HYT
LIT ...

Well, you saved my ass once again. I owe you a beer. Thx again m8. :thumb:

I know how to step in sheets with (for example):



Sheets(4).Select


Lets say i want to step to next sheet, then i want to know wich number that is active at the moment. I dont know how to...

anhn> Your code did the trick. Thx alot m8.

Well, i was not clearly maybee. I do not know the sheetname, the string i search for can be on any sheet.

Hiya! I recorded this macro (excel 2007) when i searched through whole workbook.




Sheets("Sheet2").Select

Cells.Find(What:="four", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
...

You have to install VB.net, and then compile his code from that.

Ehhhh, ok??

You can also have alook at my sig. I describe how you can play resource sounds.

Or you can just use:



My.Computer.Audio.Play(My.Resources.Hit, AudioPlayMode.Background) 'Hit is the name of embedded soundfile.

Please have a look in my sig for playing embedded sound....

I recommend you to have a look at this site. It will show you some interactive stuff about alot of stuff. ;)

http://msdn2.microsoft.com/sv-se/vbasic/bb466226(en-us).aspx

Gaaah!!! jmcilhinney, you must correct me everywhere??? :o ;)

Nice explained as usual. Thx jmcilhinney.

I guess a Contextmenu will do it for ya. Have a look here.http://www.vbforums.com/showthread.php?t=491896&highlight=contextmenu

Ok. Looks like a work for a vbguru. And im not ;)

Look at my sig. :D

Ok, dont know exactly what you mean. But you can download your page like this:


My.Computer.Network.DownloadFile("https://bannerweb.avc.edu/avcprod/az_tw_zipsched.P_search", "c:\temp.html")

Interesting. So what you mean is that "application.startuppath" is not needed anymore??

Its not working because there is no valid path to store the file. Try:

My.Computer.Network.DownloadFile("http://webpage.com/index.html", "c:\index.txt")

Or you might have a look at my sig. That code works with all game i have tested.

Noone??? :(

I cant for my life figure out how to do this.



For i As Integer = 0 To ListBox1.Items.Count - 1
Dim Comp1 As String = ListBox1.Items.Item(i)
Dim Comp2 As String =...

Yes you can, just type "icon" in the searchbox. :wave:

ROFLOL Sorry bout it uaeXuae. Did not ment to break your thread. :lol:

I will not share that info. :p If uaeXuae wants to share it, then you have to ask him. :wave:

stanav> Did u recognized the icon??:bigyello:

Oh, and that icon next to your clock, whats that??? Think i've seen it somewhere. :rolleyes: ;)