• How to create an XML file from Excel

    What are the steps to be followed when converting an Excel file to XML file?

    CHELESTINO5 pointsBadges:
  • Sending a file to Excel spreadsheet

    I need to send a file that has an item name field that contains commas and double quotes to an Excel spreadsheet. I need to keep the commas and quotes in the item name field. Currently, the SNDMAIL options uses the commas to break down the item field into separates fields. Is there away I can...

    lgronewold15 pointsBadges:
  • Forgot password on Excel

    In LAN environment, is there any way to find out forgot password that I set for excel spreadsheet?

    Eogy60 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:
  • How to split large .CSV file into smaller files

    Our department has very one big .CSV file that needs to be broken up into smaller .CSV files using the command prompt. I've tried to write a batch script when I execute it. Can anyone help me solve this problem?

    ITKE1,072,650 pointsBadges:
  • Excel Dashboard from AS/400 reports

    A client has asked me to populate an Excel sheet with reports generated from an AS/400 system. Currently these reports are entered manually 1-2 times a day. What I want to do is pull the data directly from the AS/400 system rather than having it run the report, but I'm not sure where I would start...

    Cheshire425 pointsBadges:
  • Copy to CSV file and email out

    I need to copy orders to a CSV file and email out to customers. What's the best way to get this done?

    detrose15 pointsBadges:
  • I have a case that the client work on an exists Excel file

    I have a case that the client work on an exists excel file, she try to save the file on a different name, sines than the file was corrupted an could not be open at all. I try the auto save of Excel, but nothing there. I try several fix software but the most of them get me a blink results. Some of...

    olenprazd5 pointsBadges:
  • Is it possible to get a PDF from AS400 spool file?

    Is this possible? Is it really possible to get a PDF from spool file? Nothing seems to work. :-( I was trying to convert PDF in iSeries Navigator. I put a spool file, right click, convert to pdf, asks me whether I want a new printer, I say yes, starts a printer then a writer but then everything...

    Avrelivs80 pointsBadges:
  • Convert .tex file to a Word document

    How can I convert a .tex file to a Word document?

    neffeditorial15 pointsBadges:
  • Export data from Delphi to Microsoft Excel

    I'm looking to export my data to Microsoft Excel from Delphi but I'm not sure about the process. I tried CSV but that didn't work. What's the best way to do it?

    ITKE1,072,650 pointsBadges:
  • How to lookup and match data in Excel

    I need to look up data (number) from column B and match it to column R, and then display the corresponding cell from column S. so if B1= R3 then display S3. Help?

    Fatcowboy5 pointsBadges:
  • How to automatically update Microsoft Excel charts

    I have several charts in Excel that point to my data on the worksheet. The data is created from a VBA function. But when I tried to update it, my new data isn't being reflected in the charts. Did I do something wrong? What should I do?

    ITKE1,072,650 pointsBadges:
  • Create button to go to specific Microsoft Excel worksheet

    For the past week or so, I've been trying to create a button that would take me to my Excel index worksheet. I figured it out using a macro but this sheet is going to be passed out to users and they won't know how to use it. What should I do here?

    ITKE1,072,650 pointsBadges:
  • How to change Microsoft Excel 2010 form checkbox

    For Microsoft Excel 2010, would I be able to change the name of a form checkbox that I created? Does the name box do it for me? Thanks.

    ITKE1,072,650 pointsBadges:
  • How to export DataGridView records to Microsoft Excel

    I have several records of DataGridView (from Windows Forms) that I need to export to Microsoft Excel. What's the best way to do it? I don't want to use any DLL.

    ITKE1,072,650 pointsBadges:
  • How to transfer GridView data to Microsoft Excel

    For the past few days, I've been trying to transfer GridView data to Microsoft Excel. But my output keeps opening as a blank sheet. What should I do?

    ITKE1,072,650 pointsBadges:
  • Printing from adobe 10x

    When I try to print message comes up that a problem exists and shuts down.

    Rkymtn20 pointsBadges:
  • How to add up positive numbers in Microsoft Excel column

    I know this is an odd question but I'm looking to add up all of positive numbers in my Excel column but not the negative numbers. Do I have to use VBA? Thanks so much.

    ITKE1,072,650 pointsBadges:
  • Rename Microsoft Access table using VBA

    I'm sorry for the short question but does anyone know how I can rename a Microsoft Access table through VBA from Microsoft Excel? Appreciate the help.

    ITKE1,072,650 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