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

    azohawk610 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:
  • Microsoft Excel Graphing

    I need a line that is able to move. I want to grab it with my cursor and move it up and down on my bar graph. The bar graph is showing the zero to the max percentage of the percentage of income brackets for each year from 1913 to 2013. So there are 100 vertical columns (bars). The series of the...

    ITKE351,315 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...

    ITKE351,315 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...

    ITKE351,315 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:
  • Excel 2003 – Conditional Formatting Help

    Hi, I am working with a tracking schedule for my job, and I am trying to implement conditional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date Column C = Due Date -...

    Kelz82740 pointsBadges:
  • Excel macro

    I would like the user to be able to hover the mouse over a picture which then would enlarge to some defined size and then return when the mouse is moved off of the object.

    JH3935 pointsBadges:
  • Compare and merge workbook in Excel Program

    Salam! sir I'm zia from Pakistan. I'm a permanent user of office program but I still dont know how to compare two workgroups? Thanks. Waiting for your answer.

  • How can I transfer more than 16384 records into Excel 2003

    Hi All, I am trying to transfer a table with more than 20,000 records from Access 2003 to Excel 2003, The code I'm using within VB goes like this: Private Sub Allstock_excel_Click() Dim filename As String filename = "D:\Automotive_Rapore\Archives\AllstockReport\Allstock_" & Format(Now,...

    Kentster5 pointsBadges:
  • Convert an Excel spreadsheet to a Access database.

    My questions: How do I convert data from an excel spreadsheet to a Access Database? How do I convert a access form to excel - Using the form as a front for data capturing? How do I link multiple users to a access database - making allowance for data to flow simultaneously into the database?

    Joshua55 pointsBadges:
  • Access database table linked to Excel file question

    Can multiple instances of the same access database be open when linked to same excel file?

    SeenFresh25 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