<br><font size=2 face="sans-serif">Hi Sherie,</font>
<br>
<br><font size=2 face="sans-serif">thanks for your input. Although it might
be not the newest way of working it will be (unfortunately) the prefered
one in this case :-( . </font>
<br>
<br><font size=2 face="sans-serif">So as I stated: VBA works well within
the Excel Sheets after opening the document in any step in the workflow.
The only problem is to trigger a VBA code within the Excel sheet when I
select the "Save" button from the SAP GUI to finish the workflow
step. I just need to do some validation within Excel.</font>
<br><font size=2 face="sans-serif"><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>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=33%>
<br>
<br>
<br>
<br>
<br><font size=1 face="sans-serif"><b>"Munday,Sherie J." <MUNDAYSJ@airproducts.com></b>
</font>
<p><font size=1 face="sans-serif">Sent by:</font>
<br><font size=1 face="sans-serif">sap-wug-bounces@mit.edu</font>
<p><font size=1 face="sans-serif">23.04.2008 17:19</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=66%>
<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>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">Classification</font></div>
<td></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<div align=right>
<br></div></table>
<br>
<br>
<br><font size=2 color=blue face="Arial">Hi John,</font>
<br><font size=2 color=blue face="Arial">I was thinking of Adobe and other
web forms like MSS PCR forms allowing for more functionality than the old
document from template.</font>
<br><font size=2 color=blue face="Arial">Cheers,</font>
<br><font size=2 color=blue face="Arial">Sherie</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>John A Haworth<b><br>
Sent:</b> Wednesday, April 23, 2008 11:06 AM<b><br>
To:</b> SAP Workflow Users' Group<b><br>
Subject:</b> RE: Document from Template + VBA</font><font size=3><br>
</font>
<br><font size=2 face="sans-serif"><br>
Hi</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
If they are 'Old' whats the New technology?</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
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>
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------</font><font size=3><br>
<br>
<br>
</font>
<table width=100%>
<tr valign=top>
<td width=51%><font size=1 face="sans-serif"><b>"Munday,Sherie J."
<MUNDAYSJ@airproducts.com></b> <br>
Sent by: sap-wug-bounces@mit.edu</font><font size=3> </font>
<p><font size=1 face="sans-serif">23/04/2008 15:47</font><font size=3>
</font>
<br>
<table border=4 width=100%>
<tr valign=top>
<td width=100% 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>
<p>
<td width=48%>
<br>
<table width=100%>
<tr valign=top>
<td width=13%>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td width=86%><font size=1 face="sans-serif">"SAP Workflow Users'
Group" <sap-wug@mit.edu></font><font size=3> </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>
<br>
<table width=100%>
<tr valign=top>
<td width=49%>
<td width=50%></table>
<br></table>
<br><font size=3><br>
<br>
</font><font size=2 color=blue face="Arial"><br>
Daniel,</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
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><font size=3>
</font><font size=2 color=blue face="Arial"><br>
Anyone else have better experience?</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
Regards,</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
Sherie</font><font size=3> <br>
</font><font size=2 color=blue face="Arial"><br>
Sherie Munday </font><font size=3> </font><font size=2 color=blue face="Arial"><br>
Workflow Developer/ Analyst</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
Air Products & Chemicals, Inc.</font><font size=3> <br>
<br>
</font>
<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><font size=2 face="sans-serif"><br>
<br>
Hi all,</font><font size=3> </font><font size=2 face="sans-serif"><br>
<br>
I would appreciate it if anybody could help me out with the following problem:</font><font size=3>
</font><font size=2 face="sans-serif"><br>
<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> </font><font size=2 face="sans-serif"><br>
<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). <br>
<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> </font><font size=2 face="sans-serif"><br>
<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>
</font><font size=2 face="sans-serif"><br>
<br>
Do you have any ideas??? Please help me out with this problem!!</font><font size=3>
</font><font size=2 face="sans-serif"><b><br>
<br>
We are on R/3 Release 4.7</b></font><font size=3> </font><font size=2 face="sans-serif"><br>
<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</tt></font><font size=3><br>
</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>