• Can Windows Explorer ‘File Types’ settings be amended by Group Policy?

    To enable our reporting software to correctly export to Excel 2007 (WXP SP2 operating system) we need to change the following Windows Explorer 'File Types' setting: Open windows explorer and navigate to the XLS file type and enable the "browse in same window" option, see path: \Tools\Folder...

    Redtyke130 pointsBadges:
  • Excel 2003 ranking with VLOOKUP

    I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy Heart 46% 24%...

    Jha9005 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 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:
  • 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 to upload data from Excel into SQL Server 2005

    hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav

    Ambrish 82310 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 using Excel VBA

    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 existing graph and paste the data in....

    Charm20 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 3B...

    PeteAtGlasshead5 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:

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