Richard,
I think your questions are going to be better placed on the Protel
Developers mailing list (subscribe at Techserv). There is bugger all
traffic on it due to the non-release of the P99SE SDK (it is still in
pre-release or maybe that is never-release).
Your questions would be apt there though, and, there are a number of good
Protel developers on the list.
As for your question - I am not sure but I suspect that you cannot automate
Protel from Excel/VBA (actually I should rephrase that as cannot
practically automate). Reason: Protel is not an OLE server or a
COM-whichety or whatever automation buzzword it is this week. Protel has
its own internal Client Basic and Delphi-based SDK interface that can
certainly access all the spread processes *but* there is no current method
of access for any other programming language.
Wouldn't a COM interface be nice - then we could all use whichever language
we liked. I have no info at all this way or that but i would not be
surprised if the next version of Protel starts moving to industry standard
automation rather than a proprietary SDK. But maybe this is just wishful
thinking. Maybe there are severe performance problems with COM that Protel
are aware of.
Ian Wilson
On 10:37 AM 26/09/2001 +0100, Richard Thompson said:
>Hi Ian and others
>
>Thanks for your help, script now works fine.
>
>I can't seem to find details on how to pass stuff from protel and how to
>activate different windows/servers.
>
>I have the BOM window open in protel (spread) i have assigned my macro to a
>button within the spreadsheet etc. What is the process or how do i get
>protel to make sure the spread sheet is active and copy the entire contents
>to the clipboard?
>
>I know that in excel all i need is
>
> dim excel7 as object
> set excel7 = createobject("excel.application")
> excel7.visible=true
> workbook=excel7.workbooks.open("test.xls")
> worksheet=workbook.worksheets(1)
> worksheet.Range("A1").Select
> worksheet.Paste
>
>etc.
>
>how do i stuff it back into protel?
>
>set protel = createobject("protel.application")??? can't find this
>anywhere, or how to activate a .xls window
>
>Thanks very much, appreciated a lot.
>
>Rich
>
>
>
> > The Application.DisplayAlerts property may help - check out the on-line
> > help.
> >
> > Also there is :
> > Application.Interactive
> > and
> > Application.AlertBeforeOverwriting
> >
> > One of these properties may help.
> >
> > Ian
> >
> >
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* To post a message: mailto:[EMAIL PROTECTED]
*
* To leave this list visit:
* http://www.techservinc.com/protelusers/leave.html
*
* Contact the list manager:
* mailto:[EMAIL PROTECTED]
*
* Forum Guidelines Rules:
* http://www.techservinc.com/protelusers/forumrules.html
*
* Browse or Search previous postings:
* http://www.mail-archive.com/[email protected]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
