Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

behaviour of Excel template as "read only" in a DOS script versus Template Icon

0 views
Skip to first unread message

George Lewycky

unread,
Mar 5, 2009, 10:33:22 AM3/5/09
to

Hello everyone,

I have an excel "template" (.xlt) shown below which I made read-only
so the users cannot save over the template and also imports a pre-
define filename "FC_Excel.txt".

When I run the template via the icon or shortcut it works fine and
even defaults to "workbook" protecting the template which is what I
want so the user cant override the template.


But, I have a script which merges, manipulates and sorts the
text file "FC_EXCEL.txt" to prepare it for the template as shown below
in the DOS script which I also have starting Excel with the template
works but now defaults to "template" instead of WORKBOOK when using an
ICON or SHORTCUT.


sort /+2 c:\FC_MERGE.txt | findstr /C:"$" > FC_EXCEL.txt
start EXCEL.EXE "c:\Download Template_Oct20_mmddyy.xlt"

I found these sites which talk about starting Excel with switches and
arguments which I will be testing out but I don’t see anything related
to my issue.

http://www.tek-tips.com/faqs.cfm?fid=1371

http://www.techtalkz.com/windows-xp/118035-start-run-something.html

http://www.pcreview.co.uk/forums/thread-1899223.php


Any Ideas or suggestions greatly appreciated


TIA

George Lewycky


0 new messages