<br><font size=2 face="sans-serif">Hi all,</font>
<br>
<br><font size=2 face="sans-serif">I would appreciate it if anybody could
help me out with the following problem:</font>
<br>
<br><font size=2 face="sans-serif">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 size=2 face="sans-serif">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 size=2 face="sans-serif">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 size=2 face="sans-serif">Unfortunately the macros were not triggered
at all as they were in the outside SAP world tests. :-(</font>
<br>
<br><font size=2 face="sans-serif">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 size=2 face="sans-serif">Do you have any ideas??? Please help
me out with this problem!!</font>
<br>
<br><font size=2 face="sans-serif"><b>We are on R/3 Release 4.7</b></font>
<br>
<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>