excel 2010 vba

I need help trying to consolidate trial balance values from specific sub accounts into general accounts. I have tried many different loops, offsets, filters and copying combinations and have failed miserably. I am using Excel 2010 and running Windows 7 Professional. The example I want to do is...

Does anyone know if it's possible to distribute an Excel add-in in such a way that it can be easily updated without having to resend out the file to the users? I was considering packaging up some functions and distributing it, but I realized that ensuring everyone is on the latest version would...

Hi! i got an vba code from a excel and it calculate out the column number and change it to column name. but it just 2 chars. in excel we got column name like 3 chars. example 1 char is only A. 2 char AA and 3 is AAA i wonder some one can help me with the third char? here's the formula A =...

hi! i wonder if ther some how i can check if the start of the string is 0 and remove it så it start with a number insted. somthing like this 016.00123.000 006.00071.000 162.00003.000 012.00065.000 009.00012.000 224.00001.000 to 16.00123.000 6.00071.000 162.00003.000 12.00065.000...

hi! i'm trying to find the word emplyod and writ to differant column. but i get null from the case statement. Sub GetRow(sSelect As String, iRow As Long) Dim con As New ADODB.Connection Dim conString As String Dim RC As New ADODB.Recordset Dim Post As String con.Open...

Hi! i need a macro that change a table in a selection and connect to database and check how many rows it get with that selection. somthing like this. select employd1 eployd2 employd3 select name from table where name =...

Hi! I wonder if there any formular that take out precent of 4 combin nr? example 0 to 9 and the cell get a number and it will calculate out how many precent chance to get that number if its in random. cell1 cell2 cell3 cell4 procent 3 2...

Hi! In programming there is alot of code and your can solved a problem with many ways. I'm new in vba and when i programming i'm always wonder. what should i use and what should i not use in programming so the program not taking so much performance and memory. So what is good in programming and...

Hi i'm trying to get the selected x and y value and change it so they got x and y in a label. but i didn't manage it to work. Private Sub Label1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) Dim sPoint As Point If...

Hi! I'm trying to make that if the point is selected the label will show. but it's not working. the object doesn't work. it work when i have set spoint = selection. but if i have it like that i will get type missmatch all the time. sub test() dim ch as chart dim spoint as point...

Hi i'm trying to resize a label so the label get exactly same size as plot area. but it get bigger than it is. :( sub test() Dim sPoint As Point Dim ch As ChartObject Set ch = ActiveChart.Parent Set sPoint = Selection With Label1 .Left = ch.Chart.PlotArea.Left...

Hi! i wonder is there anyway to make the common control display by using excel vba? like Application.OperatingSystem to display os version. thx in advance

Hi! I was trying to check the file name in 2 column. And if it duplicate it should be mark green. and if it not duplicate it should be mark red. something like this. a.xlm b.xlm<---- green b.xlm a.xlm<---- green c.xlm <-----red but it marks every file name with gren. it...

Hi, I am a total beginner to this, having only learnt about VBA in the last 24 hours. However, this is what i'm trying to do: We have a workbook with several worksheets. Each one represents a different area of our factory. Currently they are used for auditing purposes, with questions, and a...

I'm sure any number of the members here can point out the code I need but my Google search (other search engines are available) has come up empty :eeek: I'm trying to execute a button on a custom ribbon in Excel 2010 that links to a macro (I can do this bit :)). The problem is that I'm not...

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)...

Hi all, I'm using Excel 2010, and the code below works but it's not optimal. I'm trying to create a vba code that attaches a chart into the body of an e-mail to be viewed by e-mail (outside of network) and iphone. Searching online, I found a way to export the chart into a...