Gasman
Enthusiastic Amateur
- Local time
- Today, 23:28
- Joined
- Sep 21, 2011
- Messages
- 14,284
Hi all,
Just curious after helping someone in another forum with this possible issue.
How do the experts here write their VBA.?
I myself would
Create object
Set object
Open object
then write all my code, then
Close the object
Release the object.
Same with If, Do and For, in that I do not write If, then the Endif and then insert code between those words. I would just write If statement, then what happens if true/false, and then the Endif at the end.
It has caught me out once in a while, but nothing to make me change now, and I'm a little to set in my ways at my age, plus I do not hardly ever code anymore.
Just curious as to how the experts who make their living from coding here do it.?
TIA
Just curious after helping someone in another forum with this possible issue.
How do the experts here write their VBA.?
I myself would
Create object
Set object
Open object
then write all my code, then
Close the object
Release the object.
Same with If, Do and For, in that I do not write If, then the Endif and then insert code between those words. I would just write If statement, then what happens if true/false, and then the Endif at the end.
It has caught me out once in a while, but nothing to make me change now, and I'm a little to set in my ways at my age, plus I do not hardly ever code anymore.
Just curious as to how the experts who make their living from coding here do it.?
TIA