Replace changes in Excel
I use thousands of references to spreadsheets that don’t exist yet (but will eventually)in conjunction with the IfError function: =IfError(“path and name of future file”,0,”path and name of future file, tab name and cell reference”). I’m copying a workbook with lots of formulas like this and prepping for the our next fiscal year. Excel no [...]

Answer Question   |  February 28, 2012  7:54 PM
Excel workbooks, Excel worksheets, Microsoft Excel 2007

VB for Excel
I have an Excel Workbook (Template) inkl VB Modules and Forms. I want to export the Modules & Forms so that it can be stored at one place, but accessible from several Workbooks (different Periods etc) of the same type. How do I do this?

Answer Question   |  November 29, 2010  9:09 AM
excel, Excel workbooks, VBE, Visual Basic

VBA Excel dates
Why can I not make VBA Excel write me the date I put in the code, rather it shows always 00/01/1900 pls? See I wrote a short code that fills in the woorkbook (sheet), the date (any date) as a responce to a week number. The problem is that the code is only returning one [...]

Answer Question   |  November 15, 2010  2:59 PM
Excel workbooks, VBA, Visual Basic, Visual Basic Error Messages

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

Export Outlook 2007 calendar to Excel spreadsheet
how do I export outlook calendar 2007 to excel spreadsheet

Answer Question   |  October 27, 2010  1:28 PM
Excel workbooks, Outlook 2007 calendar, Outlook calendar, Windows Vista

Workbook sheets
How do you send a copy of only the sheet vs. the entire workbook to someone?

Answer Question   |  August 16, 2010  1:18 PM
excel, Excel import/export, Excel workbooks, Excel worksheets

Can you view an older version of a spreadsheet?
I accidentally saved a new spreadsheet over an existing spreadsheet, and I was wondering if there was a way to view an old version or retrieve the version I saved over. I’m panicking!!

Answer Question   |  April 30, 2009  5:31 PM
Excel workbooks, Microsoft Excel

Cell Formatting Protection
How do I protect a cell (or series of cells) from being re-formatted, and yet allow the user to Sort and Copy the Data within the spreadsheet? When I LOCK the cell(s), then protect the Worksheet and contents of locked cell, I allow them to Select Locked Cells, Select Unlocked Cells, Delete Rows, Insert Rows, [...]

Answer Question   |  April 3, 2009  2:43 PM
Excel Cell Formatting, Excel workbooks, Microsoft Excel

Looping to create new workbooks using a set “transaction” number
I’m playing around a bit and can’t figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 – 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when “.SaveAs Filename:=Start” comes back around [...]

Answer Question   |  August 12, 2009  10:49 PM
Excel VBA, Excel workbooks, LOOP statement, Microsoft Excel 2003, Sequence number generation, VBA, Visual Basic for Applications

Deleting Excel Worksheets with macro
I am using excel 2000 and have workbook that uses macro to delete several worksheets and then save the workbook under a name in one of the cells. All works fine but for each worksheet a quiery pops up to ask if you want to delet this sheet. How do I delete sheets in the [...]

Answer Question   |  December 31, 2008  12:38 AM
Excel 2000, Excel 2000 macros, Excel macros, Excel workbooks, Excel worksheets, Microsoft Excel, Microsoft Excel 2000, Microsoft Excel 2000 macros

Excel 2007 Crashes
I am using Excel 2007 working in a workbook that has forms for each census year. In the form I put the data for the family name that I am researching, these forms might be several hundred lines to several thousand lines each. Size of each census year may vary. There is quite a bit [...]

Answer Question   |  December 5, 2008  2:57 PM
Excel 2007, Excel workbooks, Microsoft Excel

Import text from another excel workbook
I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to [...]

Answer Question   |  November 13, 2008  1:54 PM
Excel 2003, Excel functions, Excel macros, Excel workbooks, Macros

Excel 2003 linking text format in two workbooks
I have 8 different workbooks that are linked to one master workbook. In each of the 8 workbooks people need to select certain names and change the text format to bold. however when the master workbook is open and updated the BOLD format is not there. Each of the 8 workbooks are changed monthly with [...]

Answer Question   |  May 31, 2008  6:58 PM
Excel 2003, Excel formulas, Excel workbooks, Linking workbooks