Search found 8 matches

by please_work
Mon May 09, 2016 5:55 am
Forum: Data Manipulation
Topic: Syntax for sheet and cell reference for range options in wf
Replies: 2
Views: 3778

Syntax for sheet and cell reference for range options in wf

Hello, I was wondering if it was possible to provide EViews with both a sheet and cell reference when using wfopen for Excel files. In the help documents, I have found examples for one or the other (e.g., range="Cleaned Sheet" and range=C5) but not for both at the same time. Is it possible...
by please_work
Mon Apr 28, 2014 11:53 am
Forum: Data Manipulation
Topic: Accessing Datastream
Replies: 5
Views: 10450

Re: Accessing Datastream

Got it - glad to hear I can make it work - thanks for the help!
by please_work
Fri Apr 25, 2014 9:29 am
Forum: Data Manipulation
Topic: Accessing Datastream
Replies: 5
Views: 10450

Re: Accessing Datastream

I was able to get the DSSeriesPicker downloaded, and did get a message saying it was successfully registered, but am still getting a "Database Error: unable to Datastream Series Picker library."

Any suggestions?
by please_work
Wed Apr 23, 2014 9:20 am
Forum: Data Manipulation
Topic: Accessing Datastream
Replies: 5
Views: 10450

Accessing Datastream

Hello, I am trying to create a working connection to Datastream. I was able to register the database, but when I open it (get message at bottom that username/password are validated) and try to run a test query (Query-Select), I get the following error message "Database Error: unable to load Dat...
by please_work
Wed Nov 30, 2011 3:03 pm
Forum: Programming
Topic: how to call an EViews program file from Excel VBA?
Replies: 4
Views: 7480

Re: how to call an EViews program file from Excel VBA?

I was able to get this to work without activating EViews Manager Set objShell = CreateObject("Wscript.Shell") objShell.Run ("C:\EViews_program.prg") Is there a location with a complete list of the command strings for EViews applications? Application.Run in particular If possible,...
by please_work
Wed Nov 30, 2011 2:26 pm
Forum: Programming
Topic: how to call an EViews program file from Excel VBA?
Replies: 4
Views: 7480

Re: how to call an EViews program file from Excel VBA?

Thanks - I did and it did call EViews.

However, it gave me the following error message

Run-time error '-2147023170 (800706be)':
Automation error
The remote procedure call failed

Any suggestions?

Thanks
by please_work
Wed Nov 30, 2011 2:09 pm
Forum: Programming
Topic: how to call an EViews program file from Excel VBA?
Replies: 4
Views: 7480

how to call an EViews program file from Excel VBA?

Hello, I am looking for an example to get me started running EViews programs from Excel VBA. I have seen the white paper and some of the posts related to calling and working with workfiles, but did not see anything with the .prg files. Below is what I have for workfiles, could someone please help me...

Go to advanced search