1
  • 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...

    AenE15 pointsBadges:
  • Export Outlook 2007 calendar to Excel spreadsheet

    How do I export Outlook calendar 2007 to Excel spreadsheet?

    Cwessner5 pointsBadges:
  • 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...

    Bossann5 pointsBadges:
  • 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?

    Cjones055 pointsBadges:
  • 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?

    OWE9995 pointsBadges:
  • 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 single meaningless value of...

    Biggener5 pointsBadges:
  • Workbook sheets

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

    Jrhoads5 pointsBadges:
  • 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...

    McNitro255 pointsBadges:
  • 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!!

    Bluebloomie5 pointsBadges:
  • 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,...

    Cdixon20005 pointsBadges:
  • 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 macro without having this...

    Rbloxsom5 pointsBadges:
  • 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 of formatting,...

    Mwellis15 pointsBadges:
  • 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...

    Carourke15 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following