Convert C .h file to VBA .bas

[JessStuart]

Hello,

I'm converting an Excel spreadsheet which uses dll file A to use dll file B. dll file B came with a .h file (a C header file), but no .bas file. The .h file is huge, and I don't have much time to convert it to .bas. Is there a tool to convert .h files into .bas?

Thanks,

Jess Stuart

[willakawill]

Hi Jess. Sorry, bad news. There is no such thing. No such translation. You have to understand c and rewrite the same code in vb. It does not translate.

[Killer42]

Hi Jess. Sorry, bad news. There is no such thing. No such translation. You have to understand c and rewrite the same code in vb. It does not translate.

Hey Will, sounds as though there's a market for such a translator. Get on it, quick! :)

[JessStuart]

Hi Jess. Sorry, bad news. There is no such thing. No such translation. You have to understand c and rewrite the same code in vb. It does not translate.

Hm... I guess I didn't explain properly. The spreadsheet I'm converting already uses a dll which came with both a .bas and .h file.

The new dll I'm supposed to use only comes with a .h file. So I need to convert the .h file into a .bas file. I guess there aren't any automatic tools to do this. I made one that would, and I now have a .bas file.

I'm not sure about when to use ByVal vs ByRef.

Does anyone know of any rules for this?


Thanks.

[willakawill]

ByRef will change the original value of the sending parameter. ByVal will not.

[Killer42]

ByRef will change the original value of the sending parameter. ByVal will not.

Also, I recall reading that ByVal causes VB to pass strings as null-terminated (as expected by C/C++ code) rather than it's usual format which I think starts with a length indicator.