Mapping a "Name" to an Range
I setup a "Name" to a column range, and I want to reference it later on: Dim r As Range r = Application.Names("Changes").Something I've tried a bunch of "Something" but cannot get this right. Thanks. ...
excel-2003
Lock Excel Document after a certain Date
How can I cripple an excel document after a certain date? I want it to become unusable after, say, 12/31/2009. I was thinking about putting one of those Must Enable Macros things in there that hides all the sheets on close and leaves one tab that says you must enable macros. Then having an on open macro that unhides all those tabs, bu...
Using a formula from another column in Excel
I'll simplify this for example sake I have a formula in column B which is Ax + 2, e.g. in B1, it's A1 + 2 in B2, it's A2 + 2 I want to make a formula in column Y which mirrors whatever formula is in column B at all times but replaces the A in the formula with a X. e.g. in Y1, it's X1 + 2 in Y2, it's X2 + 2 No matter what...
How to insert data from an excel sheet into a database table??
Hi, I need to insert the data from an excel sheet into a teradata table. and I need this to be done using a MACRO. I have data in an excel sheet like COL1 COL2 COL3 COL4 1 2 3 4 2 5 8 10 . . so on and i need to keep a button in the excel sheet and assign a macro to that button so that when i click the button...
Calling a SQL Server 2000 Inline Table-Valued Function from Excel 2003 / MS Query
Hi, A large part of our user base accesses corporate data by building ODBC queries inside Excel 2003 using Microsoft Query. For the more complex stuff they often get me involved. There have been a number of occasions whereby I've decided that the most logical way to extract certain data would be to use an Inline Table-Valued Function ...
Excel: the Incredible Shrinking and Expanding Controls
Occasionally, I'll happen across a spreadsheet which suffers from magic buttons or listboxes which get bigger or smaller over time. Nothing in the code is instructing this. Has anybody else experienced this joy? ...
How to create excel add-in (excel 2003 or previous version) package with activeX dll?
Hi, guys, I am new to excel add-in prgramming and I am having a existing excel add-in project need to modify. The plug-in has 2 parts, one is programmed in VB and compiled into a ActiveX DLL file, the other part is inside the excel as an add-in. I already modified the source code of the DLL and recompiled a new DLL, but I don't know w...
Excel - Red Cross where a drop down list should be
Hello, anyone shed any light as to why this might be happening for one user but not another. Excel 2003 Macro security is set to low; spreadsheet is not read only. Everywhere where there is supposed to be a drop down list, instead of that there is a box with a red cross in it. Kind Regards, Jim ...
MS Excel 2003 - Simple unselect question in Excel VBA when dealing with shapes
So I have an excel workbook that has a global mapping scheme in it. So I have a shape for each and every country in excel. Depending on the region select, relative to the data/query, it will shade regions/countries in various ways. So I know how to manipulate each shape in terms of colors, gradient shading, etc.... What I don't know ho...
MS Excel 2003 VBA - Is there a way to define a group of shapes/object into a "group"
So I have this global mapping scheme, and each country on it are individual shapes. I learned how to manipulate colors/fill based on certain criteria. So the way I do this, or the way I know how is one shape/object at a time. For example USA is "C_USA", Canada is "C_CAN", etc. So is there a way I can define countries into groups?? ie. ...
Does anyone know of an XSL library for creating Excel files?
I would like to use XSL to create excel .xml files that Excel 2003 can open. Does anyone know of a XSL template library that I can use for the purpose? ...
XML Import in Excel 2003 Standard Edition
We have built an Excel 2003 template that asks the user to select an XML file which is then imported into an XML Map and used to populate a worksheet. Unfortunately it turns out that the users have Excel Standard Edition, which does not include the XML import functionality - namely the Workbook.XmlImport function. Users are able to ope...
How to edit my excel dropdown list ?
How to edit my excel dropdown list ? i went to Data>validation>Settings> In that i found the values as =Attribute_Brands What i have to do for editing this? ...
VSTO Excel add-in not loading on terminal server
My configuration is windows server 2003 (i'm logged in with admin privileges), office 2003, vtso runtime 2005 se. After installing my addin, all registry keys are in the correct locations and I have given fulltrust to my assembly using caspol.exe. My addin is a application level addin. When I run excel with regmon and filemon running I...
prime number in vba excel 2003
Hi I'm analyzing a code from the website and I tried it on my side as well but seems it doesn't work. Could you please tell me why? would greatly appreciate your help. Thanks Private Sub CommandButton1_Click() Dim N, D As Single Dim tag As String N = Cells(2, 2) Select Case N Case Is < 2 MsgBox "It is not ...
How do you delete rows in spreadsheet where condition met and location of condition unknown
I need to find the word Overdue" and Due in a spreadsheet but the column they appear in will be variable as will the number of records (rows). i need to delete all rows that do NOT have these values in the data - then total up the data left on the sheet after the others have been deleted - any clues? ...
How do you use the value of a named cell in a macro in a diferent sheet, same workbook?
I'm just not getting it, I'm using Excel 2003 and am totally confused as I'm jsut not getting it ...can anyone help? I need to check that named value with a number of coulumn headings on the active sheet and then insert a colum to the left of the column holding the matching text. I'm sure that bit is very hard - but I'm not even able t...
place a formula in active cell and autofil to end of data - can anyone help?
I'm trying to extend this formula and need some help I need to enter a sum fomula in row 3 of the new column created but don't know how to make it sum to a variable range to the left. and then I need to autofil the formula down to the end of the filled rows so that all the rows are calculated. Sub AddColumns() Dim lastcol As Long, ...
Trying to get pop up pictures for phone list in Excel
I have a simple phone list with columns in the form of Name, Address, Phone#, etc. On the last column I'd like to have the equivalent of a comment rollover which would automatically pop up the persons photo (there are many who only come to this group occasionally, and this would be a help in recognizing them and remembering their names) ...
Moving values from one sheet to another
I'm looking for an Excel 2003 macro to solve this problem. I have a sheet that holds financial information: A1 holds client names and AI1,AK1,AM1 etc, hold months April, May, June (all string values) etc; with the rows below that holding the amount due for the corresponding month. The last row is the total. What I need is to cre...