Search found 5 matches

by dan.solverud@gov.se
Tue May 03, 2016 8:11 am
Forum: Programming
Topic: Import unstructured data from excel
Replies: 3
Views: 3286

Re: Import unstructured data from excel

I have reach the conclusion that the problem probably is not that EViews interpret the file as containing structured data, but rather that it does not interpret or import the data at all, if I do not have the excel file opened in advance. I am not sure of what kind of example I should provide you wi...
by dan.solverud@gov.se
Tue May 03, 2016 4:17 am
Forum: Programming
Topic: Import unstructured data from excel
Replies: 3
Views: 3286

Import unstructured data from excel

If I try to import unstructured data from an excel sheet via the wfopen-command, I have to open the excel file before I execute the command. If I run the command without first opening the excel file EViews will create a structured workfile page. What is the reason for this? Is there a way around thi...
by dan.solverud@gov.se
Thu Sep 10, 2015 12:58 am
Forum: Programming
Topic: OLEDB Driver problem
Replies: 1
Views: 2452

OLEDB Driver problem

I have stumbled over a curious problem when I try to read series via OLEDB driver. Most of the time it works out without any problems, but in at least one case it just won’t work if I try to include dates. I use the same OLEDBconnection string (cs) and I use the same string to retrieve the series (c...
by dan.solverud@gov.se
Mon Oct 06, 2014 10:18 am
Forum: Programming
Topic: VBA reference library
Replies: 3
Views: 4469

Re: VBA reference library

Thank you, your code sample works on my machine as well. I tried to solve the tasks (adding and removing) in different sub's, which I could not get to work, but if I follow your example to put both the adding and the removing command in the same sub it works just fine.
by dan.solverud@gov.se
Mon Oct 06, 2014 5:15 am
Forum: Programming
Topic: VBA reference library
Replies: 3
Views: 4469

VBA reference library

Since not all users on the office LAN have EViews installed I need to use VBA to activate and deactivate the EViews 8.0 Type Library. While the activation goes splendid, the deactivation of the reference library is failing. To activate I use the command vbProj.References.AddFromFile "C:\Program...

Go to advanced search