 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Excel Macro Using Template
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Excel Macro Using Template Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Excel Macro Using Template | Login/Join |
| Platinum Member |
Hello, i use a excel template for a report and i was able to establish the *.mht file and the report server finds the template. on the first sheet of the folder i have the data and on the second i have the macros behind two buttons. my problem is that the macro point on the old name of the excel file and so the macro doesn't find the code. "basis_emai.mht could not be found" is the error message. i hope my explanation was detailled enough´!! ChristianThis message has been edited. Last edited by: Kerry, WF Production Version: 7.7.02M WF Test Version: 7.7.02M Developer Studio: 7.7.02 HTML, EXL2K, FLEX, PDF,PPT | ||
|
| Expert |
Shouldn't the macros be pointing to cells the first sheet? Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
yes they do, i have two macros called "mail" and "save and close" but in the dialog to allocate the macros to the buttons the name of the file is always in the first place "basis_eMail.mht!Mail". and when i run the fex with output excel, the sheet appears when i click the button a message pop up which says that "basis_emai.mht could not be found" WF Production Version: 7.7.02M WF Test Version: 7.7.02M Developer Studio: 7.7.02 HTML, EXL2K, FLEX, PDF,PPT | |||
|
| Member |
Are you running the Macro from the WSERVLET Excel output without saving it? In one of my templates, I had to force the user to save the output locally before the macro would work correctly. I had a similar problem with Pivot Tables pointing to the template (and therefore failing) instead of the output workbook. Live and Direct from the University of Virginia. DevStudio 7.6.9 - WF-7.6.9 - Win2k3 - MRE - RC - MSSQL - XBOX-360 Elite - Playstation 3 - Wii - PSP - Nintendo DSi - iPod Touch - Suzuki B-King - Honda Valkyrie - Subaru WRX STI - Canon EOS 1D Mark IV - Lover of Toys. | |||
|
| Platinum Member |
Hello Llance, i did it your way and it works fine!!! i think the problem is solved!!! nice weekend to all Christian WF Production Version: 7.7.02M WF Test Version: 7.7.02M Developer Studio: 7.7.02 HTML, EXL2K, FLEX, PDF,PPT | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Excel Macro Using Template
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Excel Macro Using TemplateCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |