Sorry, drifted off to read some UF. It's been forever since I read that strip. Used to read it religiously. Even went back and re-read the first couple of years that I'd missed so I could catch up on the story lines.
You'd think a guy named Mug would remember to brew a pot...
the first time I ran and barely made it 0.5 miles, I thought so, too.
I hate running, I find it quite boring, and I've always found it painful.
I discovered that some good glucosamine, quality running shoes, and some work on technique makes it not painful.
it's still boring as all get out... :/
Other than the shoes, it's a lot cheaper than getting back on the bike, and I can easily pack the running shoes, t-shirt & shorts for travel. Taking the bike with me is a much more involved process.
Yeah, it can't be network lag making Excel think the file's still open... I updated one chart with it marked as RO, went to SO to update my question to note that fact, commented on it here, went through the loop skipping a couple of non-linked objects, then got the warning on the next linked item.
Have I ever mentioned that sometimes I really dislike Microsoft?
Public Sub Foo(ByVal Var1 As Integer, ByVal Var2 As String, ByVal Var3 As Byte, _
Optional ByVal Var4 As Object, Optional ByVal Var5 As Date, _
Optional ByVal Var6 As Long)
First off, this doesn't iterate over your classes, it iterates over all modules in your file.
Dim Part As VBComponent
For Each Part In Application.VBE.ActiveVBProject.VBComponents
Debug.Print Part.Name
Next Part
If you want to iterate over just the class modules, you'll need to check the...
Yeah.. your question seems to be shifting under my feet as I type.... — RubberDuck9 mins ago
> Finally, in order to create an instance of a class, it's going to necessarily be a global instance... which kind of smells, but whatever. You've not really given us your end goal. I have a feeling that your problem is better solved via some good OOP programming, but that's not the question you asked.
Ya know, the more I think about it, the more I think you have an XY problem. Why not create a new question that explicitly states what you're trying to achieve instead of how you're trying to achieve it? — RubberDuck10 secs ago
@RubberDuck yeah, and your deserters (the loyalists) came north and made Upper Canada and they were like over-enthusiastic with the crown thing, and ended up taking over the whole north-of-the-border