• 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 cell referencing

    What is absolute cell referencing and how is it beneficial in excel

    Xxrerexx10 pointsBadges:
  • ExcelSource file – metadata validation

    I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output columns...

    Mayre5 pointsBadges:
  • Does Apache POI-XSSF support Excel 2007 runs under Java 1.4?

    Hi Guys, Is Apache XSSF POI supports java 1.4 to upload the Excel 2007. Thankx.

    Ansipar288315 pointsBadges:
  • I am getting “compiler error in hidden module” error in Excel 2003 while running Macro

    I am getting :"compiler error in hidden module " error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !

    Shirishbidarkar5 pointsBadges:
  • Complex Database Issue

    I'll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is "roughly" the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table (at minimum, 25 tables) can...

    Mreed725 pointsBadges:
  • Export multiple values from Notes to Domino

    Hi, is it possible to export a Notes view that has a column with multiple values, separated by comma, to excel? Thanks for any helo. Michelle

    Michelleanderson5 pointsBadges:
  • import data from excel 2007 to iseries

    how do you import data from excel 2007 to iseries

    JimC11285 pointsBadges:
  • Excel macro between worksheets

    I have an Excel Workbook with a "Paid" sheet and an "Outstanding" sheet, both sheets have a File Number column. I would like to create a macro that looks through the "Outstanding" sheet and if the File Number from the "Outstanding" sheet is also in the "Paid" sheet can the entire row be deleted...

    Adavidson5 pointsBadges:
  • new to macros – extracting data

    Hello, I'm just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box(course...

    Oistins2610 pointsBadges:
  • How to send mail to multipie recipients from lotus using excel macro

    Hi , I am using following code right now for sending mail from lotus using excel macro for single client its working fine Sub SendLotusNotesMail() Dim UserName As String Dim MailDbName As String Dim Maildb As Object Dim MailDoc As Object Dim AttachME As Object Dim Session1 As Object Dim EmbedObj1...

    Sh3210 pointsBadges:
  • excel 2007

    I am trying to use non-adjacent ranges to setup a clustered column with 3D visual effect option by pressing the ctrl key and selecting my ranges and every time I get the box saying one can't use the chart with information selected, what am I doing wrong?

    Lisa1005 pointsBadges:
  • How to paste data directly from Excel to PowerPoint graphic as data

    I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste the data in. Any help...

    Charm20 pointsBadges:
  • find which excel spreadsheets contain macros

    in a folder or drive how can I find which excel spreadsheets contain macros without opening every one individually?

    FreemaG5 pointsBadges:
  • Excel Macro to parse list of excel files and move them depending on a single cells value

    Does anyone know how to creat an Excel macro that I can run on a directory of excel files that will look for a value of cell B47 and if it's > 600 move it to another directory and if it's < 600 move it to another one?

    Kferranti5 pointsBadges:
  • How to paste data directly from Excel to PowerPoint graphic as data

    I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste the data in. Any help...

    Charm20 pointsBadges:
  • AS/400 to Excel

    Hi Someone, I am using FTP to send a data file fromthe iseries to the server as a .txt file usint put statement. Can anyone suggest how I would sent the file direct to an Excel spreadsheet, preferable to a pre-formatted sheet. Thanks.

    tjgm88995 pointsBadges:
  • Converting spool file output to Excel in RPG without third-party software

    I would like to know how to write an RPG program and have my spool file output be converted to an Excel file without using any 3rd-party software.

    AS400 - Ask the Expert485 pointsBadges:
  • Export from database to Excel and filter by DropDownList

    please provide me with all information on how to export my data to an excel sheet and how to filter the data using a dropdownlist (asp.net)

    Yaz5 pointsBadges:
  • Excel 2000 Chart Won’t Automatically Update

    My Excel 2000 chart won't automatically update when I change the data in one/both of the columns in the attached spreadsheet. I have checked the automatic button under Tools/Option/Calculate, but it still does not work. The only way I can get it to work is if I go into the chart and change one of...

    Bacham5235 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