Programming

pivot table to MS Access query
I have a pivot table in the spreadsheet to link from an Access query. For some reason, we moved the mdb to another directory. I need to change to link mdb file. I can change the link after I re link query for data only. I am unable to change the link for pivot table. Any information is great appreciated, ... 5 Feb 2010 11:42

Dynamic Array not response
Hi, After several attempts to run the codes below, it fails to copy each row of data in column A of sheet1 from workbookX instead it copied the last row of data only ( ie only response to last row in this array "rngtrg(m)" ) In fact, my intended codes is to copy each row of data in column A of sheet1 from workb... 7 Feb 2010 07:35

Input Box
How can I modify the macro below with input box code to replace "2008" by "2009" using an input box more easily - (i.e an input message to input 2008 followed by an input message to input 2009 thxs Sub Replacetext() Dim ws As Worksheet Dim longstr As String Dim i As Long For Each ws In ActiveWindow.Selecte... 5 Feb 2010 23:58

Excel 2003 VBA Phantom Breakpoints
Excel 2003 VBA Macro Anybody run into a phanton breakpoint in Excel? The code stops without an error. Hit continue and the code finishes w/o error. I have run into this in MSA and had to decompile. Is there a way to decompile Excel? Regards, Todd ... 4 Feb 2010 19:08

select range in column, calculate on range plus 3 columns, output inrange plus 7 columns
What version of Excel (only wanted to for the most up to date sorting code - the new code will not work in older versions but the old code will work in newer versions (I think))? -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: 558 View this thread: http... 11 Feb 2010 17:22

Excel 2007 VBA shape fill colour problem
I have a generic VBA routine that adds a specified shape to each cell within a target range on a worksheet and defines the Shape.Fill.ForeColor.SchemeColor property and the OnAction event. The OnAction event routine then toggles the Shape.Fill.Visible property on and off which should change the colour to the a... 8 Feb 2010 06:42

importing multiple text files into Excel with corresponding fi
Check out your other post. There is no need to multi-post . -- Jacob "avi" wrote: Correction: In addition I want EACH Excel ROW to show corresponding filename (where the data comes from). instead of .... EACH Excel column .... Files are comma delimited . ... 3 Feb 2010 07:15

Everchanging number of rows
Hi, Where am I going wrong on this piece of code below What I am trying to achieve in simple terms is this: Range("A2").Select ActiveCell.FormulaR1C1 = "1" Selection.Copy Range("A2:A10000").Select ActiveSheet.Paste But I need it to size with the amount of rows the rest of the data uses My ... 3 Feb 2010 09:28

Getting the next higer value with Vlookup - True
In VLookup / Hlookup function the True parameter gives the closest match with the search value but less than the search value.... i want to get the next greatest values of the Search Value.... how to do it.... Example ..... A B C 5 10 15 6 11 16 9 14 19 If i use =Vlookup(7,[Array],2,0)... 3 Feb 2010 07:15

find idmso custom tab in ribbon
Hi, Does any one know how i can find the idmso for a custom tab? In would like to hide a tab wich is created bij an add in so i'ts is not a default tab like idsmo="Tabhome" thanx ... 3 Feb 2010 12:53