AnsweredAssumed Answered

vrf Help with doing neural network using VEE 8.5 student version

Question asked by VRFuser on Sep 18, 2008
Latest reply on Sep 18, 2008 by VRFuser


 

Amrik,

 

I don’t have Excel on my Vee machine, but I believe using the Excel Library with VEE you have to change

 

 

    Application.ActiveWindow.Visible = True

 

to

 

            xlApp.ActiveWindow.Visible = True

 

I presume you’ve tried that.

 

I tend to use Excel’s Object browser in Excel’s VBA Script Editor to find what I can do with Macros in Excel.  So if those commands don’t work, I’d look under Chart and ChartObject using the object browser.

 

A quick look revealed

 

Chart.Visible=True

 

Chart(“Chart1”).SizeWithWindow = True

 

ChartObject.Visible=True

 

And
 
With Charts("Chart1")
    .RightAngleAxes = True
    .AutoScaling = True
End With

           

 

Cheers,

Gary

 

  _____  

From: Amrik Sekhon [mailto:Amrik@GeePlus.Biz]
Sent: Wednesday, 17 September 2008 9:09 PM
To: VRF
Subject: RE: [vrf] Charts in Excel not visible

 

Hi Gary

 

Thanks for the info but i have already tried these commands with no affect.

 

Any other suggestions gladly accepted

 

Cheers

 

Amrik

 

  _____  

From: Voltz, Gary [mailto:gary.voltz@AirservicesAustralia.com]
Sent: 17 September 2008 02:28
To: Amrik Sekhon; VRF
Subject: RE: [vrf] Charts in Excel not visible

Amrik,

 

Below are 2 Excel Macro Commands that might help.

 

 

   ' This forces the Active Window to be visible.

    Application.ActiveWindow.Visible = True

  

    ' Zoom value in percent

    ActiveWindow.Zoom = 100

 

I know that there is another one that forces Excel to Maximise too.

 

Cheers,

Gary

 

Gary Voltz
SASTO4

Test Equipment and Maintenance and Calibration Centre

Facilities Management Services

Technology and Asset Services

Airservices Australia


E-mail: gary.voltz@airservicesaustralia.com

  _____  

Airservices Australia
Ph 1300 301 120       (within Australia)
Ph +61 7 3866 3382  (outside Australia) 
Fax +61 7 3866 3531
HYPERLINK "http://www.airservicesaustralia.com/"www.airservicesaustralia.com

CAUTION: This e-mail is confidential. If you are not the intended
recipient, you must not disclose or use the information contained
in it. If you have received this e-mail in error, please tell us
immediately by return e-mail and delete the document.

Airservices Australia does not represent, warrant or guarantee
that the integrity of this communication is free of errors, virus
or interference.

 

  _____  

From: Amrik Sekhon [mailto:Amrik@GeePlus.Biz]
Sent: Tuesday, 16 September 2008 10:17 PM
To: VRF
Subject: [vrf] Charts in Excel not visible

 

Hi All

 

When i create a chart in excel as a new sheet it is not visible or sometimes it is fomatted so that only the title is visible at about 30pt font size. I have tried to resize using drag of the mouse as well as the options in the view menu on the toolbar. However if i create the chart as an object on the sheet the formating is fine,alas i prefer not to do this since i have 6 graphs to display and i would prefer to have them as individual sheets.

 

I have a series of data points and i use macros in excel to create the charts. On my laptop they work fine and the formating is correct but on the test machine they are all messed up. I have attached pics of how the chart should look like (good) and bad charts for XL 03/07 as generated by my test machine.

 

I am using win XP SP2, I have tried using XL2003 and 2007 with differing results. I have tried this on 3 different machines and only one is problematic which also happens to be the main test machine, doh.

 

I have searched the archive and there is no info on this, so any pointers or help appreciated.

 

I can send my XL file to anyone should they require it.

 

Cheers

 

Amrik

 

 

 

 

 

 


---
You are currently subscribed to vrf as: gary.voltz@airservicesaustralia.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.169 / Virus Database: 270.6.21/1674 - Release Date: 16/09/2008 08:15


---
You are currently subscribed to vrf as: gary.voltz@airservicesaustralia.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".


---
You are currently subscribed to vrf as: hua_jing@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".  

Outcomes