hai i am populating the data from ms access to excel through vba .My db contain number of group detail i wants to seperate the group members during the population time the problem is that at the end of the each group i wants to insert 2 row in the excel sheet i am using the below mentioned code but i does not work is any possible ? Di...
Hi, I have a mesurement which is an average and it mapped as a CalculatedMember to support aggregate tables: <Measure name="AverageFullPercent_sum" column="fullDockPercent" datatype="Numeric" aggregator="sum" visible="false"> </Measure> <Measure name="AverageFullPercent_count" column="fullDockPercent" datatype="Numeric" aggregator="coun...
I am using the MDB as backend, frontend using vb. When i am retriving the output in excel the result provide the output the result with field names. I only need the result, how can i avoid the field name display for that. I am new in this MDB and vb. Please help me for a query providing the result without field names. ...
I am trying to Transpose all of column "B", but want to skip a line then grab the next 4 and paste them in the same column. How can I make this loop all of column "B" skipping every 5th line and change the range to the next open cell or "Range" automatically without manually typing each one individually? Range("B12:B16").Select Sel...
For some reason I am getting a lot of spaces in front of each value while trying to print to a flat text file. 'append headers Cells(start_row - 2, 1).Select For i = 1 To ActiveCell.SpecialCells(xlLastCell).Column If ActiveCell.Offset(0, 1).Column = ActiveCell.SpecialCells(xlLastCell).Column Then Print #finalCSV, Cells(start...
I have developed code which identifies the multiple item selections from a Pivot field and writes the list of items to a table. I then wish to take this contents of the list and use it to populate a number of other Pivot Tables on other tabs. I currently have the ability to do this for single Pivot items selections, but I need to do th...
When I import an HTML document into Excel, if there is more than one table in the HTML document Excel puts the tables on the same worksheet one after the other. Is there a way to tell Excel to put each table on its own worksheet? ...
i am adding data from vba excel using adodb into a mysql database everything works great but is slow. the entire process takes about 5 seconds. i believe the reason it is slow is because i am filtering it: Dim rowid_batchinfo As String rs.Filter = "datapath='" + dpath + "' and analystname='" + aname + "' and reportname='" + rname + "'...
Hi, What would be the equivalent Excel formula of this SQL query SELECT SUM(a) FROM table WHERE b < 0; A B ---- ---- 1 0 2 -1 3 4 5 -3 >> 7 ...
i asked the question of whether an index would help me: http://stackoverflow.com/questions/2961834/should-i-be-creating-an-index-for-this i understand that since i am adding code every time in this procedure, i would need to re-index. in this case is it even worth it to index every time? ...
Hi, I am trying to write VBA code which works on my Excel sheet. Range("A65536").End(xlUp).Row gives me the row number of the last non blank cell. similarly i am trying to get the row number of the first non blank cell in that particular column. Thanks in advance. madhu ...
I'm curious how to best approach this situation. I have an old VBA workbook that works just fine as is. Unfortunately with the new security measures in Office 2007/2010 you get the "Security Warning Some active content has been disabled" message. I know that I can click on the message and select enable content or add it to a trusted l...
i have an excel template and there was a chart there, I was confuse on how can I call that chart when I'm coding in vb.net.. Can anyone help me on how can I call the chart for me to set the new value to fill the chart.. It is possible to call? ...
I want to count the no. of cells in a row or column based of their background colors, e.g. how many are Red background, how many are Blue etc in a range of cells ...
I have what seems like a simple problem with some data in Excel. I have a lot of data with leading spaces pasted from a web table, and I would like to get rid of the initial space. I cribbed the following code (I am completely new to VBA), but it doesn't seem to work. When I step through it in the debugger it looks like an infinite loop....
How can i implement Excel COMBIN function in SQL 2005, either in a store procedure or in a function. About COMBIN function in Excel follow this Link. Thanks. ...
Hai i have an excel sheet, in that i need to calculate some values in row wise first i set the values in the starting cell(A1) from that i wants to fill the formula in next 10 cell continously in row wise(A1,B1,...). i already use the code to fill the formula in column wise the code is below Range("Q5" & Range("Q65000").End(xlUp).Row)....
I'm trying to read a 17MB excel file (2003) with PHPExcel1.7.3c, but it crushes already while loading the file, after exceeding the 120 seconds limit I have. Is there another library that can do it more efficiently? I have no need in styling, I only need it to support UTF8. Thanks for your help ...
I want to calculate some statistics. In order to calculate the average of certain values of a column, I use AverageIfs(). Now I want to calculate the median for the same values. But there is no MedianIfs() function. Is there a simple solution to calculate the median for values that hold certain conditions (2 conditions)? ...
I can set up an autofilter using pyWin32, but I wondered if it's possible to set a default filter and what the syntax would be. For example, I'd like to set a filter on a year column and set the default for the current year. xl = Dispatch("Excel.Application") xl.Workbooks.Open(file_path) xl.ActiveWorkbook.Worksheets(sheetname).Range...