Document from Template + VBA

[Munday,Sherie J.]

Daniel,
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.
Anyone else have better experience?
Regards,
Sherie
 
Sherie Munday    
Workflow Developer/ Analyst
Air Products & Chemicals, Inc.

________________________________

From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Daniel Schorsch
Sent: Wednesday, April 23, 2008 3:08 AM
To: sap-wug at mit.edu
Subject: Document from Template + VBA



Hi all, 

I would appreciate it if anybody could help me out with the following problem: 

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. 

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). 

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. 
Unfortunately the macros were not triggered at all as they were in the outside SAP world tests. :-( 

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. 

Do you have any ideas??? Please help me out with this problem!! 

We are on R/3 Release 4.7 



Mit freundlichen Grüßen / With kind regards / Met vriendelijke groeten

Daniel Schorsch
Business Consultant 
Philips Healthcare IT
Industrial Business Solutions international 

Philips Medical Systems DMC GmbH
Röntgenstraße 24, D-22335 Hamburg
H008
Tel.: +49/40/5078-1505
Fax: +49/40/5078-1793
email: daniel.schorsch at philips.com
http://www.philips.com/healthcare

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20080423/92be37ad/attachment.htm