|
Don't miss Excel
extends optical coating software capabilities
in Laser Focus World April 2014.
Click here to read the article;
click here
to download examples (Reference 1 in the article). |
Users running
DESIGN from Excel can experience errors when establishing a
Reference to FtgDesign1. The issue is normally resolved by re-establishing the Reference
via VBA Tools.. References. It might also be necessary to
re-install FilmStar (no need to uninstall).
But what if References cannot be changed in the usual
manner? This can be a critical problem when it is difficult to modify
archived Excel Workbooks.
To help understand such issues,
FilmStar-ID.xls displays Registry properties.
Suggestion: copy information from rows 2-12 to store current
ID's and thereby track any future changes. |
Usual way to add References |
Version information extracted from
Windows Registry
Keys for
missing FilmStar EXE files must be deleted and recreated. As
shown at the right deletion is automatic.
Click No if you prefer to manually edit the Registry.
The
Registry should be backed up
before making changes.
Registry keys are automatically recreated when you re-run
the FilmStar application. Click Refresh to verify.
Run-DESIGN-Ref.xls programmatically adjusts references when opening
a Workbook. Users who cannot otherwise solve problems should
study this example which requires the
macro security settings shown below. You may need to
digitally sign Workbooks if your IT manager complains
about Enable all macros. |
Missing executable |
Security settings in Excel 2010
An issue that arises
is
'early binding' vs. 'late binding'. Early binding is
standard but there are reasons to consider late binding. You
might, for example, need an Excel Workbook compatible with past and
current FilmStar versions; or, when running Excel from FilmStar
BASIC, you might require compatibility with various Excel versions.
Excel-FilmStar DESIGN examples:
EARLY,
LATE.
When testing code, open Task Manager to ensure that there are not
multiple FilmStar processes (e.g. Design1.exe) running.
XLS files in above
links have been tested with 32/64 Windows and Excel versions 2000
(32-bit) and 2010 (32 and 64-bit). The same considerations apply to
all FilmStar programs.
Back
to Technical Issues