|
I got some VBA code from business analyst and try to convert them into C code.
just did some quick research and it seems not that hard...
diligent hands rule....
|
|
|
|
|
It all depends on what it does. If it's automating Excel it would be kind of hard to use IDispatch and such from C. C++ would be somewhat better at least.
But if it's just business logic or something that seems easy enough.
And to answer your question, no I haven't, but I use both languages.
Real programmers use butterflies
|
|
|
|
|
most of them are algorithms and formula.![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
diligent hands rule....
|
|
|
|
|
ah, good deal. that's easier to port.
Real programmers use butterflies
|
|
|
|
|
I felt encouraged from you
diligent hands rule....
|
|
|
|
|
There is no "conversion", it's a straight porting. It depends on what it does, if it interacts with OLE/ActiveX there will be blood to pay, otherwise it depends on scope and size of the application and hoqw badly it had been coded originally.
GCS d--(d+) s-/++ a C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- r+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
Same for C# as well.
I also spent 6 months a while back manually porting over VB6 code to C#. That was very tedious and time consuming. ugh.
|
|
|
|
|
If time is not an issue I find it better / faster to rewrite. But if you do try and port it you will read the code lots of times and will have a good understanding of what it does - for when the time comes to rewrite it.
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
Porting production apps over to another language is very much like an art restoration expert, restoring an old painting. You want to preserver as much of the old stuff as possible, with little to no personal introductions, as to compromise the original.
If I happen to see a crack in the painting, I fill it, seal it, then paint over, but only the crack.
Why preserve the old stuff (the logic)? Because it works, and has been tested, and has been used for n-Number of years. You want to reduce the amount of bugs you introduce into the logic/code.
I never "re-write" it, ever.
modified 9-Nov-20 7:46am.
|
|
|
|
|
Good points but any commercial software relying on VBA is open to question in my book
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
Sorry, I was talking about VB6, and other languages I have had to port. I have never ported VBA, as mentioned in the OP.
I always looked an VBA as more of scripting language anyhow...macros and crap.
I would use Visual Studio Tools for Office then and C# if I had to do anything in porting VBA, etc.
|
|
|
|
|
Yes, I did such a thing last year (Excel VBA to MFC, actually). One piece of code went from about 75 minutes (while also tying up the CPU to where nothing else could run) down to less than 10. The decrease in time and demand on the CPU were amazing.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
|
|
|
|
|
|
Quote: converted some VBA code to C
Coder-speak for "out of the frying pan into the fire." 
|
|
|
|
|
Done a ton of VBScript to C#. This site, actually. Was great fun!
cheers
Chris Maunder
|
|
|
|
|
|
It's like that question "How do you eat an Elephant?"
Answer: one bite at a time.
Better answer is that you need someone who knows C well. C has no seatbelts or airbags like VBA so be gentle with that accelerator - it's twitchy!
cheers
Chris Maunder
|
|
|
|
|
diligent hands rule....
|
|
|
|
|
|
 Sad. I'm not sure I can watch the show without him.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
Without him, I think the show's future is in jeopardy.
Yes, I went there. :-p
|
|
|
|
|
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
yeah, I saw that. sad. what an icon he was; on every level. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
I don't think they have named a replacement. Not sure they will continue the show. Perhaps, they will have a period of mourning prior to naming someone. That would be a good way to do this.
|
|
|
|
|
Who is Alex Trebek?
If you can't laugh at yourself - ask me and I will do it for you.
|
|
|
|
|
They are twice as much as generic ESP32 boards and the SPI interface doesn't even work right.
When asked about it in their support forums their support team responded with "the ESP32 chip is unstable and weird"
'scuse me, but "weird?"
why am I paying twice as much for a board with a chip on it that you don't know about? If you're not dialed in on how the ESP32 works, what are you doing making a board for it, much less charging twice as much? When the company calls the heart of their own product "weird" and "unstable" I'm going somewhere else.
The generic boards don't have this problem and are half the price.
Grrr. They remind me of apple.
Real programmers use butterflies
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
