LoadCombo.cls is being imported as a Module not a Class

[alishrih]

Describe the bug
While attempting to import LoadCombo.cls into a VBA project, it will be imported as a Module not a Class. Additional header lines will be added, see first screenshot below.

To Reproduce

1. Download the code as zip from github and unzip locally.
2. In Excel, open a VBA Project.
3. Right click the project name and select "Import File...".
4. Find the file "LoadCombo.cls" and hit open.

Expected behavior
A LoadCombo class should be created instead of a LoadCombo Module and without the additional header lines.

Screenshots

Additional context
I'm going to leave this in here just in case someone else needs it. This is not a bug per se, as I believe the code will work just fine if you create the class manually and copy/paste the code into it (minus the added header lines.) This happens because the line endings in the file LoadCombo.cls are UNIX-style (LF) vs the Windows-style (CR+LF). See this from Tim Hall.

[rfbardock]

Hi. I'm just new here. May I ask how to use this LoadCombo class module? I'm just a newbie here.

[alishrih]

Hi. I'm just new here. May I ask how to use this LoadCombo class module? I'm just a newbie here.

I'm not sure if you are a newbie in github or programming in general. The easiest way to answer your question is with this:
Call beamModel.AddLoadCombo("COMB2", Array("D", "L", "S"), Array(1.2, 1.6, 0.5))
Where:
beamModel: is an feModel class.
COMB2: is a name for the load combination.
Array("D", "L", "S"): loads (Dead, Live, and Snow)
Array(1.2, 1.6, 0.5): multipliers

[rfbardock]

Hi alishrih, thanks for your reply. Im newbie in Github and in programming as well. So i did copy the LoadCombo as class module. I have'nt done any modificaton in the FEModel yet to use the LoadCombo class module since I'm newbie yet. The only funtion i can call at the moment is the AddLoadcase and DeleteLoadCase which is inside the LoadCombo class module.

I am studying the pynite code FEModel3D which is almost the same with this xlFrame and i saw the LoadCombo.py was integrated inside the FEModel3D.py. Can help me to integrate this LoadCombo class module inside the FEModel class? I am doing a spreadsheet and want to add load combination for design purposes.

[alishrih]

Hi alishrih, thanks for your reply. Im newbie in Github and in programming as well. So i did copy the LoadCombo as class module. I have'nt done any modificaton in the FEModel yet to use the LoadCombo class module since I'm newbie yet. The only funtion i can call at the moment is the AddLoadcase and DeleteLoadCase which is inside the LoadCombo class module.

I am studying the pynite code FEModel3D which is almost the same with this xlFrame and i saw the LoadCombo.py was integrated inside the FEModel3D.py. Can help me to integrate this LoadCombo class module inside the FEModel class? I am doing a spreadsheet and want to add load combination for design purposes.

I am not familiar with pynite, so I can't help you with that. This topic belongs in the Discussion section, but unfortunately it's not enabled for this repo. At any rate, here is a fully functional spreadsheet that uses xlFrame to solve a simply supported beam reactions, moment, and shear diagrams with load combinations.

[rfbardock]

Thanks alot alishrih. I'll check the spreadsheet you shared.

I did a workaround with my spreadsheet in which I manually input the load factors in the spreadsheet and put it in one public sub then create another public sub without load factors. I call the public sub without load factor inside the sub with load factor to get ULS and SLS results. if work fine but its good if I can use the load combo class module.

[rfbardock]

Hi alishrih, I already saw your spreadsheet and checked the vba code inside. It turns out I am using the old FEModel class module. I used the modules inside the old excel sample which do not have load case option in the load definitions. My bad I did not download the latest modules.