Postat: 25 september 2007, 17:19:55
Efter lite letande i hjälpfilen för excel (VBA) hittade jag följande, vet inte om det är till någon hjälp.
Ett annat sätt är ju att använda OLE, funkar utmärkt mellan MS Office program, vet ej hur man fixar detta själv.
eller
DDE, lite väl ostabilt och kan börja krångla av ingen som helst anledning
Writing Data to Files
When working with large amounts of data, it is often convenient to write data to or read data from a file. The Open statement lets you create and access files directly. Open provides three types of file access:
* Sequential access (Input, Output, and Append modes) is used for writing text files, such as error logs and reports.
* Random access (Random mode) is used to read and write data to a file without closing it. Random access files keep data in records, which makes it easy to locate information quickly.
* Binary access (Binary mode) is used to read or write to any byte position in a file, such as storing or displaying a bitmap image.
Note The Open statement should not be used to open an application's own file types. For example, don't use Open to open a Word document, a Microsoft Excel spreadsheet, or a Microsoft Access database. Doing so will cause loss of file integrity and file corruption.
The following table shows the statements typically used when writing data to and reading data from files.
Access Type Writing Data Reading Data
Sequential Print #, Write # Input #
Random Put Get
Binary Put Get
Ett annat sätt är ju att använda OLE, funkar utmärkt mellan MS Office program, vet ej hur man fixar detta själv.
eller
DDE, lite väl ostabilt och kan börja krångla av ingen som helst anledning
Writing Data to Files
When working with large amounts of data, it is often convenient to write data to or read data from a file. The Open statement lets you create and access files directly. Open provides three types of file access:
* Sequential access (Input, Output, and Append modes) is used for writing text files, such as error logs and reports.
* Random access (Random mode) is used to read and write data to a file without closing it. Random access files keep data in records, which makes it easy to locate information quickly.
* Binary access (Binary mode) is used to read or write to any byte position in a file, such as storing or displaying a bitmap image.
Note The Open statement should not be used to open an application's own file types. For example, don't use Open to open a Word document, a Microsoft Excel spreadsheet, or a Microsoft Access database. Doing so will cause loss of file integrity and file corruption.
The following table shows the statements typically used when writing data to and reading data from files.
Access Type Writing Data Reading Data
Sequential Print #, Write # Input #
Random Put Get
Binary Put Get
Är det VisualBasic...något ?? 
