Search:
Type: Posts; User: Libero
Search:
Search took 0.36 seconds.
-
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??
-
-
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.
-
-
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 ;)
-
-
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.
-
-
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: ;)
|
Click Here to Expand Forum to Full Width
|