Home > Archive > Visual Basic > October 2004 > lotus 123
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| lezaic zivko 2004-10-28, 8:55 am |
| I have to reed some data from lotus 123 file, but I can't find procedures
and sintaxes for opening file and selecting cells.
| |
|
| I would be very suprised if MicroSoft provided programming methods to read
in files from a competitors obsolete product.
You'll need to work out (or find on the net) the file format and write your
own routine to read it.
This is great fun (!!??!!!) to extract information from a file I generally
read a buffer from it, then iterate through, calculating offsets and
whatever, some file types are quite easy (MP3, ZIP, CAB) others are absolute
sods, I've no idea about 123 files but if you know the extension there are
lots of web sites that list information about file types - that is where to
start.
Alternatively you could install the 123 filter for Excel and use that to
convert the files to CSV.
Good luck
Dave
"lezaic zivko" <zivojin.lezaic@zaba.hr> wrote in message
news:ue%23CvMNvEHA.1204@TK2MSFTNGP10.phx.gbl...
>I have to reed some data from lotus 123 file, but I can't find procedures
> and sintaxes for opening file and selecting cells.
>
>
>
| |
| Tom_OM 2004-10-28, 8:55 pm |
| There is (or at least used to be) a developers' forum for Lotus
Smartsuite products at www.lotus.com. If you poke around there and
search the archives, I'd bet you can find the low-down on Lotus 123
file formats. There is almost certainly more than one 123 format,
depending on which version of 123 created the file.
On Thu, 28 Oct 2004 11:18:28 +0200, "lezaic zivko"
<zivojin.lezaic@zaba.hr> wrote:
>I have to reed some data from lotus 123 file, but I can't find procedures
>and sintaxes for opening file and selecting cells.
>
>
|
|
|
|
|