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

    azohawk1,880 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...

    ITKE409,400 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...

    ITKE409,400 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:
  • DTS: Export to Excel

    I'm exporting a simple table to Excel but my problem is that the table columns will change every month since the column names will list month names (ex. May2009). Can I use ActiveX to dynamically create the transformation source? Please help!

    Stan100125 pointsBadges:
  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

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

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

Following