Re^2: Help using Win32::OLE to add Excel charts having multiple series

Replies are listed 'Best First'.
Re^3: Help using Win32::OLE to add Excel charts having multiple series by marto (Cardinal) on Feb 23, 2010 at 10:54 UTC
See Re: How to convert the VBA code to Perl code?.	[reply]
Re^3: Help using Win32::OLE to add Excel charts having multiple series by Anonymous Monk on Feb 23, 2010 at 06:48 UTC
Um, no. Please ask a clear and coherent actual question, then you can get help in writing, as opposed to someone just writing something for you (and guessing and guessing).	[reply]
Re^4: Help using Win32::OLE to add Excel charts having multiple series by Anonymous Monk on Feb 24, 2010 at 13:40 UTC
`How to translate following VBA code to perl code Charts.Add ActiveChart.ChartType = xlXYScatterSmoothNoMarkers ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues = "='Sheet1'!R2C1:R801C1" ActiveChart.SeriesCollection(1).Values = "='Sheet1'!R2C2:R801C2"` [download]	[reply] [d/l]
Re^5: Help using Win32::OLE to add Excel charts having multiple series by Anonymous Monk on Feb 27, 2010 at 00:06 UTC
You take the vbscript code, change dots to arrows, add parens around strings, replace single quotes(') with pound sign (#) ... and you're finished. Win32::OLE The behavior of Win32::OLE->new Using Win32::OLE and Excel - Tips and Tricks http://www.perl.com/pub/a/2005/04/21/win32ole.html, Re: perl library for controlling Windows GUI (like AutoIt) Re: Write to WIndows Event Log Re: How to get location of Desktop folder on Win32 Read and write Windows "shortcut" links Where is the Win32::OLE Docs	[reply]