Hey guys,
I want to use VBA in excel to assist me with modifying my input file for FEM program Abaqus, here's what i need to do:
One of the steps in the input file needs to be copied and have some important numbers within the input file increased by 1 each time the step is copied. Here is the part of the input file I need to copy and modify -
**
** STEP: line 1
**
*Step, name="line 1", inc=100000000
*Heat Transfer, end=PERIOD, deltmx=1.
0.001, 5., 1e-05, 1.,
**
** LOADS
**
** Name: BODYFLUX-1 Type: Body heat flux
*Dflux
"LINE 1", BF, 5e+08
**
** OUTPUT REQUESTS
**
*Restart, write, frequency=0
**
** FIELD OUTPUT: F-Output-7
**
*Output, field
*Radiation Output
FTEMP,
**
** FIELD OUTPUT: F-Output-8
**
*Element Output, directions=YES
HFL, TEMP
**
** FIELD OUTPUT: F-Output-9
**
*Node Output
NT,
**
** HISTORY OUTPUT: H-Output-5
**
*Output, history
*Radiation Output
FTEMP,
**
** HISTORY OUTPUT: H-Output-6
**
*Contact Output
HFLA, HTL, HTLA
*End Step
I need to copy and increase this information so that the next copy will read instead of "STEP: line 1" it will read "STEP: line 2" and instead of ""LINE 1", BF, 5e+08" it will read ""LINE 2", BF, 5e+08". i need to copy increase these lines of text at 1000 times
I have been working with a looping function but i really dont know what to do, so some help on this would be much appreciated. I hope i have explained what i need to do well enough. please ask me if this is confusing. thank you very much
I want to use VBA in excel to assist me with modifying my input file for FEM program Abaqus, here's what i need to do:
One of the steps in the input file needs to be copied and have some important numbers within the input file increased by 1 each time the step is copied. Here is the part of the input file I need to copy and modify -
**
** STEP: line 1
**
*Step, name="line 1", inc=100000000
*Heat Transfer, end=PERIOD, deltmx=1.
0.001, 5., 1e-05, 1.,
**
** LOADS
**
** Name: BODYFLUX-1 Type: Body heat flux
*Dflux
"LINE 1", BF, 5e+08
**
** OUTPUT REQUESTS
**
*Restart, write, frequency=0
**
** FIELD OUTPUT: F-Output-7
**
*Output, field
*Radiation Output
FTEMP,
**
** FIELD OUTPUT: F-Output-8
**
*Element Output, directions=YES
HFL, TEMP
**
** FIELD OUTPUT: F-Output-9
**
*Node Output
NT,
**
** HISTORY OUTPUT: H-Output-5
**
*Output, history
*Radiation Output
FTEMP,
**
** HISTORY OUTPUT: H-Output-6
**
*Contact Output
HFLA, HTL, HTLA
*End Step
I need to copy and increase this information so that the next copy will read instead of "STEP: line 1" it will read "STEP: line 2" and instead of ""LINE 1", BF, 5e+08" it will read ""LINE 2", BF, 5e+08". i need to copy increase these lines of text at 1000 times
I have been working with a looping function but i really dont know what to do, so some help on this would be much appreciated. I hope i have explained what i need to do well enough. please ask me if this is confusing. thank you very much