Programmatic access to visual basic project via Visual FoxPro
 

Does it mean that via FoxPro is no way to accomplish this, because of my
application is not a Visual Basic application?

No. This is a new security setting since Excel 2002. Users who want to run
your code should be asked to unselect this option under Tools, Macro,
Security, Trusted Publishers.

--
Jim
"Access to Visual Basic project via VFP" <Access to Visual Basic project via
wrote in message
...
| Following code called from Visual FoxPro application won't work:
|
| oxls = Createobject("Excel.application")
| oxls.Workbooks.Add()
| obook = oxls.ActiveWorkbook
| oproj = obook.VBProject && Error
|
| For Excel 2000 it works fine.
| But it causes an error for Excel 2003: "Programmatic access to Visual
Basic
| project is not trusted ..."
|
| Does it mean that via FoxPro is no way to accomplish this, because of my
| application is not a Visual Basic application? Or there is some way to
| digitally sign my FoxPro application?
|
| The reason of creating a macro dynamically is that I need to put in Excel
| Sheet cells Utf-8 characters and macro just reads data for that column
from
| plain text file created by FoxPro. If I try to do straight: assign FoxPro
| Utf-8 string to Sheet Cell object, some default translation (if string
| contains both latvian and russian characters, than latvian are correct,
but
| russian is not, because of windows default codepage).