• Microsoft Excel: Move data from tree view to table

    In Microsoft Excel, I have a bunch of data in tree view. I need to move it over to a table. How can I do that?

    ITKE976,975 pointsBadges:
  • Unreadable content on Microsoft Excel file

    For one of our Microsoft Excel files, I use NOPI to open it and make changes. I also write it back to the disk. But for some reason, it says the file contains unreadable content. Afterwards, it questions if I want to recover the content of my file. What is going on? Can anyone help?

    ITKE976,975 pointsBadges:
  • Correct password won’t open Excel doc in an attachment

    I have a password protected Excel document. I can open it with the password. When I send it as an attachment, I get a password is incorrect message.

    ronirothstein15 pointsBadges:
  • Allocate range to array in Microsoft Excel

    For my job, I have a spreadsheet that allocates a range to an array but, for some reason, it keeps starting at the first row. I need it to start at row zero. How can I do that?

    ITKE976,975 pointsBadges:
  • Create UTF-8 file using VB in Excel 2016

    Would I be able to generate / create a UTF-8 file using VB in Microsoft Excel 2016? I'm on a Mac too if that helps.

    ITKE976,975 pointsBadges:
  • AS/400 import to Excel

    How do I import data from AS/400 to Excel?

    melindabeal15 pointsBadges:
  • Automation object error when merging Microsoft Excel cells in LotusScript

    Whenever I try to merge cells in Microsoft Excel through LotusScript, an automation error appears. r=11 c=12 t=15 mysheet.cells(r, C).value="ABC " mysheet.cells(r, C).Font.Size=12 mysheet.cells(r, C).Font.ColorIndex=1 mysheet.cells(r, C).Font.Bold = True ' -4108 is for center mysheet.cells(r,...

    AnshuKumari5 pointsBadges:
  • Highlight Microsoft Excel rows

    Would I be able to have Microsoft Excel highlight rows by their row number? I need several specific rows highlighted for a client. Thanks for the help.

    ITKE976,975 pointsBadges:
  • Using VBA (in Excel) how to find attachment size for an email in Lotus Notes?

    I am creating an Excel macro to automatically send some information including a few zip files. We use Lotus Notes 6.5 as email client. I want to make sure though that the total email size does not exceed the maximum for our server. How can I do this in VBA? Can I find what is the maximum size on...

    Unknown12345 pointsBadges:
  • Macro for copying data from Excel to AS/400

    Hi,I'd like to create a macro (in AS/400 or Excel VBA, doesn't matter) that copies cell data from an XLS spreadsheet to AS/400. How would I do that?E.g. copying cell A1 in Sheet1 from c:\spreadsheet.xls to 10/035...Thanks in advance.

    Hanisadeq963575 pointsBadges:
  • Import and Export data from AS/400 using ODBC

    I imported data from AS/400 database file into an Excel sheet, using ODBC. I selected Microsoft query in order to retrieve data. How can I export data into AS/400 database file?

    Geek51185 pointsBadges:
  • Arabic Text In AS/400 to Excel

    Arabic Text when transferred from Excel to AS/400 displays garbage. Is there an add-in I need to install? Kindly help me in this how to transfer the data file from Excel (.xls) to AS/400 DB2.

    AnwarHabib25 pointsBadges:
  • Export Arabic data from AS/400 folder to Excel

    How to export data from AS/400 folder containing Arabic data in to Excel

    Jaipalsingh5 pointsBadges:
  • Microsoft Office: Missing Localized Strings Here

    I downloaded microsoft office from my college's website, and when I tried to open it the message "missing localized strings here!" what does that mean and how can I fix it?

    dsawyer5 pointsBadges:
  • Excel 2007: Digits turned into decimals automatically

    In Microsoft Excel, last 2 digits are turned to decimal automatically. What should I do?

    Harshendu5 pointsBadges:
  • How to update ODBC database in Microsoft Excel

    For our ODBC database, can I directly update it through Microsoft Excel? I'm able to view the tables on it but I need to modify some data. How can I do that?

    ITKE976,975 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:
  • Convert Excel file to SIF file

    Hello, does anyone know how to or what program I need to convert an excel file to a SIF file?

    ResseJackson5 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:
  • Retrieving missing Excel data

    I had an excel file with 10 worksheets on it. I opened the file yesterday and found the whole 10 worksheets missing from the file. What could have caused it and is there a way to retrieve this data back to the file?

    Tess695 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