Search found 9 matches

by CecileBF
Wed Feb 14, 2024 3:34 am
Forum: Data Manipulation
Topic: Automatic update of a workfile based on Excel files
Replies: 4
Views: 453

Re: Automatic update of a workfile based on Excel files

Thank you! I tried and it works for me that way as well too.
But I create a workfile before this step and the problem re-appears now:
wfcreate(wf=TRANSITION\dbpmi, page=m) m 1992 2040
by CecileBF
Wed Feb 07, 2024 8:14 am
Forum: Data Manipulation
Topic: Automatic update of a workfile based on Excel files
Replies: 4
Views: 453

Re: Automatic update of a workfile based on Excel files

The file is based on data from IHS Markit (for information).
Regards,
Cecile
by CecileBF
Fri Feb 02, 2024 2:57 am
Forum: Data Manipulation
Topic: Automatic update of a workfile based on Excel files
Replies: 4
Views: 453

Automatic update of a workfile based on Excel files

Hi, I created a program to import some series from an Excel file. Basically, the import code is built that way: import(link) \\intra\partages\FOLDER\PMI_ALL_manuf.xlsx range="Monthly PMIs" colhead=8 namepos=custom colheadnames=(,"Name","Geography","Major Sector&quo...
by CecileBF
Thu Jan 04, 2024 2:33 am
Forum: Programming
Topic: Occasional problems with special pasting in powerpoint
Replies: 2
Views: 11477

Re: Occasional problems with special pasting in powerpoint

Thank you! So I guess since the cause remains unknown, there is no clue on ways to avoid them? Or are there ways to prevent them?
Or should I contact Microsoft directly?
by CecileBF
Fri Dec 29, 2023 9:03 am
Forum: Programming
Topic: Occasional problems with special pasting in powerpoint
Replies: 2
Views: 11477

Occasional problems with special pasting in powerpoint

Hi, I used the special pasting as Object Linking and Embedding (OLE) for integrating graphs in a powerpoint presentation which I and my colleagues update regularly. It works quite well, however sometimes, especially as I am manipulating the original workfile, the graphs can disappear. It seems to be...
by CecileBF
Tue Oct 17, 2023 2:39 am
Forum: Data Manipulation
Topic: Changing date format in graphs
Replies: 5
Views: 22111

Re: Changing date format in graphs

Thank you, it is very helpful! By the way, is there a way to code this option (for interoperability of programs with my colleagues)?
by CecileBF
Wed Oct 11, 2023 8:43 am
Forum: Data Manipulation
Topic: Changing date format in graphs
Replies: 5
Views: 22111

Re: Changing date format in graphs

Can you help me do this? Here are the typical lines I write before to determine the most recent date (which I then report in the graph's title) of at least one of the series on the graph: %seriesdugraph="eme_detteprivee adv_detteprivee dettetotale" group seriesgraph {%seriesdugraph} series...
by CecileBF
Tue Oct 10, 2023 12:40 am
Forum: Data Manipulation
Topic: Changing date format in graphs
Replies: 5
Views: 22111

Changing date format in graphs

Hi, I use floating text to indicate my last point on subtitles of graph. Basically, here are typical lines I would write: {%g}.addtext(t,font(calibri,14,b)) "Dette privée (% de PIB mondial)" {%g}.addtext(1.80, -0.32,font(calibri,12), keep) Source: BRI, dernier point: {%last} %last referrin...
by CecileBF
Mon Apr 03, 2023 5:49 am
Forum: Programming
Topic: Conditional Formatting in Tables
Replies: 3
Views: 4842

Re: Conditional Formatting in Tables

Is that "no" still true with Eviews13? And in that case, is there any plan to add conditonal formatting in future versions of Eviews?

Go to advanced search