Other than that I am not sure what you are trying to do and where. Can you describe what you want to do with this sheet and provide me with steps to reproduce your issue?
Statistics: Posted by jasper — 08 December 2019, 14:12
]]>
Thank you for your prompt reply. I didn't expect it that quickly
You can find the excel file as attached. It is just a simple flash with I am trying to communicate...
Honestly, It's been a long time since I haven't code in VBA so I may miss some skills...
If you have a working file with "Set" so that I could be inspired it would be great.
For scripts, I will have a look for sure.
Best regards,
Kevin
Statistics: Posted by kevin032 — 05 December 2019, 09:45
]]>
]]>
]]>
I desperatly try to set parameters on my COCO file with VBA but I don't manage to do so.
I tried the SetStreamTemperature you defined in previous post but it returns an error : str1.SetProp("temperature", "overall", Empty, "", "", v) (= is needed).
Moreover, I don't manage to make this subroutine accessible in the Macros windows.
Besides, I noticed that the COFE_CompleteCOFERecalc() Macro doesn't seem to work well on my file. Everytime, I set MANUALLY a parameter (for instance a Temperature in the first stream), It doesn't converge and I get the following message :
warning: Simulation Context error in ICapeMaterialTemplateSystem::CreateMaterialTemplate: Invalid stream type name
warning: Material object error in GetComponentConstant: No data
warning: Material object error in GetComponentConstant: One or more missing values
warning: Material object error in GetComponentConstant: No data
warning: Material object error in GetComponentConstant: One or more missing values
warning: Material object error in GetComponentConstant: No data
warning: Material object error in GetComponentConstant: One or more missing values
warning: Simulation Context error in ICapeMaterialTemplateSystem::CreateMaterialTemplate: Invalid stream type name
warning: Material object error in GetComponentConstant: No data
warning: Material object error in GetComponentConstant: One or more missing values
warning: Material object error in GetComponentConstant: No data
warning: Material object error in GetComponentConstant: One or more missing values
warning: Material object error in GetComponentConstant: No data
warning: Material object error in GetComponentConstant: One or more missing values
warning: Simulation Context error in ICapeMaterialTemplateSystem::CreateMaterialTemplate: Invalid stream type name
warning: Material object error in GetComponentConstant: No data
warning: Material object error in GetComponentConstant: One or more missing values
warning: Material object error in GetComponentConstant: No data
warning: Material object error in GetComponentConstant: One or more missing values
warning: Material object error in GetComponentConstant: No data
warning: Material object error in GetComponentConstant: One or more missing values
Would someone be able to help me or to send me a working file with setter so that I could be inspired xD.
Thank you very much for your help.
Best regards,
Kevin
Statistics: Posted by kevin032 — 28 November 2019, 09:03
]]>
Many thanks!
regards, Henk
Statistics: Posted by HenkF — 03 January 2015, 18:12
]]>
]]>
]]>
]]>