• Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • How to make cell or cursor blink in Microsoft Excel

    I have a large Microsoft Excel spreadsheet - that has quite a bit of different colors / fonts (conditional formatting). Sometimes, it's almost impossible to see my cursor on the screen (even the cells too). Can I somehow make the cursor / cell blink so I can see which one I'm working on? Anything...

    ITKE1,149,615 pointsBadges:
  • Limit to number of rows and columns in an Excel spreadsheet

    What's is the limits to the number of rows and columns that an Excel spreadsheet can have?

    Famous5 pointsBadges:
  • How to get AS/400 macro to pull data from Excel

    Hello I’m trying to create a macro on the AS/400 that will pull data from an Excel sheet and input data to the screen. I know how to create a macro to run the menu option by using the record macro button but not sure how to get it to access the excel file so it will run through the list.

    dluy688035 pointsBadges:
  • Can I use then Forms 6i DDE build-in package to generate 2010 EXCEL File?

    Hi all, My company' application is used Oracle FORMS 6i Solution,Client /Server environment to generated EXCEL file I coding the PL/SQL in the Oracle FORM, it's succeed generated EXCEL file in MS office Excel 2007/2003/2000. Now I have problem in MS office Excel 2010. It's just opening the Excel...

    Wangakai5 pointsBadges:
  • Exporting Contacts in Outlook 2007 in an Excel Spreadsheet

    I just tried to export my contacts into an excel spreadsheet. I followed the instructions but when it imported, all it imported was the title line, you know first last title company email website phone fax cell address city state zip. However NONE of that information imported over. None. What do I...

    Diva535 pointsBadges:
  • Excel cannot open the file ‘file.xlsx’ because the file format

    Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

    weinmagaul5 pointsBadges:
  • How to Migrate from Outlook Express to Windows Live Mail on new Computer

    I have been using Outlook Express on Windows XP operating system. Recently I have upgraded to Windows 10. In this operating system I am using Windows 10 Mail. Which is quite impressive. But Outlook Express contains some crucial email from clients. So, I want to access Outlook Express DBX Files in...

    WarriorBhagat410 pointsBadges:
  • Convert spreadsheet into a flat file

    I need to convert a spreadsheet into a flatfile using the mid function. I only want to use a couple fields out of the spreadsheet, can someone help me?

    Kioh4650 pointsBadges:
  • Recover password for Excel VBA macro

    About a month ago, I set a password for an Excel VBA macro but now I forgot it. I can't download the Hex Editor. What should I do? How can I get my password?

    ITKE1,149,615 pointsBadges:
  • Excel report from RPG or SQL

    How do I produce an excel report via RPG or SQL inside an RPG program?

    Taborly0820 pointsBadges:
  • Comparing 2 Large Excel Files

    I have 2 large Excel files, one containing yesterday's data, and another containing yesterday's data + today's updates/changes. For registration purposes, I need to find all the differences (ie new rows/entries, a value changed within the row in the new file vs the old file, etc). These excel files...

    Drawde5 pointsBadges:
  • How to repair corrupted files

    My MS Word, Excel and PDF files have been corrupted and these files are showing there file extension as "qbnzgel". How to open this type of files?

    tanveerhamza5 pointsBadges:
  • Cannot open Excel file: File format is not valid

    Excel cannot open this file because file format or file extension is not valid

    rajendermadan5 pointsBadges:
  • Convert Excel to JSON using VBA

    I need to write an Excel macro which will convert the excel workbook into a JSON file. The excel will have multiple sheets, each sheet will have a tabular form of data (in rows and columns). One of the column will have hyperlinked data and the macro should extract and explicitly list the hyperlink...

    6r2,920 pointsBadges:
  • Exporting to Excel – Sort doesn’t work due to merged cells

    How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.

    Gma885 pointsBadges:
  • Export SSRS to Microsoft Excel without any headers

    I have a SSRS report that I need to export to Microsoft Excel. But here's the kicker - my header that's on the first page of the report has to be removed from Excel. How can I do that?

    ITKE1,149,615 pointsBadges:
  • How to create exe file for Excel macro in VB without DoneEx XCell Compiler.

    With DoneEx XCell Compiler. It expires with 3 days (trial version).

    SumanLata10 pointsBadges:
  • Upload Excel file into AS/400

    Can an excel file be uploaded into AS/400?

    Tammyc15695 pointsBadges:
  • Microsoft Excel: Create multiple charts for same data set

    In Microsoft Excel, I have a data set of about 5000 rows and columns. I need to create multiple charts in different sheets for every 100 rows. What's the best way to do that? Thank you.

    ITKE1,149,615 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