AnsweredAssumed Answered

vrf ActiveX command from VEE to Excel which contains method & arguments

Question asked by gregwale on Aug 22, 2004
<html><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII"><meta name=Generator content="Microsoft Word 10 (filtered)"><style><!-- /* Font Definitions */ @font-face     {font-family:Tahoma;     panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal     {margin:0in;     margin-bottom:.0001pt;     font-size:12.0pt;     font-family:"Times New Roman";}a:link, span.MsoHyperlink     {color:blue;     text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed     {color:blue;     text-decoration:underline;}p     {margin-right:0in;     margin-left:0in;     font-size:12.0pt;     font-family:"Times New Roman";}span.EmailStyle18     {font-family:Arial;     color:navy;}@page Section1     {size:8.5in 11.0in;     margin:1.0in 1.25in 1.0in 1.25in;}div.Section1     {page:Section1;}--></style></head><body lang=EN-US link=blue vlink=blue><div class=Section1><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Rebecca,</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Don’t use the colon in VEE. Use ‘=’if it is a property setting, and use parens if it is a method. Also, in thehelp file, check for other arguments that don’t appear in the VBA fromthe macro recorder. VBA will use the “:=” to skip over arguments,but VEE cannot do that. Try to fill them all in from VEE. There are othertricks to use here if you cannot fill them all in.  You can install theExcel help file from the Office Installation CD by selecting I think OfficeCommon components and looking for the help files. Then in the help file findwhatever property or method you get from the Macro Recorder and see if it is aproperty or method. Don’t forget to put semicolons at the end of each VEEformula line. (Except you don’t need one on the last line). </span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Or you can take a look at the Vxl add-inat <a href="http://www.passtechnologies.com/">www.passtechnologies.com</a></span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Regards,</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Greg</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----
<b><span style='font-weight:bold'>From:</span></b> rebecca smiar[mailto:utah772002@yahoo.com]
<b><span style='font-weight:bold'>Sent:</span></b> </span></font><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>Friday, August 20, 2004</span></font><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> </span></font><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>11:18 AM</span></font><fontsize=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
<b><span style='font-weight:bold'>Subject:</span></b> ActiveX command from VEEto Excel which contains method & arguments</span></font></p><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p><div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Hi All,</span></font></p></div><div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>   I was wondering if anyone knows the correct format forsending an ActiveX command from VEE to Excel which contains a method andarguments?</span></font></p></div><div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>   So far I have recorded macros in Excel and cut and pastedthe Visual Basic text into VEE formula boxes, which has worked except whenthere's a method with arguments.</span></font></p></div><div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>   A specific example is trying to change attributes of anExcel Chart. The Visual Basic text from the recorded macro reads:</span></font></p></div><div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p></div><div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>ActiveChart.plotarea.Fill.UserPicturePictureFile:= "C:myfoldermyfile.bmp"
ActiveChart.plotareaFfill.Visible = True</span></font></p></div><div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p></div><div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>   VEE doesn't seem to like either the space betweenUserPicture and PictureFile, or else the :=. I've already tried everycombination I can think of (putting parenthesis, no colon, sending the argumenton an input pin as text). The macro was recorded by right clicking on the plotarea of the chart, choosing "format plot area" (not "formatchart area", that's what you see if you clicked on the chart area outsideof the plot area), click "fill effects", choose "picturetab", then "select picture".</span></font></p></div><div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>   Thanks very much,</span></font></p></div><div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>   Rebecca</span></font></p></div><div class=MsoNormal align=center style='text-align:center'><font size=3face="Times New Roman"><span style='font-size:12.0pt'><hr size=1 width="100%" align=center></span></font></div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Do you Yahoo!?
<ahref="http://us.rd.yahoo.com/mail_us/taglines/100/*http:/promotions.yahoo.com/new_mail/static/efficiency.html">Newand Improved Yahoo! Mail</a> - 100MB free storage!</span></font></p></div></div>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list,  email "vrf@agilent.com".  <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></html>  

Outcomes