Programming

To get the same header,footer and sheet titles across multiple she
To the best of my knowledge, Rows to repeat at top and Columns to repeat at left must belong to the actual worksheet being printed. You cannot use the rows or columns from another worksheet. However, you can use a value from another worksheet when setting a Header/Footer because these ar only string values. ... 24 Feb 2010 02:04

Full Script for Excel Spreadsheet Import Automation
I know this post is really old and I doubt I will get a reply.. Can you post your working script for excel spreadsheets? This is exactly what I have been looking for. Good work! Phil Hibbs wrote: Fixed it - I cannot use the module name as a collection index, I needto loop 07-Jan-10 Fixed it - I cannot use... 24 Feb 2010 05:21

To get the same header,footer and sheet titles across multiple sheets of a workbook.
Dear Friends, I want a workbook to have the same header (as some cell value of a sheet in workbook) and similarly same titles (rows and columns titles) in different sheets. I reached to the following code. It worked well for the header (and also footer) but it didn't work for the rows to repeat at top or columns t... 23 Feb 2010 22:45

rt error 1004
The below is a result of performing the Record Macro sys. But when I run it again -- I get a r/t error 1004; Any ideas? TIA, Jim Code: Sub Macro3() ' ' Macro3 Macro ' ' Range("A5").Select ActiveSheet.PivotTables("PivotTable2").PivotFields("Report Description Caption" _ ).PivotFilters.... 23 Feb 2010 20:32

Force PasteSpecialValues in Excel 2007
There was a very nice piece of code written by Aaron Bush (Oorang on MrExcel) in 2007 which disabled cut and copy execution in excel, forcing the copy to copy only values but maintaining the ability to undo (http://www.vbaexpress.com/kb/getarticle.php?kb_id=957). Unfortunately, this code fails in several ways i... 27 Feb 2010 21:00

WaitForString Mutiple Conditions
Have you tried setting the Wait parameter to true? myscreen.SendKeys ("<CLEAR>", wait:=true) -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=181944 [url=&quot;http://www.thecodecag... 23 Feb 2010 18:15

Prohibit duplicate data in a cell
I need to prohibit the use of duplicate part numbers in a certain range of cells. Using the worksheet_change event, I create an array of all existing part numbers. I can then go thru that array and compare it with the value of the cell that the user just typed a part number into. If I find that the part nu... 23 Feb 2010 17:05

macro to update last character
We are using Excel 2007. We have a large list of id numbers that will need the last character changed from a 1 to 2. The length of the list will always vary but will always be in Column G. For example: 11323674US01 11321507US01 11378181US01 need to be updated to: 11323674US02 11321507US02 11378181US02 ... 23 Feb 2010 15:53

Value Metadata
Hi How can I check (using VBA) if a cell has some metadata associated (as described here: http://msdn.microsoft.com/en-us/library/dd953161.aspx). I ask because I have an xlsx file with data that when opened in Excel 2007 shows values only. But when I save the same file in xls format and open it in Excel 2003 ... 25 Feb 2010 12:34

Excel 2003 VBA program kills itself in Japan
Hi, I wrote a VBA program for an Excel workbook. This program works just fine on my PC (US English setup), but my japanese collegues have problems. We observed that the VBA program changes on a japanese PC to the extent that syntax errors occur. This is how it happens: My code looks like this: ------------... 3 Mar 2010 11:51