VB creating Excel Worksheet
Posted on 1998-09-21
Background: Have a VBA script which runs in Excel 97
It creates a Worksheet and then fills the cells
with text. The size of the VBA script(approx 28 pages
printed) soon exceeded the resource of EXCEL/VBA.
The only way I can get this script to run to completion
is to reduce array sizes for example.
One of the advisor in this forum recommended
VB/ActiveX EXE as a solution.
1.Can Excel Worksheet be created and its cells
controlled and populated using VB(activeX EXE) or does VB have
to somehow run Excel and prompt Excel to run some
2. The vba script when imported as a module does
not compile in VB because of Excel classes such
as 'Range' in the script. Can I add libraries
that will enable VB to understand what an Excel
'Range' is for example? How do I import these
3. Would this Excel/VB/ActiveX EXE situation be
initiated by a dummy vba script run in Excel
which somehow references the ActiveX EXE, which then
does most of the processing.