Open Password Protected Lotus 123 (ver 1.2) files and save as .csv

[bud31047]

I have been tasked with trying to find a way to convert 3,000 + password protected Lotus 123 (ver 1.2) spreadsheets to csv. The password is the same for each file and known. Each file is an employee attendance calendar and has been saved like 12345678.909 (employee SSN & year).

Is this possible to do with vb.net? Any suggestions?

 

[Andrzejek]

Are you able to open any of your Lotus files in Excel?

If you can, you can use Excel object to do what you need.

Have fun.

---- Andy

 

[bud31047]

Excel will not open them because they are PW protected. I even downloaded Lotus Symphony, but it wouldn't open them because of an unrecognized file extension.
I will take a stab at using .net with an Excel object to open them. I will provide an update when I can.

 

[Andrzejek]

You may try just the 'quick and dirty' way of [tt]SendKeys[/tt] from VB.NET application to start Lotus and then send appropriate keys to open the files, provide passwords, and save them as csv

I hope somebody else will have a better idea than mine……


Have fun.

---- Andy