|
I'm currently writing a program that is going to analyze Excel files that we receive from clients. However we have been running into a problem that some people are sending files that contain Excel 95 (BIFF7) data. Unfortunately the tools I use to process the files only support BIFF8 or higher. Is there any command-line utilities that I can use to convert all files to the BIFF8 format? I tried using gnumeric but I haven't been able to get it to work, plus it is a little overkill because it is a complete software suite. Office automation is not an option due to the volume of data. Any suggestions would be greatly appreciated...I know there has to be a command-line program out there that can do this. BTW I would be interested even if it is a commerical software, as long as the price is reasonable.
Thanks in advanced for any help.
|
|
|
|
|
You "know there has to be" something that supports the 16 year old Excel 95 format? Don't bet on it. I can't find anything that supports Excel (BIFF7) that old. I don't think they'd be using Excel 95, but may unknowingly be saving the files in the Excel 95 format in a later version of Excel.
As for the conversion, I think you're going to be stuck with the automation method.
|
|
|
|
|
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.
|
|
|
|