<!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=971404314-23042008><FONT face=Arial
color=#0000ff size=2>Daniel,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=971404314-23042008><FONT face=Arial
color=#0000ff 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></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=971404314-23042008><FONT face=Arial
color=#0000ff size=2>Anyone else have better experience?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=971404314-23042008><FONT face=Arial
color=#0000ff size=2>Regards,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=971404314-23042008><FONT face=Arial
color=#0000ff size=2>Sherie</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=971404314-23042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=971404314-23042008><FONT face=Arial
color=#0000ff size=2>Sherie Munday </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=971404314-23042008><FONT face=Arial
color=#0000ff size=2>Workflow Developer/ Analyst</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=971404314-23042008><FONT face=Arial
color=#0000ff size=2>Air Products & Chemicals, Inc.</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>Daniel
Schorsch<BR><B>Sent:</B> Wednesday, April 23, 2008 3:08 AM<BR><B>To:</B>
sap-wug@mit.edu<BR><B>Subject:</B> Document from Template +
VBA<BR></FONT><BR></DIV>
<DIV></DIV><BR><FONT face=sans-serif size=2>Hi all,</FONT> <BR><BR><FONT
face=sans-serif size=2>I would appreciate it if anybody could help me out with
the following problem:</FONT> <BR><BR><FONT face=sans-serif size=2>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> <BR><BR><FONT face=sans-serif size=2>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><BR><BR><FONT
face=sans-serif size=2>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> <BR><FONT face=sans-serif
size=2>Unfortunately the macros were not triggered at all as they were in the
outside SAP world tests. :-(</FONT> <BR><BR><FONT face=sans-serif size=2>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> <BR><BR><FONT face=sans-serif
size=2>Do you have any ideas??? Please help me out with this problem!!</FONT>
<BR><BR><FONT face=sans-serif size=2><B>We are on R/3 Release 4.7</B></FONT>
<BR><BR><FONT face=sans-serif size=2><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></BODY></HTML>