|
If the files can be opend with an actual Excel Release, you can use the Interop Libs.
Another idea: google for "smartxls", there is a trial version, maybe it can read/write this old files (I didn´t try it with that old files)
I cannot remember: What did I before google?
|
|
|
|
|
Hello everyone,
I'm in a VB6 project where I intercept when you press the key combination ALT + F1 in an external application, and then run some code, right after I return the combination ALT + F1 to external application.
I have searched for a week, and all I can intercept and send keys through the common API.
Thanks.
|
|
|
|
|
Since this is for an external application, you'd have to implement a global keyboard hook. This would intercept the Alt-F1 key system-wide, not for just one application. You cannot target just a single app's keyboard input.
I do not have any examples in VB6. You could easily Google for them though. Just search for "VB6 global keyboard hook[^]".
|
|
|
|
|
Thanks,
I understand, but until I found several examples of hook, but did not find any examples for sending to or interception of the combination ALT + F1.
|
|
|
|
|
You won't find any examples specifically dealing with Alt-F1. Keyboard hooks capture ALL keystrokes. It's up to your hook code to handle only the keys it's interested in and send the rest down the line to the next hook in the chain.
Whether your code wants to eat the Alt-F1, modify it, or just know that it happened, you don't say.
|
|
|
|
|
Hi friends,
I'm doing final year project. It titled as Speech door access system. I'm implementing the project in
Microsoft Visual Basic 2008 Express. Anyone can tell what the code to set the parallel port. I need the
code which will send the password I spoken to the magnetic lock through circuit. Please help me regards
this..........
|
|
|
|
|
It totally depends on how the magnetic lock works, what the pinning is, etc. Do you need to pull up other pins before sending data etc etc.
I would keep clear of the parallel port, as they are getting pretty rare now.
The better option would be to interface the door lock via an arduino or other small micro and communicate with it via the serial/usb port. the arduino would then control the lock.
If you really must use a parallel, then see this codeproject articl. I/O Ports Programming (Parallel port) Reading / Writing + Surveillance System using VB.NET[^]
Enjoy
|
|
|
|
|
If all you need is one or two output lines (and possibly one or two input lines), I would not choose the parallel port; I'd rather use the control lines of a serial port, and the SerialPort class, which is available in .NET since 2.0
And I suggest you avoid damaging your motherboard by performing all development on an USB-to-RS232C cable, which is cheap, easily replaceable and very well compatible with regular serial ports. Here[^] is but one example.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Hi,
Umm if you need to use a parrallel port I would recomend the <www.lvr.com> web site by Jan Axelson while her book Parraellel Port Complete LakeView Research ISBN 09508191-5 is good it only really covers VB6, which if you have access to VB6 would be good as I'm guessing you could go through the update process to .NET. As others have said parraellel ports are getting rarer & rarer!
Glenn(!)
|
|
|
|
|
Hi,
I have a select query like this
But from the below codes, I cannot update t2.unit_price in the same SqlDataAdapter
My Codes :
--------------------------------------------------------------------------------------------------------------------------------------
Dim MyQuery1 as String="Select t1.item_id,t1,group_id,t2.unit_price from Table1 t1 left outer join Table2 t2 on T1.Item_ID=T2.Item_ID"
Dim DAp1 as SqlDataAdapter,Ds1 as New DataSet
Con.Open()
DataAdapter1=New SqlDataAdapter(MyQuery1,Con)
DataAdapter1.Fill(Ds1)
Con.Close()
Dim Sav1 As String = "insert into table1 (item_id,group_id,????????unit_price) values (@item_id,@group_id,?????????@unit_price)"
Dim Sav2 As String = "update table1 set item_id=@item_id,group_id=@group_id,???????unit_price=@unit_price where item_id=@item_id"
DAp1.InsertCommand = New SqlCommand(Sav1, con)
DAp1.UpdateCommand = New SqlCommand(Sav2, con)
With DAp1.InsertCommand.Parameters
.Add("@item_id", SqlDbType.VarChar, 15, "item_id")
.Add("@group_id", SqlDbType.VarChar, 5, "group_id")
??????????? .Add("@unit_price", SqlDbType.Decimal, 18, "unit_price")
End With
With DAp1.UpdateCommand.Parameters
.Add("@item_id", SqlDbType.VarChar, 15, "item_id")
.Add("@group_id", SqlDbType.VarChar, 5, "group_id")
???????? .Add("@unit_price", SqlDbType.Decimal, 18, "unit_price")
End With
con.ConnectionString = ConStr_2
con.Open()
Dim Trans1 As SqlTransaction
Trans1 = con.BeginTransaction
DAp1.UpdateCommand.Transaction = Trans1
DAp1.InsertCommand.Transaction = Trans1
Try
MyDataGrid1.CurrentCell = MyDataGrid1.FirstDisplayedCell
MyDataGrid1.EndEdit()
DAp1.Update(Ds1.Tables(0))
Trans1.Commit()
Catch ex As Exception
If Not Trans1 Is Nothing Then
Trans1.Rollback()
End If
MsgBox(ex.Message)
End Try
con.close()
-------------------------------------------------------------------------------------------------------------------------------------
From the above codes
Dim Sav1 As String = "insert into table1 .........."
I don't know how to mention table2 also there ?
Thanks For The Ideas
Thanks and Regards
PARAMU
modified on Monday, February 28, 2011 10:42 AM
|
|
|
|
|
Please edit your original post, and wrap the code in a code block with correct lang attribute,eg. pre lang="vb" it makes it a whole lot easier to read.
|
|
|
|
|
Thanks Dave...I learned many things from you... And also Iam posting as new thread.
|
|
|
|
|
Don't post another thread, you get flamed! Go and delete the new one and leave this one here.
|
|
|
|
|
Thanks Dave...........I deleted the other one and also I need your guidances.
Thanks For All Guidances...
|
|
|
|
|
If I understand what you're trying to do, you can't do it using a DataAdapater. You can only work on queries that involve a single table. You'll have to update your tables independently, using two different queries. By the way, your table names suck. "table1" and "table2" are hardly descriptive of what they contain and actually make it harder to understand what your code is doing.
|
|
|
|
|
Dave Kreskowiak wrote: "table1" and "table2" are hardly descriptive
Nah. Maybe table1 is full of ones, table2 full of twos.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Thanks Dave..I get clear... I will update by seperate query...
Thanks & Regards
PARAMU
|
|
|
|
|
Hi,
I am sending mail from my vb app using CDO with out any issues. One of my client, they does not have internet connection in the client machine. They have configured through proxy setup. I've added below two line in existing code to support for proxy.
oField = oFields["http://schemas.microsoft.com/cdo/configuration/urlproxyserver"];
oField.Value = "itgproxy";
oField = oFields["http://schemas.microsoft.com/cdo/configuration/proxyserverport"];
oField.Value = 80;
I've confirmed that the passed proxy details are correct. And I got the error "Transport failure".
If anybody have an idea / experience on this please share with me, it will be a valuable help for me.
Advance Thanks,
Regards,
Rishi
WinCrs
|
|
|
|
|
As per my observations I need to set the proxy credentials. How do I can do this?
WinCrs
|
|
|
|
|
You can't. Proxies that require authentication are not supported. You'll either have to have a proxy that is open on your end or some path to bypass the proxy entirely. You're Network Admin would have to get involved with something like this.
|
|
|
|
|
Hi All,
I am using the following line hardcoded in my vba code in excel file.
D:/PISL/Input/<filename.xls>
My problem is, in the above line instead of giving D: i should give only PISL/Input/<filename.xls>, this can exists in any of the drives like c:, d:, e:, etc.,
Please help how to configure the drive name.
Thanks in Advance,
Regards,
|
|
|
|
|
priyaahh wrote: Please help how to configure the drive name.
You could save the driveletter-prefix as a Setting[^]. Once saved, use GetSetting to read the drive and concatenate your directory-string
I are Troll
|
|
|
|
|
I have a whiteboard measure 77 x 100cm and i used picturebox in vb6 to be my whiteboard on software side.Can anyone help me to make the picturebox scale the same as my whiteboard in vb6 because i dont know how to scale it.
|
|
|
|
|
You know the area available for the PictureBox .
So a little simple math will provide you with the answer.
1. obtain a Scale Factor by dividing the width of your area by the width of your whiteboard (770mm), or the height of your area by the height of the whiteboard (1000mm)
2. the width for the PictureBox will be 770 * the Scale Factor from above.
3. the height will be 1000 * the Scale Factor.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
|
|
|
|
|
Further th what Henry says; if you want the picture to remain proportional then only apply the lowest of the 2 scale factors to both the Height and Width.
|
|
|
|