• How can I use mscal.ocx on a Windows 7 64-bit machine?

    Hi there, I have some VBA code that works in Excel 2003. It references the calendar in mscal.ocx. Typically, when I've moved it to a new machine (XP, 32-bit), I've had to copy mscal.ocx there and run regsvr32 mscal.ocx and then everything works. But on a new, 64-bit windows 7 machine, with Excel...

    Dbecker20 pointsBadges:
  • How to save a Microsoft Excel file to CSV

    I've been having a ton of issues saving my Microsoft Excel file to CSV. When I'm saving it, many of the characters change from dash to a question mark. Why would this be happening? Do I have to do some encoding changes? Thanks so much.

    ITKE1,000,280 pointsBadges:
  • Crystal Reports export to Microsoft Excel

    When I export my Crystal report to "Excel 97-200 - Data only", some row fields in the spreadsheet contain different data than the report shows. The wrong exported data is from other records in the group. When exported as a PDF the data is as it appears in the report. Why is the data incorrect in...

    RobinRay5 pointsBadges:
  • Microsoft Word template for DWC salary certificate

    Where do I download a salary certificate for DWC in Microsoft Word?

    Indira5525 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • Sort Microsoft Excel sheets alphabetically

    Hey everyone, I need to sort several Microsoft Excel sheets into alphabetical order. How can I do that? I'm not too entirely sure of the 'sorting' part. Thanks!

    ITKE1,000,280 pointsBadges:
  • Cannot save Microsoft Word document as PDF

    I'm trying to save a Microsoft Word document as a PDF. I'm not getting any messages but it's just not saving the file. Everything is showing up correctly. I'm on Word 2016 and a Mac OS X. What's the issue here?

    ITKE1,000,280 pointsBadges:
  • ORA 12154 error when fetching data from Oracle

    My boss gave me a Microsoft Excel file (which my predecessor used) and it uses an external data connection to fetch our data from Oracle. I've been trying to migrate this file to my PC but I keep getting this error message: ORA 12154 TNS could not resolve the connect identifier specified. What's...

    ITKE1,000,280 pointsBadges:
  • How to lock Microsoft Excel cells

    Hi, Could anyone tell me if there's a way I can lock Microsoft Excel cells (with different equations) so Excel doesn't autoedit them. I tried Freeze but that didn't work. Thanks.

    ITKE1,000,280 pointsBadges:
  • Limiting word count in Microsoft Word textbox

    For my Microsoft Word document, how can I limit the word count in a textbox. This is not for a character limit (just words). Thank you.

    ITKE1,000,280 pointsBadges:
  • Excel 2013 Linked formulas

    Receiving problem "sending the command to the document" when opening a linked file. Once opened it was under a different name XI0000026 Compatibility Mode Read Only. The data did update once I hit “enable content.”

    Crisheff5 pointsBadges:
  • Format older Microsoft Excel files into newer version

    I have a bunch of older Microsoft Excel files (some even Excel 97) that I need format into the new version. Is that remotely possible? I tried Apache POI but that didn't work. Thanks!

    ITKE1,000,280 pointsBadges:
  • Microsoft Word page gets smaller in size

    In Microsoft Word, every single time I paste text into the document, the last page gets smaller (or shrinks). Why is this happening?

    ITKE1,000,280 pointsBadges:
  • Open PDF file in new tab

    Our HTML page has a link to a PDF file that opens in Adobe Reader. But we need it to open in a new tab (on that same window). How can we do that?

    ITKE1,000,280 pointsBadges:
  • Remove parenthesis in Microsoft Word 2013

    For a Microsoft Word 2013 wildcard, how can I remove just the parenthesis without deleting the text inside? Thank you so much.

    ITKE1,000,280 pointsBadges:
  • Create heat map on Microsoft Excel 2013

    For a project at my job, I need to create a heat map in Microsoft Excel 2013. I'm trying to do it using Power Map but I'm not seeing it on the Insert tab. The add-in is available and I checked it off. What's the issue? How can I get it to appear?

    ITKE1,000,280 pointsBadges:
  • Create Microsoft Excel files in ASP.NET

    Hello experts, I have a more broad programming question for everyone. For ASP.NET, is there some package/interface that would allow me to create Microsoft Excel files? I haven't been able to find anything.

    ITKE1,000,280 pointsBadges:
  • Hide and unhide Microsoft Excel sheets in Python

    I need to hide and unhide several of my Microsoft Excel worksheets in Python. I'm currently using openpyxl but not too sure of the process. How can I do it?

    ITKE1,000,280 pointsBadges:
  • Add number to range of Microsoft Excel cells

    In my Microsoft Excel spreadsheet, would I be able to add a new number to my dynamic range of cells? Here's an example: I have a range of cells from B1: B20. How can I add B21, B22, etc.

    ITKE1,000,280 pointsBadges:
  • Remove Microsoft Word color highlights

    I was recently handed a Microsoft Word document that has several different texts and sections highlighted in different colors. Is there a way for me to remove one of the highlights automatically? I don't want to do this manually. Thanks.

    ITKE1,000,280 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