• I want data from AS400 PF to my windows system in form of XL sheet.

    I want to create a pgm in any of the high level language supported by AS400. I want that when this program is run, an XL sheet is created and all the data in a specified PF should come in this XL sheet. If I am right, then every XL sheet has a limit on the number of rows it can accomodate. If...

    AbhishekRam5 pointsBadges:
  • Microsoft Access 2007 Data Input & Report

    I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 ** 1 I I I 2 C C 3 V V With the 3 pieces of information...

    PD15 pointsBadges:
  • AS400/iSeries Queries on a schedule

    I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.

    Querys100 pointsBadges:
  • COUNTIF command using Excel and s comma-delimited file

    I saved a comma-delimited file to my excel 2003 worksheet and had a problem using the countif command. It wouldn't recognize the text info. For example, countif(xx:xx,"abc"), it wouldn't recognize the abc cells. Can you help me?

    Cklv5 pointsBadges:
  • What is the difference between =+ and =?

    Hi, I have a excel sheeting showing a formula as c1=+A1*B1. What does it mean? If I try with C1=A1*B1 the results are same. Then why do we need =+? pls help. Arun.K.S sarunmphil@gmail.com

    Sarunmphil5 pointsBadges:
  • Image storage in Microsoft Excel

    I'd like to know the code or procedure to use in Ms Excel that will help me to lookup a photo into a cell. I've observed some customised banking software which is able to display the picture and signature of a client whenever his unique account number is entered. Could I use excel to perform the...

    Snowolf5 pointsBadges:
  • Menu Driven Macros

    I have a database within Excel 2007. There are quite a few macros in it. I want others to be able to use the database and certain macros, but I want the options to be in a menu type layout not on the bar. I know this has to be possible, but I don't even know what it would be called to look it up....

    Cindyhale5 pointsBadges:
  • Deleting Excel Worksheets with macro

    I am using excel 2000 and have workbook that uses macro to delete several worksheets and then save the workbook under a name in one of the cells. All works fine but for each worksheet a quiery pops up to ask if you want to delet this sheet. How do I delete sheets in the macro without having this...

    Rbloxsom5 pointsBadges:
  • file format or extension invalid

    after using Excel 2007 for several months with no problem, I had to reformat and reload windows xp professional. then I installed Excel 2007 and now I can't open the xlsx files created by Excel 2007. I get the error in the above title box. Any help will be welcomed. Gervis.

    Cornfused15 pointsBadges:
  • Is there any way to update Actual results in Quality Center from an Excel?

    Is there any way to update Actual results in Quality Center from an Excel?

    Ilm5 pointsBadges:
  • Excel 03 won’t release cell

    We've had a couple of users run into issues with Excel 03 not releasing a cell as if were in EXT mode. Problem is that when we press F8 it won't release it. ESC hasn't helped and it locks up the workbook so the only way to close it is through Task Manager. Running Windows XP Pro SP2 with MS Office...

    Littlejuanito7420 pointsBadges:
  • Critical Path

    I created a project plan and everything looks normal but when I want to view for a critical path (using Gant Wizard Chart), I don't see any critical paths. I am wondering what went wrong

    MSProject5 pointsBadges:
  • Excel to Lotus Notes Form

    I have a Excel workbook with alpha numeric text in a group of cells. I try and copy the text from those cells directly from Excel into a Lotus Notes 7 form and find that I cannot because Notes is treating the paste as being an object and not text. The cells in Excel are text formatted.... How do I...

    Sjh7475 pointsBadges:
  • Executing DTSX from VB.NET 2003

    We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we...

    BClawson10 pointsBadges:
  • STRPCCMD with blank in path

    I am trying to start an Excel spreadsheet with a blank in the path. ex: STRPCCMD 'START K:\My Documents\GL\Monthend.XLS' I've tried all sorts of QUOTE scenarios but have not hit on the right set. Thank you MIS

    MurrayInfoSys940 pointsBadges:
  • How to run a query in PS Query using Microsoft Excel macro

    Hi, I am working on a macro in Excel that can automate the running of a query in people soft PS Query application.Result should also be save in Excel format at given path. Here is what i exactly want to do 1. Put all query name under column A.(not entire query only its name) 2. Run macro 3. query...

    Sh3210 pointsBadges:
  • Excel to Access conversion

    When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?

    QAMAN15 pointsBadges:
  • Microsoft Excel hyperlinks to Lotus Notes

    I created a hyperlink in MS Excel to an E-mail address (I use Lotus Notes). When I follow, the email is created with the correct subjsct line however the text line is blank i.e., simply not there, even though it appears in the "text to appear" diologus box. Does anyone know why this is?

    LostinDenver5 pointsBadges:
  • Upgrading from excel 2003 to 2007

    After upgrading our laptops from Office 2003 to Office 2007 somehow the permissions in the IFS have changed and certain groups can no longer save Excel documents with system i data. They get a "cannot save" message. Any idea where to look? Netserver etc.?

    Kbordner5 pointsBadges:
  • Can Windows Explorer ‘File Types’ settings be amended by Group Policy?

    To enable our reporting software to correctly export to Excel 2007 (WXP SP2 operating system) we need to change the following Windows Explorer 'File Types' setting: Open windows explorer and navigate to the XLS file type and enable the "browse in same window" option, see path: \Tools\Folder...

    Redtyke130 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