<br><font size=2 face="sans-serif">Hi</font>
<br>
<br><font size=2 face="sans-serif">If they are 'Old' whats the New technology?</font>
<br>
<br><font size=2 face="sans-serif">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%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Munday,Sherie J."
<MUNDAYSJ@airproducts.com></b> </font>
<br><font size=1 face="sans-serif">Sent by: sap-wug-bounces@mit.edu</font>
<p><font size=1 face="sans-serif">23/04/2008 15:47</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
"SAP Workflow Users' Group" <sap-wug@mit.edu></font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif">"SAP Workflow Users' Group"
<sap-wug@mit.edu></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">RE: Document from Template + VBA</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2 color=blue face="Arial">Daniel,</font>
<br><font size=2 color=blue face="Arial">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 size=2 color=blue face="Arial">Anyone else have better experience?</font>
<br><font size=2 color=blue face="Arial">Regards,</font>
<br><font size=2 color=blue face="Arial">Sherie</font>
<br><font size=3> </font>
<br><font size=2 color=blue face="Arial">Sherie Munday </font>
<br><font size=2 color=blue face="Arial">Workflow Developer/ Analyst</font>
<br><font size=2 color=blue face="Arial">Air Products & Chemicals,
Inc.</font>
<br>
<br>
<hr><font size=2 face="Tahoma"><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 size=2 face="sans-serif"><br>
Hi all,</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
I would appreciate it if anybody could help me out with the following problem:</font><font size=3>
<br>
</font><font size=2 face="sans-serif"><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 size=2 face="sans-serif"><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 size=2 face="sans-serif"><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 size=2 face="sans-serif"><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 size=2 face="sans-serif"><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 size=2 face="sans-serif"><br>
Do you have any ideas??? Please help me out with this problem!!</font><font size=3>
<br>
</font><font size=2 face="sans-serif"><b><br>
We are on R/3 Release 4.7</b></font><font size=3> <br>
</font><font size=2 face="sans-serif"><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>