Hi.
Now I'm trying to convert C to vba, in especially the below function witch is coming from C.
and I've converted as the below, but not sure how to convert the "sprintf" of c function.
Please Login or Register to view this content.
can you help me please?
Please Login or Register to view this content.
Cross posted here.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Does this doe what you need?
http://www.houkema.net/projects/unca...ntf-vba-macro/
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
Originally Posted by JBeaucaire
can you help me how to convert to VBA ?
Please Login or Register to view this content.
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.
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.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks