If you are using VB6 then I assume you have an variable set to the Excel.Application object. In my example below this is assigned to variable MyExcel. The following inserts a column in the active sheet at column C and shifts the remaining columns to the right.
'Get a handle to the column you...
I have 2 approaches:
1. Use conditional if statements (#If). The following is an example of what I know is supported:
#If Mac Then
'. Place exclusively Mac statements here.
#ElseIf Win32 Then
'. Place exclusively 32-bit Windows statements here.
#Else
'. Place other platform...
In a subroutine use:
Dim MyIEApp As Object
Set MyIEApp = GetObject(, "InternetExplorer.Application")
This assumes Internet Explorer is already running. If not then use:
Set MyIEApp = CreateObject("InternetExplorer.Application")
In either case the Internet Explorer objects...
Use the following to assign key "D" to "Macro2":
Sub Macro1()
CustomizationContext = ActiveDocument
aCode = BuildKeyCode(wdKeyD)
KeyBindings.Add KeyCode:=aCode,_
KeyCategory:=wdKeyCategoryMacro, _
Command:="Macro2"
End Sub
Use the...
If the cell in the upper left corner of a range of contiguous cells is known, say "A1", then you could use:
Set MyRange=ActiveSheet.Range("A1").CurrentRegion
for each MyRow in MyRange.Rows
your code here using MyRow
next
Paul
You should consider LMS. They have Engineering Services, facilities and software to anything in NVH and Acoustics. They can handle CAE, Test and Hybrid approaches.
In North America Contact:
Mike Albright - mike.albright@lmsna.com
248-952-5664
OR
Tony Flezar - tony.fleszar@lmsna.com...
Both DADS and ADAMS are well regarded.
LMS has introduced it's next set of CAE tools called LMS Virtual.Lab. Virtual.Lab is capable of Motion, NVH, Fatigue/Durability and Acoustic analysis in one GUI.
DADS is being replaced by LMS Virtual.Lab Motion. One of it's key features is ease of...
I think I have an approach that works. Here are the requirements:
Contrained Modes (Static modes)
Normal Modes (eigen modes)
Time History
Fatigue Solver capable of Modal Superposition.
The steps:
1. Solve for constrained modes
2. Solve for normal modes
3. Compute modal participation factors...