• 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:
  • 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:
  • Appending Excel to SharePoint list

    I am trying to create master database in SharePoint such that excel can be appended at the end of it. End result is to get dynamic reports / dashboards and email notifications from SharePoint. Please guide how this can be done.

    Navin88810 pointsBadges:
  • Project has stopped working

    I have been getting this error: Project has stopped working, when I try to import a project. Is it timing issue or a memory issue? Thanks!

    KenWatson225 pointsBadges:
  • Import lotus notes view data from Excel

    I need to import frequently data from some Lotus Notes views into my Excel sheets, I want to know if they are a macro or a VB script which could do that.

    Witold200830 pointsBadges:
  • Is there a way of checking remote PCs to see how much of the hard drive is taken up with MS Office documents?

    I would like to run a report that tells me how much space on all our user's laptops is taken up with MS Office files (Excel, Powerpoint, Word). Currently a lot of our laptop users are saving their data to the local HDD and we would like to get them to back up this data to the network. It would be...

    ArtVanderlay5 pointsBadges:
  • How to acquire and load OpenOffice in SUSE Linux 10.3

    What do I need to download and how do I install this package? This is a first time foray into Linux for me. OpenOffice on windows 7 installed straight off. Doing the same in SUSE Linux 10.3 is beyond my current capabilities. HELP!

    DRZ5 pointsBadges:
  • Export Lotus Notes to Powerpoint

    I want to convert lotus notes document to a powerpoint presentation. Each document will take 1 slide. Any help will be appreciated.

    Kaur5 pointsBadges:
  • Data transfer from webpage to excel

    I have a complicated problem for data extract from a web site. It is about a horse race analysis. Problem description as below I want to retrieve some historical data and non-dynamic Datas are spread into many different web pages and they are in asp. Pull down menu is on the web page and have to...

    Hbongsui5 pointsBadges:
  • Microsoft Excel subtraction using VBA

    I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in...

    Devisri20 pointsBadges:
  • Change date format

    I have a date field stored in the i5 as yymmdd that I would like to change to mmddyy when exported to Excel. If I just re-format the cell, Excel treats the number as a Julian date and mis-corrects the date. The other issue is that Excel drops the leading 0 so everything in this decade is...

    DanBubis75 pointsBadges:
  • How to create an Excel spreadsheet from an Oracle database

    I currently have a table in a Oracle database and I need to create a complex Microsoft Excel spreadsheet structure from that specific table. Should I use SSIS to do this? Is there another way to create it? Appreciate the help.

    ITKE351,335 pointsBadges:
  • Cell Colors in Excel

    I would like to have some code that will update the color of a cell based upon values in other cells. Even when the cells are on different worksheets within the same workbook.

    TweetyBird695 pointsBadges:
  • Import text from another excel workbook

    I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to...

    AenE15 pointsBadges:
  • Creating a list in one Excel cell by referencing several other cells

    Using excel and I am trying to make a list generated into one cell, or cells right under each other. I have 85 choices for the user to select. If the user selects a symptom (column b, I want the treatment (in column C) to be displayed on a different tab. So the user would go through tab one and...

    Adventuredev55 pointsBadges:
  • Excel 03 opens as Read Only always

    We have a user that is only able to open Excel 03 files in Read Only. No other MS Office does this to her. It even happens to Excel files she has created and files that she receives in emails. Any ideas would be helpful since we are at a loss. Windows XP Pro SP2, MS Office w/Outlook 03. Thanks

    Littlejuanito7420 pointsBadges:
  • Year over year pivot table

    Similar to your example except I want to show monthly columns with two separate years as rows in the pivot table below each customer, then insert an additional row between each customer for the % change like this                 Jan     Feb     Mar Smith & Co 2013        ...

    TonyX105 pointsBadges:
  • Can’t open IFS doc

    I have an excell spread sheet on the IFS, I have a drive mapped. I can see the spreadsheet (it's small). When I click on it to open it will sit there saying it's downloading but then I get the error "Can't Open File". It has worked in the past this just started happening. Thanks

    Johnd0155 pointsBadges:
  • INFOPRINT SERVER PDF conversion and printing issue.

    Hi Folks, Hopefully someone can help me. I am trying to implement the infoprint server to convert to PDF bring in a dynamic image with the AFPRSC and print to an infoprint printer. The conversion works nice and I can see the PDF in the IFS and it brings in the images in nicely however when I send...

    Paul66650 pointsBadges:
  • Cell color coding

    I am using a spreadsheet designed by someone else and it has some formatting gin place that when a date is entered if it is within a certain period the cell goes green if not red and so on. I need to add some columns and apply the same formatting however for some reason I cant see the formula used...

    Mas85 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