Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Error when opening Excel template

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Error when opening Excel template
 Login/Join
 
Suzy
Gold member
posted
I keep getting this error when trying to open a template.

(FOC3289) TEMPLATE FILE: Error opening file
(FOC009) INCOMPLETE REQUEST STATEMENT

 
TABLE FILE CAR
PRINT CAR
ON TABLE PCHOLD AS TEMP1 FORMAT EXL2K TEMPLATE 'dcc_template1.xlsm' SHEETNUMBER 1
ON TABLE SET BYDISPLAY ON
END
-RUN


Solaris 10 Sparc 64bit
WF 8.0.08

This message has been edited. Last edited by: <Kathryn Henning>,
 
Posts: 55 | Registered: September 08, 2010Report This Post
Rifaz
Guru
posted Hide Post
.xlsm/.xltm is extension for MS Office 2007 and above. So, your output format must be either EXL07 or XLSX(better). But, if you really need to use the EXL2K, then it should be .mht and have XP machine/MS Office 2003 to create new/enchancing it.


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
Suzy
Gold member
posted Hide Post
Thank you I think the issue was with the file that it was trying to open. I created a new template with three tabs with Pivot tables. I want to open the existing file and have the data refreshed. Is this possible? Right now I'm getting No query information to decode.


WebFOCUS 8.0.08
Solaris
HTML, PDF, XLS, CSV
 
Posts: 55 | Registered: September 08, 2010Report This Post
Suzy
Gold member
posted Hide Post
I created the pivot tables using a macro. When I open the file locally it runs fine. When I open it through a report the file is opening but the macro is not running. Any ideas? File is xlsm, created with Excel 2010.


WebFOCUS 8.0.08
Solaris
HTML, PDF, XLS, CSV
 
Posts: 55 | Registered: September 08, 2010Report This Post
Rifaz
Guru
posted Hide Post
It may help... Check the post posted by jvb " Excel template error..." recently.

http://forums.informationbuild...1057331/m/5167084676

Sorry, I m typing from phone


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
Suzy
Gold member
posted Hide Post
That was great help, thanks. I'm now getting it to open and run the macro.

It's failing now on this line:

Set objTable = ActiveSheet.PivotTableWizard

Cannot open PivotTable source file C:\.....\[filename(1).xlsm]Sheet1

Saving the file, then opening it works.


WebFOCUS 8.0.08
Solaris
HTML, PDF, XLS, CSV
 
Posts: 55 | Registered: September 08, 2010Report This Post
Suzy
Gold member
posted Hide Post
Figured it out, had to remove the [] in the filename.

Dim newPath As String

newPath = Replace(Replace(Application.ActiveWorkbook.FullName, "]", ")"), "[", "(")

If newPath <> ActiveWorkbook.FullName Then

Application.ActiveWorkbook.SaveAs (newPath)

End If


WebFOCUS 8.0.08
Solaris
HTML, PDF, XLS, CSV
 
Posts: 55 | Registered: September 08, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Error when opening Excel template

Copyright © 1996-2020 Information Builders