Programming

EXCEL Macro problem
I need to implement the following logic in excel vba. I will appreciate any ideas. Thanks Problem description - There are 5 dimensions along which a transfer of goods happens. Giver (G), giver channel (CH), account number (AC), taker (T), taker channel (CH) All of these can and do assume unique val... 14 Apr 2010 21:11

Excel 2007 dynamic chart range
The table below feeds a 3d Column Chart in Excel 2007. It needs to be dynamic, so when figures for 4/6/2010, 4/7/2010, etc are added the chart updates appropriately. The “4/1/2010” is in cell c1. There is a dynamic range in use, where c1.cc6 is named “dynRngSalesProg” … =OFFSET(SalesProgress!$C$1,0,0,6,COUN... 13 Apr 2010 12:50

Apply ADDRESS formula in VB
Hey Everyone, I got a quickie here. I have made this spreadsheet code using a lot of info on here. Now I wan to use it in VB. =ADDRESS(MATCH(Sheet2!$A$23,INDIRECT("'"&Sheet2!$A$19&"'!$B:$B"),0),MATCH(Sheet2!$A$14,INDIRECT("'"&Sheet2!$A$19&"'!$A$1:$V$1"),0)) What I want to do, is have the outcome of this formu... 14 Apr 2010 17:49

Copy sheets to new workbook - subscript error
G'day all you clever people, hope someone can help me I am using the code: ActiveSheet.Copy after:=Workbook("Example.xls").Sheets(i) to copy a dynamic selection of sheets from one workbook to another The code works just fine until the 18th sheet is copied across, then I get a subscript out of range error ... 13 Apr 2010 13:58

Find a Item & Copy the Data
Can someone please help me? I've got a huge SAP generated Parts List from overseas which I need to find a unique number in column A. (Sheet1) There are 10 columns and in excess of 55,000 rows This SAP Text number is comprised of 18 fixed digits (eg: 000000065202255411). However the number itself is variable w... 13 Apr 2010 07:17

Locale issue with union operator string (,)
The Excel union operator string is different for different locales (e.g. the semicolon ";" in France and the comma "," in the US). I want to read out Excel Ranges using A1-style notation using the union operator, e.g. Excel.Range myRange = get_Range("A1,A2,A3", missing); Thus I have to consider locales when a... 13 Apr 2010 07:17

update user name in excel on open
We have a standard build on our PC's that returns a generic user on excel if people havent updated their User Name details in the 'Tools', 'Options', 'General' tab. I want to be able to capture the users NT logon and write this to the user name field in excel so that it stores this permanantly whenever they op... 13 Apr 2010 06:12

Set destination sheet based on variable and paste data assistance
I have an excel book that works through each of the teams based on a range on the control sheet (Teamexports), opens its respective team file based on the date and filepath (Update_Data) and then I want it to copy the data to the named team tab already in place based on the value in the copied sheets range [B4]... 14 Apr 2010 12:12

Get External Data from Web
Hi I am pulling in currency exchange rate external data from a web site... no problems and storing the information on a worksheet. I have a userform with txtboxes that are linked to each of the cells. When the user form loads, the txtbox shows the currency exchange rate data imported in from the web site...... 13 Apr 2010 08:22

Advanced VBA Conditional Formatting & Field Population
I have a rather complex spreadsheet that I would like to automate. I'm sure it can be done, just not sure how. My workbook has 3 sheets, the first is a schedule broken up into blocks, left to right the blocks are labled by the day of the week (Monday, Tuesday...) Top to Bottom labeled by the week number (1, ... 10 May 2010 21:02