Programming

Reference to values disappear after closing file
When I use this formula in a worksheet: =INDIRECT(ADDRESS(COLUMN()+5,4,,,"C:\Temp\[januari_2010.XLS]sheet1")) The values disappear after closing the file januari_2010.xls and the error #REF! appears. Apparently this formula can't keep the reference when the file is closed But when I use this formula ... 24 Feb 2010 14:18

Retrieving current custom sort settings
Is there a way to retrieve the current custom sort settings stored with a worksheet? ... 24 Feb 2010 14:18

Database to Excel REF#!
Hello, I have a spreadsheet that feeds from a database. If it meets the criteria of an "HL" call in a particular field, it shows on the spreadsheet, no problem. What the spreadsheet is for it to notify when and "HL" call comes up so the user can handle the call quickly. They change it from "HL" to a variety... 24 Feb 2010 16:35

Suggestions to start programming in Excel
Hello group, Can you please suggest me any web sites which will teach programming for beginners. Easy and simple to understand. ... 24 Feb 2010 13:10

disabling specific items under tools menu
Hi All, I know l can disable the 'Options' menu using code something like: Application.CommandBars("Tools").Controls("Options").Enabled = False But what l would like to do is specifically disable JUST the following choices on the View tab: Row & column headers Outline symbols If somebody can pointme in... 24 Feb 2010 12:01

Exporting Data to Excel
I am trying to export data into an excel spreadsheet. Is there a way using VBA to automatically set up the sheet and have the data import? Or would I have to use commands such as List Columns and List Rows? Any help will be appreciated. ... 24 Feb 2010 12:01

Projecto VBA
Será que me poderiam ajudar. O meu ficheiro informa ao abrir: "Este livro perdeu o respectivo projecto VBA, os controlos ActiveX e outras funcionalidades relacionadas com a programação". Obrigado. Acácio Bike ... 24 Feb 2010 10:53

copy paste fail
I don't know what causes this but sometimes "paste" option on the right click is greyed. Not always but it is very irritating. There are several macros belonging to workbook. Can they be the reason ? How can i make "paste" option functional again. Any help ? ... 25 Feb 2010 08:03

Automatically Sorting of Excel Records
Greetings! I am working in a good IT company under the quality management team. May I ask how can I automatically sort an array of records using macros based on categories and heirarchy of scores? Then generate a separate sheet for it as well? Here is a simple example of a record array found in sheet1 named... 24 Feb 2010 07:32

user to input date as "yyyy" in cell
I have a time series chart feeding off user input data. The data and chart are dates (eg: 01/01/2007 00:00:00) displayed as years (eg: 2007). I need the chart x-axis to remain as a time series. The user perceives that the cell contains "2007". Is there a way to enter just "2007" (4 characters only) and obtain a... 24 Feb 2010 06:27