control excel from Agilent VEE with ActiveX

  • Thread starter Thread starter Angela Carrey
  • Start date Start date
A

Angela Carrey

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
 
Don't know what VEE is, but try adding parentheses...


ActiveChart.PlotArea.Fill.UserPicture(PictureFile:="C:\folder\myfile.bmp"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Excel 11.0 Object Library documentation? 0
Problems starting Word from Excel VBA 3
VBA fails with Run-time Error 429 "ActiveX component can't create object" 1
Referring to Excel objects in VSTO 2
Making .dll files for Excel 2010 8
Convert VB6 ActiveX Control to VB.NET And Incorporate it Into ASPX 0
Sending mail from Excel with CDO by Ron de Bruin 4
Why is Access VBA syntax different from Excel syntax? 2

Back
Top