How to convert sprintf function of C to VBA?

[u24c02]

Hi.

Now I'm trying to convert C to vba, in especially the below function witch is coming from C.

Please Login or Register  to view this content.

and I've converted as the below, but not sure how to convert the "sprintf" of c function.
can you help me please?

Please Login or Register  to view this content.

[JBeaucaire]

Cross posted here.

[JBeaucaire]

Does this doe what you need?
http://www.houkema.net/projects/unca...ntf-vba-macro/

[u24c02]

I've already seen that just before, but that code does not work.

Especially,

mask = Replace$(mask, “%s”, tokens(i), , 1) this part is red

[u24c02]

Does this doe what you need?
http://www.houkema.net/projects/unca...ntf-vba-macro/

can you help me how to convert to VBA ?

Please Login or Register  to view this content.

[JBeaucaire]

Setting that code aside, can you describe the result you're after? What I've read online about sprint leads to me to believe it's nothing more than a string concatenation technique.

Is of the variable value your starting with is nbits, to which you're doing the math: ((nbits - 1) / 4) + 1 that's fine, the same in VBA.

Now what? What would the typical results of that calculation be?
Then you are slipping that into the text string: "0x%0*llX" somewhere?

Give an example of a starting nbits value and the resulting text string you expect to create. VBA has easy ways to concatenate strings.

[xlnitwit]

Hi,

I'm not absolutely certain that I have remembered the formatting options correctly but my best guess would be this

Please Login or Register  to view this content.