VBA Excel: The specified dimension is not valid for the current chart type -


I am trying to save the Axel diagram with VBA as the image I call multiple workbooks with the whole code Let me see all the worksheets and save all the pictures. The following code works with Excel 2007 and 2010 (but there is a horizon and a vertical line is visible due to + 4). If I change round (SP width + 4, 0) to round (SP width, 0) then I get the following error in 2010 (but not in 2007):

Run-time error -2147467259 (80004005) ': The specified dimension for the current chart type is not valid. 

  Worksheet set as Shape Sheet in the form of shak sht = Application.ActiveWorkbook.Sheets (shtName) set shp = sht.Shapes (chrtName) shp.CopyPicture xlScreen, xlBitmap Dim objChart Activate the chart object as objChart = Sht.ChartObjects.Add (200, 200, round (shp.Width + 4, 0), round (shp.Height + 4, 0) objChart.ActiveChart. Activate ActivePart.Paste file Name: = Full text, Filtername: = true (full text, 3) objChart.Delete   
 Does anyone know how I can use 4?  
 The following was found:  
 "The problem occurs whenever the default For example, if you try to create a line chart and if the default chart in Excel is OHLC (Candlestick Stock Chart) then Excel will complain that you are trying to create the chart type other than those you are trying to create. Will be faster for "the specified dimension is not valid for the current chart type." That happens whenever you try to create a chart from VB.NET. Therefore, first of all, Dassault chart type will be resolved as a change in the basic chart type line chart. " 
 But I do not know how to do it with VBA.   
 
 
 Use the  
  set objChart = Worksheet.Shapes.AddChart2 () chart.Parent   
 instead of  
 < Code> Set up objChart = worksheet .ChartObjects.Add ()   
 The former task allows you to specify a basic chart type in the second argument.   < / Html>

Comments

Post a Comment

Popular posts from this blog

java - NullPointerException for a 2d Array -

नक्शा = नया बफर्ड इमेज [चौड़ाई] [ऊंचाई]; के लिए (int i = 0; i & lt; height; i ++) {for (int j = 0; j & lt; चौड़ाई; j ++) {if (charMap [j] [i] == पर्वत। इंडेंटफार्म) {if (j + 1 & lt ; चौड़ाई और amp; amp; j-1 & gt; = 0) {if (charMap [j-1] [i]! = पर्वत। इंडेंटिफ़ायर & amp; amp; & amp; amp; charMap [j + 1] [i]! = पर्वत। इंडेंटफार्म) {नक्शा [जे] [आई] = टाइल ग्रिड [1] [10]; }} और {नक्शा [जे] [आई] = टाइल ग्रिड [8] [10]; }}} यह कोड है जिसे मैं सेल के चारों ओर प्रत्येक टाइल को चेक करके 2 डी सर की जांच करने के लिए उपयोग कर रहा हूं लेकिन मुझे लगता है कि किसी को भी सोच रहा हूँ मदद कर सकता है? मुझे संदेह है कि आपको NullPointerException को charMap [j] से प्राप्त हो रहा है [ I] == पर्वत। इंडेंटिफ़ायर लाइन। सुनिश्चित करें कि आप ज्योफ द्वारा सुझाए गए दोनों मानचित्रों के लिए आंतरिक सरणियों को प्रारंभ करते हैं।
Read more

python - Assemble mpeg file unable to play in mediaplayer -

I am currently working on a school project and I think that is to gather some problems with the MPEG file I The scope of my project is: 1) Split the MPEG file into pieces of many fixed sizes. 2) Collecting some of them and leaving some part. Problem 1: When I run the file in the media player, it will play the video until it reaches that segment which I left Give it Example: Chunk = ["yui_1", "yui_2", "yui_3", "yui_5", "yui_6"] Duration of each segment: 1 second * If you think I have left the "yui_4" section. * If I went to collect all the parts except "yui_4", then the video will play the first 2 seconds before being hanged throughout the period. Problem 2: When I gather the first part off the part, it is unable to run the full MPEG file is. Duration of each piece: 1 second Example: wheel = ["yui_2", "yui_3", "yui_4", "yui_5", "yui_6"...
Read more

c# - NameSpace Manager or XsltContent to parse aspx page -

How can I use the namespace manager or XSLT content to parse the aspx page? I am using HtmlAgilityPack I am trying to parse the aspx page to get the button and label control ID. When I try to select a node with the asp: button element, I get the following error Here is the error message: Namespace Manager or XsltContext is required This query contains a prefix, variable, or user-defined function. HtmlAgilityPack.HtmlDocument htmldoc = new HtmlAgilityPack.HtmlDocument (); String filePath = @ "C: \ webform4.aspx"; Htmldoc.load (filepath); Foreach (html.doc.DocumentNode.SelectNodes ("// div") in HtmlNode div) {Response.Write (div.Id); HtmlNode ASP ("asp: button") in foreach (div.SelectNodes) {Response.Write (asp.Id); }} My aspx page looks like: & lt;% @page language = "c #" autoevolutionwireup = "true" codebahind = "Webform 4 Aspx.cs" Inheritance = "WebApplication 1.WebForm4"%> & Lt ;...
Read more