vba 2010

I have a macro that I've been working on for months and I can't get it to work. I have gotten it to work with the first series, but only the first series in the chart are drawn on the chart. Here's how the chart looks: Here's the code to draw the chart (Excel 2010): Sub...

I am trying to get some help with a excel macro for exporting data from a closed file and importing into a summery file. I envision the summary file looking something like the below Structure with Folder and File Name listed and then cell reference names (from the "Name Manager") in the column...

Hello: I have a material list in Excel that has unique part numbers listed vertically (one for every cell in the column) - no duplicates - (list "A"). In another list - seperate tab - (list "B"), I have the same part numbers listed vertically but they are repeating; for every part number...

Hi Friends, I have 10,000 rows and unlimited data in columns. Two parameters in adjacent columns and are repeating after 13 unwanted columns. I want to concatenate these adjacent columns of a row separated by space eg: concatenate(B2,C2,"",P2,Q2,"",AC,AD,"",....) But I dont know upto which...

I need some help doing the following:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have Office Home and Business 2010, this is the version without Access, and I want to create a small macro that is triggered by clicking a floating button that only...

Hey guys... I want to check if the cell clicked is in the right column... and if not, then exit sub... This is the code: Dim lNum As Long On Error Resume Next Application.DisplayAlerts = False lNum = Application.InputBox _ (Prompt:="Ingrese la...

Hi, I have a code written in Excel VBA, and I a trying to Copy-paste slides from one PowerPoint file to another Power-Point file. But my code is doing regular Copy-Paste and as a result I am loosing some of the graphics. But when I am doing manually Copy-Paste (Paste as- Keep Source...

Hi All, I'm using the following code to open specific ribbons based on the Worksheet name (I've setup my RibbonUI's in the XML already). The code below opens up a particular ribbon based on the Worksheet Name or "CodeName" i.e. Sheet2: Private Sub Workbook_SheetActivate(ByVal Sh As Object)...

I have a general question and I'm not sure where to begin, literally. Can you please leave any direction at a fairly high level so I have the chance to try to figure it out for myself? Here's my initial plan, but here's the issue! I don't know where to start. Where would I begin with this? Would...

I want to update chart in powerpoint 2010 from Excel 2010. Code looks for name of range in excel and if same range name is found on power point slide it updates chart with data from excel. Problem is this code is not working in 2010, can you please help. Help with making this code work in...

Actually I need to write a program in Macros that insert a value if the conditions matches.. say for example, K(column name) = "BU Accessories" And AG(column name) = "APPAREL" And AM = "CCS" And AO = "Inline" And BL = "new" Then CE = "18 months" that is IF all the above mentioned conditions...

Hello, I have an excel file that has a list of 600 seperate hyperlinks ( they are JPG files), I am going in each line and opening each link then saving it as a JPG file in a folder on my desktop. Does anyone know how to write a VB macro that would open the link and save to the file? I...

Hello, I am an avid excel user. I love taking a business problem and creating a custom solution. I am fairly skilled in excel, anything from creating macros, to using functions, pivots, etc... I wish I had an understanding of VBA. As it stands today, if I want to use a macro, I record...

Hi! I created a macro for a file and first it was working fine, but today I've been oppening and restarting the file and macro hundreds of times and I'm allways guetting the following error: Excel VBA Run-time error '13' Type mismatch I didn't change anything in the macro so dont know why am I...

I am having some difficulty getting a routine to work and I am very new at trying to write macros so I don't quite understand what it means when it bombs out. What I am attempting to do is to write a macro that will increment the last number by 1, combine the current year to the number and...

Hi, I'd like to know if it's possible to copy and paste a pivot table with a customized design into a new tab leaving only the value and format using VBA. I tried copying and pasting as value and then format but failed, the custom design wasn't carried over as painted format (Font section in...

I've created a combobox and filled the data with values from a named range, called "Kunden_mit_Adresse". Here is my code: 'Set reference to the range of data to be filled Set rngSourceKunde = Worksheets("Kunden").Range("Kunden_mit_Adresse") 'Fill the listbox Set lbtarget =...

I was wondering if anyone can tell me why the following code works fine in Excel 2003 but not in Excel 2010. Here is the code: <TABLE style="WIDTH: 288pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=384 x:str><COLGROUP><COL style="WIDTH: 48pt" span=6...