Recent content by shayneham

Quick follow up, I still can't reliably repro this every time, however when I do get it, I can get it continuously in that session, until I close excel, and I have found I can reliably get it to stop happening if I rename the Vardesc array in the SectionDB type to AckDesc. I can only guess that...

Here is what the VBA help says related to above... ------------------------- If the variable being read into is a variable-length string, Get reads a 2-byte descriptor containing the string length and then reads the data that goes into the variable. Therefore, the record length specified by the...

Thanks for your reply Tony. The file itself is correct when looked at in a hex editor, and VB and VBA should work exactly the same in this regard. My only guess at this point, is from looking at the help files between VB and VBA, on the Get function, VBA mentions something that VB doesn't...

After a little more digging, I find the offset is actually 2 bytes. What I did was set up both VB and VBA to show me the file position as it was being read in. With the exact same file the following is reported. Keep in mind there are 3 integers at the start of the file, and the SectionDB is...

I am running into one of the strangest issues I have seen in a long time. I have a user defined type that I utilize in VB6 and write out to a binary file. The Type is... Type SECTIONDB ' Job Section List Database SectionNum As Integer ' Section number...