Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
control excel from Agilent VEE with ActiveX
Hello,
(I just found out about this website today and I just joined, so please excuse and inform me of any protocol missteps I might make). If anyone can answer the following question I'd be grateful. I am trying to send a command from VEE to Excel using ActiveX. So far I have done this successfully by recording a macro in Excel, and then copying/pasting the Visual Basic text into a VEE formula box. However, when the Visual Basic text includes a method with arguments, VEE doesn't like the syntax. The syntax in Visual Basic is: ActiveChart.PlotArea.Fill.UserPicture PictureFile:= "C:\folder\myfile.bmp" VEE doesn't seem to like the space between UserPicture and PictureFile. Thanks very much, Angela *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
control excel from Agilent VEE with ActiveX
Don't know what VEE is, but try adding parentheses...
ActiveChart.PlotArea.Fill.UserPicture(PictureFile: ="C:\folder\myfile.bmp" -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Excel 2007 text box (ActiveX Control) | Excel Worksheet Functions | |||
Excel 2000 ActiveX Control Problem | Excel Discussion (Misc queries) | |||
How to add an ActiveX control in Excel? | Excel Worksheet Functions | |||
how do you use the ActiveX Calendar control in an Excel Worksheet. | Excel Worksheet Functions |