• problem converting time stored in text datatype to time format in EXCEL

    Hi, Anyone has any idea to convert the time stored in text to time format in excel e.g. 0838 0825

    Leyenda15 pointsBadges:
  • Replace changes in Excel

    I use thousands of references to spreadsheets that don't exist yet (but will eventually)in conjunction with the IfError function: =IfError("path and name of future file",0,"path and name of future file, tab name and cell reference"). I'm copying a workbook with lots of formulas like this and...

    Bossann5 pointsBadges:
  • ACT By SAGE Client Notes

    I was wondering if anyone had a solution for me to export ACT's Client notes out to a CSV so I can load them into our new database. I have found the Notes Report but can only export to a txt file with no commas. When opening the txt as a CSV Excel gets everything completely messed up. The txt file...

    RamseyB2,115 pointsBadges:
  • How do I overcome the “Could not find installable ISAM. Excel 2007″ Error? Ex

    I got the "Could Not find installable ISAM error" while uploading an Excel file in my application.This seems to be happening at the "connection.Open()" code line. -- Web Application -- .Net 2.0 -- Testing using IIS 7.0 on Vista Ultimate -- Office 2007 Enterprise Installed on machine. Code works...

    Donnybrasco10 pointsBadges:
  • WebUtil client_ole2 commands in Oracle Forms 10g

    I want to attach a sheet from an excel 2007 datasource to a word 2007 mailmerge using webutil client_ole2 commands in oracle forms 10g

    Petitejean5 pointsBadges:
  • Excel VBA – Cell value not being displayed

    when i display all the values there is a cell that dosnt display it's result,but when u put the mouse on it in the comment box it appears

    Skh805 pointsBadges:
  • Excel 2007 – How to find duplicate data and sort into a row

    I have two column. I would like to find the duplicate data and sort the int a row. Eg: Name Name2 Julie Jane Sally John Jack Paul Jane Sally The result: Name Name Julie Sally Sally Jack Jane Jane John Paul Pls help

    Miya30 pointsBadges:
  • Seperate emails from Excel File

    I need to send a 500 e-mails separately to different users depending on their name and e-mail address.

    Mfagabani5 pointsBadges:
  • Unable to view Excel 2007 workbook

    I have open a workbook, but unable to view it. When I attempt to reload, excel ppoup ststes already open. The workbook has macros. The VB editor shows them, therefore the file is open.

    Jhengineer5 pointsBadges:
  • Using a drop down window in Excel to look up a List .. The names shown are so small it is difficult to read them

    How can I get the Font larger in the drop down window in XL for say cells A1:A200

    Yoka25 pointsBadges:
  • Microsoft Excel 2007 charts

    I AM UNABLE TO USE CHART OPTION IN EXCEL 2007

    Jollybhupi5 pointsBadges:
  • Excel macros not working in password protected workbook

    Excel 2007 .... macros work perfectly in original workbook however when i save as and create apassword to open the workbook, it opens OK but the macros don't work. The excel options have the macros enabled but they are deactivated somehow

    Yoka25 pointsBadges:
  • Adding standard text to multiple cells in Excel 2007

    Hi, I have a list of about 800 products that I sell ( flags). Most of the flags are 150cm x 90cm in size and I would like to add this text to a chosen amount of cells for example: Grenada 150cm x 90cm Marshall-Islands Maurutania Palau Rhodesia Salomon Islands Trinidad und Tobago West Sahara Is it...

    Wereldvlaggen5 pointsBadges:
  • Creating a CSV file to FTP

    I just loaded Office 2007 and created a csv file which then was FTP'ed to a server. When picked up it had lost its csv extension. I follow this process regularly and this only happened after I upgraded to 2007. Any ideas?

    Superiorsys15 pointsBadges:
  • Microsoft Access 2007 Data Input & Report

    I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 ** 1 I I I 2 C C 3 V V With the 3 pieces of information...

    PD15 pointsBadges:
  • 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:
  • 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:

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