• Excel 2007 Macros problem

    Hello, I am using Office 2007. The Macros are disabled when we open password Protected Workbook. What should we do?

    Mobilink115 pointsBadges:
  • Are you using Excel for cost estimating?

    Over at ConstructionSoftwareReview.com, we have noticed that a fair number of cost estimators, cost engineers and contractors in the construction industry use Excel to determine how much a particular project will cost and to prepare the cost estimate that they present to potential clients. Is...

    Beastwood1,105 pointsBadges:
  • How to link a macro by clicking on a cell of an Excel sheet

    I need to get the current time by clicking on the cell in Excel.

    78345 pointsBadges:
  • Date format in Microsoft Excel 2002

    In my program I pass values from VB to Excel for reporting. When I pass 03-01-2009 (3rd Jan 2009), in excel it shows as 01-03-2009. I have set short date format to dd-mm-yyyy, in control panel, regional settings. Also in excel, I set cell format through VB as ... Exl.Range("A1").NumberFormat =...

    Mayuri155 pointsBadges:
  • Exporting Exchange 2003 public folder calendar into Excel and then into a personel calendar.

    I need to export public folder calendar data into excel and them into a personal folder.

    Dre5 pointsBadges:
  • How do I export an Outlook 2007 public folder calendar to Excel?

    With Outlook 2007, I want to export from a calendar in a Public Folder into an Excel format. The Import/Export menu option only allows me to pick as a source for the export, a calendar in my personal folders. How do I export from a Public Folder calendar? This question was submitted by a...

    BrentSheets6,925 pointsBadges:
  • Export Outlook 2007 calendar to Excel spreadsheet

    How do I export Outlook calendar 2007 to Excel spreadsheet?

    Cwessner5 pointsBadges:
  • Lotus Notes calendar invitees into Excel spreadsheet

    I created an event with 8 separate invites because the group is that large. Now I'm supposed to turn the "accepted" responses from an email into their name and in an Excel spreadsheet. Would rather not comb through 1 by 1 through 1000s of names. Please help!!

    Brods135 pointsBadges:
  • Convert iSeries Character set in VB

    I am creating a VBA macro in an Excel spreadsheet to download selected data from an iSeries database. Running into an issue with character set. I don't understand VB well enough yet and have not had success w/ google in resolving this. I appear to be getting the data, but a lot of the fields are...

    azohawk970 pointsBadges:
  • Excel 2003 toolbar functions greyed out, but not Excel 2007

    I bought a new laptop which has a trial version of Office 2007. I have been using Office 2003 on this macjhine for a few weeks, & suddenly both excel 2003 & word 2003 have most functions greyed out, and excel and word are unusable. Excel & Word 2007 work fine (no protection is on). Could Office...

    Trevor1c5 pointsBadges:
  • How to send an Excel spreadsheet to Microsoft Exchange

    We currently have a user form that helps our users fill in data into a Excel spreadsheet. When the data is added in, it needs to be sent by email to several users. This is happening in a corporate organization that's using Microsoft Exchange. Now I need to create a new email account for the file so...

    ITKE355,460 pointsBadges:
  • Issues with Microsoft Office 2007

    OS: Vista Home Premium Here's a list of the issues I'm experiencing - very strange behavior. 1. When I try to open a .doc or .docx file from Windows explorer, word opens up, but doesn't display the document - just the grey default screen. When I open up word, and then open a file up from there, it...

    Mouse19995 pointsBadges:
  • Excel Function Help

    I am designing a spreadsheet to keep track of various data. I have a list of birthdays (month and day in separate columns) and I would like to pull the person's name that corresponds to the particular month. I have attempted to us the lookup function for this, but if there is more than one person...

    Trakaszcie5 pointsBadges:
  • Excel Calendars

    I have a schedule and would like to put the current months calendar as well as next months with cells that I can add info to for each day. Currently someone has to update the dates from month to month. Is there a way to have the calender update by just changing the Month and 1st date?

    Sandman00730 pointsBadges:
  • Extract Excel attachment on Exchange Server

    I have an Exchange email account that was created so I would receive daily emails with three different Microsoft Excel attachments. After I receive it, each Excel attachment needs to be saved in one of three different folders. Would I be able to automatically do this in Exchange Server? Or do I...

    ITKE355,460 pointsBadges:
  • How to upload data from Excel into SQL Server 2005

    Hi, Please tell me, how can I upload data from excel into SQL 2005 Thanks & regards, Ambrish Srivastav

    Ambrish 82310 pointsBadges:
  • Why does Excel reformat why character field?

    I have an 14 character field downloaded by cpytoimpf that creates a 14 character field containing "09101616574221" (it has the double quotes). When opened in Excel it is formatted as a General type field and contains "9.10162E+12". Why does Excel reformat the field. I have other all numeric text...

    philip49935 pointsBadges:
  • How to deal with Microsoft Excel text overflow

    Text that is too long for a cell can be handled in several different ways. What is the difference between: (1) Not giving Excel any instructions about what to do with the text overflow (2) Letting Excel go with text overflow?

    Bethsmith1210 pointsBadges:
  • Excel 2007 – formula or macro to show value from one cell next to a given reference

    Hope someone can help. I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it. EG - Sheet 1 has a cell with £500 in cell 3A The reference 1.01 is located in cell...

    PeteAtGlasshead5 pointsBadges:
  • How to recover an Excel file

    I did format my disk, but unfortunately, I also deleted an important excel file. I used getDataBack to recover that file, but when I get it back, I totally cannot read it, the data inside appear all like this...

    Devil5 pointsBadges:

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