<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3314" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=605261715-23042008><FONT face=Arial
color=#0000ff size=2>Hi John,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=605261715-23042008><FONT face=Arial
color=#0000ff size=2>I was thinking of Adobe and other web forms like MSS PCR
forms allowing for more functionality than the old document from
template.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=605261715-23042008><FONT face=Arial
color=#0000ff size=2>Cheers,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=605261715-23042008><FONT face=Arial
color=#0000ff size=2>Sherie</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> sap-wug-bounces@mit.edu
[mailto:sap-wug-bounces@mit.edu] <B>On Behalf Of </B>John A
Haworth<BR><B>Sent:</B> Wednesday, April 23, 2008 11:06 AM<BR><B>To:</B> SAP
Workflow Users' Group<BR><B>Subject:</B> RE: Document from Template +
VBA<BR></FONT><BR></DIV>
<DIV></DIV><BR><FONT face=sans-serif size=2>Hi</FONT> <BR><BR><FONT
face=sans-serif size=2>If they are 'Old' whats the New technology?</FONT>
<BR><BR><FONT face=sans-serif size=2>John<BR><BR>CSC Computer Sciences
Limited<BR>Registered Office: Royal Pavilion, Wellesley Road, Aldershot,
Hampshire, GU11 1PZ, UK<BR>Registered in England No:
0963578<BR><BR>-------------------------------------------------------------------------------------------------------------------------------------------------------------------------<BR>This
is a PRIVATE message. If you are not the intended recipient, please delete
without copying and kindly advise us by e-mail of the mistake in delivery.
<BR>NOTE: Regardless of content, this e-mail shall not operate to bind CSC to
any order or other contract unless pursuant to explicit written agreement or
government initiative expressly permitting the use of e-mail for such
purpose.<BR>-------------------------------------------------------------------------------------------------------------------------------------------------------------------------<BR></FONT><BR><BR><BR>
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD width="40%"><FONT face=sans-serif size=1><B>"Munday,Sherie J."
<MUNDAYSJ@airproducts.com></B> </FONT><BR><FONT face=sans-serif
size=1>Sent by: sap-wug-bounces@mit.edu</FONT>
<P><FONT face=sans-serif size=1>23/04/2008 15:47</FONT>
<TABLE border=1>
<TBODY>
<TR vAlign=top>
<TD bgColor=white>
<DIV align=center><FONT face=sans-serif size=1>Please respond
to<BR>"SAP Workflow Users' Group"
<sap-wug@mit.edu></FONT></DIV></TR></TBODY></TABLE><BR></P>
<TD width="59%">
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD>
<DIV align=right><FONT face=sans-serif size=1>To</FONT></DIV>
<TD><FONT face=sans-serif size=1>"SAP Workflow Users' Group"
<sap-wug@mit.edu></FONT>
<TR vAlign=top>
<TD>
<DIV align=right><FONT face=sans-serif size=1>cc</FONT></DIV>
<TD>
<TR vAlign=top>
<TD>
<DIV align=right><FONT face=sans-serif size=1>Subject</FONT></DIV>
<TD><FONT face=sans-serif size=1>RE: Document from Template +
VBA</FONT></TR></TBODY></TABLE><BR>
<TABLE>
<TBODY>
<TR vAlign=top>
<TD>
<TD></TR></TBODY></TABLE><BR></TR></TBODY></TABLE><BR><BR><BR><FONT face=Arial
color=blue size=2>Daniel,</FONT> <BR><FONT face=Arial color=blue size=2>You are
one up on me. I didn't think you could do any VBA with document from
templates. They are really the "old" technology now.</FONT> <BR><FONT
face=Arial color=blue size=2>Anyone else have better experience?</FONT>
<BR><FONT face=Arial color=blue size=2>Regards,</FONT> <BR><FONT face=Arial
color=blue size=2>Sherie</FONT> <BR><FONT size=3> </FONT> <BR><FONT
face=Arial color=blue size=2>Sherie Munday </FONT> <BR><FONT
face=Arial color=blue size=2>Workflow Developer/ Analyst</FONT> <BR><FONT
face=Arial color=blue size=2>Air Products & Chemicals, Inc.</FONT> <BR><BR>
<HR>
<FONT face=Tahoma size=2><B>From:</B> sap-wug-bounces@mit.edu
[mailto:sap-wug-bounces@mit.edu] <B>On Behalf Of </B>Daniel
Schorsch<B><BR>Sent:</B> Wednesday, April 23, 2008 3:08 AM<B><BR>To:</B>
sap-wug@mit.edu<B><BR>Subject:</B> Document from Template + VBA</FONT><FONT
size=3><BR></FONT><BR><FONT face=sans-serif size=2><BR>Hi all,</FONT><FONT
size=3> <BR></FONT><FONT face=sans-serif size=2><BR>I would appreciate it if
anybody could help me out with the following problem:</FONT><FONT size=3>
<BR></FONT><FONT face=sans-serif size=2><BR>In a workflow I would like to use an
excel file that is based on a template and is edited in three different steps by
different users. What is needed is some coding INSIDE the excel template
itself.</FONT><FONT size=3> <BR></FONT><FONT face=sans-serif size=2><BR>I just
had a try with using the workflow step type "Document from Template" to create
my Excel template including the VBA code (the code was tested before in another
excel sheet outside SAP, to make sure it "normally" works). </FONT><FONT
size=3><BR></FONT><FONT face=sans-serif size=2><BR>When testing the workflow
with the new step of creating document from template I saw that a macro is there
because the warning popup opened up asking if I want to activate
macros.</FONT><FONT size=3> </FONT><FONT face=sans-serif
size=2><BR>Unfortunately the macros were not triggered at all as they were in
the outside SAP world tests. :-(</FONT><FONT size=3> <BR></FONT><FONT
face=sans-serif size=2><BR>The VBA code is triggered when saving the workbook. I
guess this might be the problem??!! I also included a button on the sheet
calling a function within the excel sheet and it functions very
well.</FONT><FONT size=3> <BR></FONT><FONT face=sans-serif size=2><BR>Do you
have any ideas??? Please help me out with this problem!!</FONT><FONT size=3>
<BR></FONT><FONT face=sans-serif size=2><B><BR>We are on R/3 Release
4.7</B></FONT><FONT size=3> <BR></FONT><FONT face=sans-serif
size=2><BR><BR><BR>Mit freundlichen Grüßen / With kind regards / Met
vriendelijke groeten<BR><BR>Daniel Schorsch<BR>Business Consultant <BR>Philips
Healthcare IT<BR>Industrial Business Solutions international <BR><BR>Philips
Medical Systems DMC GmbH<BR>Röntgenstraße 24, D-22335 Hamburg<BR>H008<BR>Tel.:
+49/40/5078-1505<BR>Fax: +49/40/5078-1793<BR>email:
daniel.schorsch@philips.com<BR>http://www.philips.com/healthcare<BR><BR>Geschäftsführung/General
Management: Diedrich Dirks (Vorsitzender), Christoph Wittler; Sitz der
Gesellschaft/Registered Office: Hamburg; Registergericht/Registration court:
Hamburg, Reg.-Nr/Re. No: 66 HRB 77 839; Steuernummer/Local tax registration No.:
22/27/278/00800</FONT><FONT
size=2><TT>_______________________________________________<BR>SAP-WUG mailing
list<BR>SAP-WUG@mit.edu<BR>http://mailman.mit.edu/mailman/listinfo/sap-wug<BR></TT></FONT><BR></BODY></HTML>