Writing data to DLL file ...

**Haluk** · 02-18-2019, 01:07 PM

Hi all;

What I want to do is; to embed a DLL file into the worksheet and then export the DLL file to harddisk when needed.

I have imported the DLL file into the sheet by reading each byte and writing into the cells. It takes about 5 minutes to complete the process. Btw, the imported DLL file size is about 3 MB. (i.e. almost 3 columns of the sheet are full)

So far, this part of the job is nearly OK ...

Then, I export the DLL file by reading from the cells that have been written before ... by the code given below. But it takes about 2 hours to complete the job

The code has Application.ScreenUpdating = True for now, just to see the progress going on which is shown in cell M1 formatted as "%"

I want to know if there is any other method to speed up the process....

The code for exporting the data is;

Please Login or Register  to view this content.

.

**Haluk** · 02-18-2019, 06:16 PM

As of now.... by using a string builder class (which is coded by one of my friends), now it takes about 30 minutes to write the bytes to the DLL file.

But there is also some other problems as well.... such as, bytes are not exported correctly. I was facing the same problem with the code given in the previous message also.

Is there anybody having an idea about correcting the byte problem?

.