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]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
