SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

TIA VBscript v12 include object library Excel application

Created by: TOP Sity at: 8/4/2014 5:44 PM (5 Replies)

Rating (0)

Thanks 1

6 Entries

8/4/2014 5:44 PM	Rate (0)
TOP Sity Posts: 7 Rating: (0)	Please tell how you can connect the library to Excel in TIA WinCC v12. In the attached file shows how to connect to WinCC v7.0. Thank you! Attachment TT.jpg (466 Downloads)
TOP Sity Posts: 7 Rating: (0)
Suggestion To thank Quote Answer

8/5/2014 8:29 AM	Rate (0)
K!ke Posts: 1299 Rating: (136)	Hello, with WinCC v12 you can't use VBA. K!ke
K!ke Posts: 1299 Rating: (136)
Suggestion To thank Quote Answer

8/5/2014 4:47 PM	Rate (0)
TOP Sity Posts: 7 Rating: (0)	So VBA is present. There was a need to create a file excel and create graph. Reading data from the archive SQL and transfer in the Excel file is OK. The problem is with charting since Excel macro: ************************************** Range ("B4: F8"). Select Charts.Add ActiveChart.ChartType =63 ActiveChart.SetSourceData Source: = Sheets ("Temp"). Range ("B4: F8"), PlotBy: = _ xlColumns ActiveChart.Location Where: = xlLocationAsObject, Name: = "Temp" With ActiveChart . HasTitle = False . Axes (xlCategory, xlPrimary). HasTitle = False . Axes (xlValue, xlPrimary). HasTitle = False End With ************************************** can not be performed because there are no libraries, command CreateObject ("Excel.Application") does not help
TOP Sity Posts: 7 Rating: (0)	Last edited by: TOP Sity at: 8/5/2014 4:49 PM Last edited by: TOP Sity at: 8/5/2014 4:49 PM
Suggestion To thank Quote Answer

8/6/2014 7:14 AM	Rate (0)
K!ke Posts: 1299 Rating: (136)	Hello, you can use VBS to read and write data to excel. but you can't use VBA. K!ke
K!ke Posts: 1299 Rating: (136)
Suggestion To thank Quote Answer

8/6/2014 6:03 PM	Rate (0)
TOP Sity Posts: 7 Rating: (0)	So at this point the graphics are constructed with (!!! example): ……. Set ts = CreateObject("Excel.Application") ts.Visible = False ts.Workbooks.Add ……. ts.Worksheets(Name(1,1)).Select ts.Worksheets(Name(1,1)).Range("A10").Value = "Sept" ts.Worksheets(Name(1,1)).Range("A11").Value = "Oct" ts.Worksheets(Name(1,1)).Range("A12").Value = "Nov" ts.Worksheets(Name(1,1)).Range("A13").Value = "Dec" ts.Worksheets(Name(1,1)).Range("B10").Value = 10 ts.Worksheets(Name(1,1)).Range("B11").Value = 14 ts.Worksheets(Name(1,1)).Range("B12").Value = 33 ts.Worksheets(Name(1,1)).Range("B13").Value = 21 ts.Worksheets(Name(1,1)).Range("A10:B13").Select ts.Charts.Add ts.ActiveChart.Name=Name(1,1) & "_graph" ts.ActiveChart.ChartType = 63 ts.ActiveChart.PlotArea.Select ……. But the remaining three questions: 1) schedule is based on a separate sheet, it must be transferred to the specified page in the specified region 2) must be set for each parameter scale Y-axis !!! Tell me how does it perform VBS?
TOP Sity Posts: 7 Rating: (0)	Last edited by: TOP Sity at: 8/6/2014 6:08 PM Last edited by: TOP Sity at: 8/6/2014 6:07 PM
Suggestion To thank Quote Answer

8/11/2014 5:30 PM	Rate (0)
TOP Sity Posts: 7 Rating: (0)	Implement all possible !!! Thread Closed.
TOP Sity Posts: 7 Rating: (0)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users S_Moderator

Share this page:

Share this page on...

SiePortal

TIA VBscript v12 include object library Excel application

Created by: TOP Sity at: 8/4/2014 5:44 PM (5 Replies)

Rating (0)

Thanks 1

6 Entries

TOP Sity

Attachment

K!ke

TOP Sity

Last edited by: TOP Sity at: 8/5/2014 4:49 PM

Last edited by: TOP Sity at: 8/5/2014 4:49 PM

K!ke

TOP Sity

Last edited by: TOP Sity at: 8/6/2014 6:08 PM

Last edited by: TOP Sity at: 8/6/2014 6:07 PM

TOP Sity

This contribution was helpful to

6 Entries

Related topics by keywords:

Follow us on

SiePortal

TIA VBscript v12 include object library Excel application

Created by: TOP Sity at: 8/4/2014 5:44 PM (5 Replies)

Rating (0) Thanks 1

6 Entries

TOP Sity

Attachment

K!ke

TOP Sity

Last edited by: TOP Sity at: 8/5/2014 4:49 PM

Last edited by: TOP Sity at: 8/5/2014 4:49 PM

K!ke

TOP Sity

Last edited by: TOP Sity at: 8/6/2014 6:08 PM

Last edited by: TOP Sity at: 8/6/2014 6:07 PM

TOP Sity

This contribution was helpful to

6 Entries

Related topics by keywords:

Follow us on

Rating (0)

Thanks 1