Resource and excel/txt

[SeaHag]

Hi.

I want to open an excel file (or access file) I have included in my
exe via a resource file. The file contains confidential pricing.

I have found a snipit, but what it does is saves
the excel resouce to disk. This is unacceptable.

Here is the snipit.

Dim sBuffer As String
    sBuffer = StrConv(LoadResData(101, "XLs"), vbUnicode)
    Open App.Path & "\LOG.XLS" For Output As #1
    Print #1, sBuffer
    Close #1

WHAT i need to do is find a way to access the info in that resource file ...but NOT saving it to disk first....

Is this possible. ( I am thinking if it is txt file. it would be easier...
But i dont know)

Any suggestions?

Seahag

[peet]

yes, text file, sbuffer will then contain text and u can handle that without saving it.

[SeaHag]

Does the code look familiar? LOL,
Eekk.. the data is in chart form.. (rows and columns)

Cant i pass sBuffer to a object variable???
if not..

Any suggestion how that would work with a txt file?

Thnks in advance..
Sehag

[peet]

familiar yes

No way to pass it directly to the object that I know of....sorry

could u not export it to a comma or other type of seperated text file, then add that to the resource?

then u can just use split and conquer to get control over the content?

I know to little about the data and how u want to use it in order to give u any good sample

[SeaHag]

Ya.. i guess that would be the simplist..

I kinda get the gist of what i need to do..

I guess it just comes down to formatting.

I need a list ..


Spinner machine Swing Machine Tumbler machin Dust collector
Machine
Wheel assembly
panel Cost
Abrasive handling

(wont format correctly)

Basic Table.. And just only one..

Thnks again

Seahag