Macro using Visual Basic
Using Visual Basic, I need to choose XYZ information in a cell, in Excel, and another cell must give me ABC predetermined information. How should I do that?

Answer Question   |  October 23, 2012  4:28 PM
Excel 2003, Excel 2003 macros, VBA, Visual Basic

vlookup
how can I convert then match two lists of numbers?   One list has thousands of 7 digit numbers.   The other list is even longer, but contains all of the numbers in the first list, looking at the first 7 digits of each.   The difference is, the numbers have an additional digit on the end.

Answer Question   |  March 6, 2012  11:09 PM
Excel 2003, Excel 2003 VLOOKUP function, Microsoft Excel 2003, VLOOKUP function

Excel .xla slow to save
I have a custom toolbar saved as an .xla.  Works great.  It has always taken about 1 – 2 min. to save the .xla.  But about two weeks ago the save time increased significantly. It now takes over 12 mins. to save.  Any ideas.  I haven’t added much in the last month.  Tried rebooting machine.  [...]

Answer Question   |  October 30, 2011  1:47 PM
Excel 2003, Excel Toolbars, Windows XP, XLA

Oracle Forms 6i – Export to Excel
Hi All, I have an application on Oracle forms 6i, which is having 1 form to download reports in excel format. It works fine with excel 2003 but when require to work with excel 2010, it doesn’t work. Please help me, please send your answer at – sachin81jain@yahoo.com

Answer Question   |  February 22, 2011  12:34 PM
Excel 2003, Excel 2010, Excel Compatibility, Oracle Forms, Oracle Forms 6i

One formula for a single column in Excel 2003
I am using MS Excel 2003. I have a spreadsheet with the exactly the same formula in every cell of a given column (This is possible by using the row() and the indirect() funtions). The spreadsheet is using 6000 rows. Currently, I have copied the formula into each cell. This increases the calculation time of [...]

Answer Question   |  August 18, 2011  4:54 PM
Excel 2003, Excel 2003 formulas, Excel formulas

In Excel how to autofill a cell that references a list?
I have defined a list. Now I am at the drop down on another sheet.  Instead of scrolling to the item in the list…  (a very long list), I would like to be able to start typing a few letters, and the lists shortens to just that initial input.  Much like a combo box can [...]

Answer Question   |  May 10, 2012  1:42 PM
ComboBox, Excel 2003, Excel 2003 functions, VB.NET

Converting Oracle Report 6i into Excel
the problem is in report the data is correct but when i try to convert into excell the dupicate rows are beuing formesd..i also did a page protect variation but report changes but not the converted file. if i have 50 records on page 1 then in report it shws 50 rows only but in [...]

Answer Question   |  January 21, 2011  10:55 AM
Excel 2003, Office 2003, Oracle Reports 6i, Oracle Reports 6i to Excel

Change fonts in drop down box created with autofilter in Excel 2003
1. Is there a way to change the font size of the an auto filter drop down box?

Answer Question   |  December 21, 2010  8:43 PM
autofilter, DropDownList, Excel 2003, Visual Basic

Message Alert Box in Excel 2003
I have a two files, one is the consolidated time monitoring and the other file is the individual time monitoring. The individual time monitoring file has 30 sheets which is the name of each agent and in shared mode. On that file, agents are responsible to provide/indicate the things that they’ve done everyday…for the whole week. [...]

Answer Question   |  December 25, 2010  10:30 AM
Excel 2003, Excel 2003 functions, Excel 2003 macros, Excel macros

Unlocking VBA project using VBA code
Can i use vba code to unlock my x-cel vba project protected by password? I need to unprotect my project to add some code and then reprotect it.

Answer Question   |  December 25, 2010  3:29 PM
Excel 2003, Excel 2003 functions, Excel VBA, VBA, Visual Basic

Excel 2003 Macros with Org Chart Parent
Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the [...]

Answer Question   |  March 11, 2011  3:53 PM
Excel 2003, Excel 2003 macros, Excel macros, Excel Tables, Excel VBA, Macros

Cell Automated Population using Excel macro
Hi, is there a way in macro wherein if a certain cell has value, the other cells will be automatically populated? Example: In cell E6 I put the date, cell A6, B6,C6 and D6 will automatically copy the values in A4, B4, C4 and D4. Same goes when I enter the date on cell E7. Thank you [...]

Answer Question   |  December 8, 2010  8:33 AM
Excel 2003, Excel macros, Excel VBA, Visual Basic

reformatting a multi-tab spreadsheet and access 2003
Hi,    I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access [...]

Answer Question   |  December 1, 2010  2:41 PM
Access 2003, Excel 2003, Excel worksheets, Record Format Level Identifier

VBA Excel 2003 Copy and Paste
I would like to know how am i going to copy a certain range (A1:E500) in File A and paste it in a different file (File B). Then copy a new range in other sheet of File A then paste it in File B without overlapping the data I copied from the first range. Thank you [...]

Answer Question   |  November 16, 2010  4:08 PM
Excel 2003, Excel VBA, VBA, VBA EXCEL 2003

Qmf for Windows 8.1 fp18 – date datatype from db2 z/os 8 format error in excel 2003
When I import a DB2 z/OS query result  containing date or date(timestamp) columns from QMF for WINDOWS in EXCEL 2003 using the Add-in the cells cannot be formatted. In the same column the date are displayed sometimes as dd/mm/yyyy, sometimes as nnnnn or in the previously defined format (example dd-month ) if exists. The first [...]

Answer Question   |  December 20, 2010  10:56 AM
DB2, Excel 2003, Excel 2003 formulas, QMF, QMF V8, Windows XP SP2, z/OS

Error message on startup of Excel 2003 workbook
Could anyone tell me what the following error message means and how i could fix it? Cannot find XLQUERY.XLA!Register.DClick, which has been assigned to run each time [file name]key is opened. Continuing could cause errors. Cancel opening [file name]key?

Answer Question   |  May 18, 2011  11:51 AM
Excel 2003, Excel error messages, Excel workbooks, XLA

Edit-Find Excel 2003
I prepared an Excel 2003 file containing about 10 spreadsheets for a company whose name appeared in the spreadsheets. The sheets contain confidential information about the company the file was sent to. I now wish to send this file to others having deleted the name of the original company for reasons of confidentiality with the [...]

Answer Question   |  October 30, 2010  12:24 PM
Excel 2003, Excel 2003 functions, Excel functions, Excel worksheets, Windows XP

Pulling information from one spreadsheet into another spreadsheet.
We have two spreadsheets created and spreadsheet b has referenced totals from certain columns from spreadsheet a. The problem is that the spreadsheets are maintaned by 2 different people. And throughout the day spreadsheet a gets new information added to it, how can this information be brought into spreadsheet b without closing and reopening spreadsheet [...]

Answer Question   |  October 4, 2010  7:19 PM
Excel 2003, Excel 2003 functions, Excel functions, Excel worksheets

Excel date format
I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.

Answer Question   |  September 22, 2010  1:15 PM
Database migration, Excel 2003, Excel 2003 functions, Excel Database

Excel affecting other windows
When one of the employees that I deal with saves or copies a document in excel, it closes all open windows on the desktop and doesn’t save or copy the document. This issue is intermitant. Any ideas?

Answer Question   |  September 16, 2010  1:02 PM
Excel 2003, Excel 2003 functions, Excel error messages, Windows XP