LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default 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).


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
programmatic access to visual basic project is not trusted Rob Kings Excel Programming 4 June 23rd 06 12:10 PM
Trust Access to Visual Basic Project Farah[_7_] Excel Programming 0 November 7th 05 01:17 PM
Programmatic Access to Visual Basic Project is not Trusted Anson[_2_] Excel Programming 2 July 20th 04 02:12 PM
'Programmatic access to Visual Basic project is not trusted.' message Joe Excel Programming 1 February 13th 04 03:19 PM
Allow access to visual basic project netzig Excel Programming 2 February 4th 04 06:06 PM


All times are GMT +1. The time now is 03:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"