Calling a PC Application from RPG, Part IINow that you know how to find the IP address you need, learn how to call a remote application. Integrating your IBM i with. Accessing AS/400 data using Excel ODBC drivers. Another Way to Open a Browser with STRPCCMD by Scott. Download Physical Files Using Microsoft Excel by Paul.

1. Convert Text File To Excel Using Python

Would anyone know how to kill an instance of Excel from an Iseries command or from a program? I have figured out how to open a specific Excel spreadsheet from an Iseries command. From Excel, you can create Macro to AutoOpen when the spreadsheet opens. From here you can download information from the Iseries and/or mail the spreadsheet to several people.

To complete the automation all I would need is a way to kill the Excel spreadsheet. If I do it from the AutoOpen command I will never be able to get into the spreadsheet again. If I programmed the quit from the AutoOpen and tried to open the spreadsheet to change it, the spreadsheet would automatically perform the macro and kill itself. If I had the last piece of the puzzle I could fully automate creation of Excel spreadsheets from the Iseries. This would save us valuable time and money. Many thanks to whoever has the missing link. Don't know how you invoke Excel, but if it's anything like a remote command you could specify the macro to run when invoking Excel, rather then have an auto-open macro.

schreef in bericht news.860@g47g2000cwa.googlegroups.com. Would anyone know how to kill an instance of Excel from an Iseries command or from a program? I have figured out how to open a specific Excel spreadsheet from an Iseries command. From Excel, you can create Macro to AutoOpen when the spreadsheet opens.

From here you can download information from the Iseries and/or mail the spreadsheet to several people. To complete the automation all I would need is a way to kill the Excel spreadsheet.

If I do it from the AutoOpen command I will never be able to get into the spreadsheet again. If I programmed the quit from the AutoOpen and tried to open the spreadsheet to change it, the spreadsheet would automatically perform the macro and kill itself. If I had the last piece of the puzzle I could fully automate creation of Excel spreadsheets from the Iseries.

This would save us valuable time and money. Many thanks to whoever has the missing link. STRPCCMD is pretty neat. Where can I get more information on using that command more fully to take advantages of all the functionality of it. Only draw back I see.I can understand.the limits is strictly on a 8.3 file naming/directory sequence. Are there no in-roads for allowing longer file names to take advantages of those Windows XP naming conventions? Gil bcarver wrote: How do you tell the STRPCCMD command which macro to run?

We are using STRPCCMD PCCMD('start excel.exe K:/DUNRESP.xls') PAUSE(.NO). It's not the STRPCCMD you tell, it's the invocation of Excel. Excel has a number of commandline switches. Just specify the macro start switch with the macro name with the invocation of Excel. I'm not at a PC with Office at the moment, but the Excel help should have the info on what switches exist. You'll get something like STRPCCMD PCCMD('start excel.exe -s macroname K:/DUNRESP.xls') PAUSE(.NO) where -s (or /m or something) is the switch to start a macro and macroname is the name of the macro to start.

HTH - 'bcarver' schreef in bericht news.560@g44g2000cwa.googlegroups.com. How do you tell the STRPCCMD command which macro to run? We are using STRPCCMD PCCMD('start excel.exe K:/DUNRESP.xls') PAUSE(.NO). Rene is on the right track but does anyone know the correct switch to start an excel spreadsheet with a specific macro? Ano Ren=E9 H. Hartman wrote: It's not the STRPCCMD you tell, it's the invocation of Excel. Excel has a number of commandline switches.

Just specify the macro start switch with the macro name with the invocation of Excel. I'm not at a PC with Office at the moment, but the Excel help should have the info on what switches exist. You'll get something like STRPCCMD PCCMD('start excel.exe -s macroname K:/DUNRESP.xls') PAUSE(.NO) where -s (or /m or something) is the switch to start a macro and macroname is the name of the macro to start.

HTH - 'bcarver' schreef in bericht news.560@g44g2000cwa.googlegroups.com. How do you tell the STRPCCMD command which macro to run? We are using STRPCCMD PCCMD('start excel.exe K:/DUNRESP.xls') PAUSE(.NO).

In Word you use /mmacroname Note there is no space between the /m and the name of the macro. However, according to and there is.no.

macro startup switch for Excel. The way to do it is different: simply name your macro AutoOpen and whenever the workbook is opened it will take off. Excel security center will block it (tools/macros/security) if security is set to HIGH and you haven't signed it. What I did is create my own signature by running%program files% microsoft office office signcert.exe then signing my macros in the macro editor (Tools/Digital Signatures). Kta@mysticstamp.com wrote: Rene is on the right track but does anyone know the correct switch to start an excel spreadsheet with a specific macro? Ano Ren� H. Hartman wrote: It's not the STRPCCMD you tell, it's the invocation of Excel.

Excel has a number of commandline switches. Just specify the macro start switch with the macro name with the invocation of Excel. I'm not at a PC with Office at the moment, but the Excel help should have the info on what switches exist.

You'll get something like STRPCCMD PCCMD('start excel.exe -s macroname K:/DUNRESP.xls') PAUSE(.NO) where -s (or /m or something) is the switch to start a macro and macroname is the name of the macro to start. HTH - 'bcarver' schreef in bericht news.560@g44g2000cwa.googlegroups.com. How do you tell the STRPCCMD command which macro to run? We are using STRPCCMD PCCMD('start excel.exe K:/DUNRESP.xls') PAUSE(.NO).

I know that a lot of people are using SYMTRAX products to send data from an Iseries to Excel. They have lots of tools to do that and automates it. We are currently trying their MapForm for other purpose but their Starquery send data to Excel.

See you Jonathan Drew Dekreon a =E9crit: In Word you use /mmacroname Note there is no space between the /m and the name of the macro. However, according to and there is.no. macro startup switch for Excel. The way to do it is different: simply name your macro AutoOpen and whenever the workbook is opened it will take off. Excel security center will block it (tools/macros/security) if security is set to HIGH and you haven't signed it. What I did is create my own signature by running %program files% microsoft office office signcert.exe then signing my macros in the macro editor (Tools/Digital Signatures).

kta@mysticstamp.com wrote: Rene is on the right track but does anyone know the correct switch to start an excel spreadsheet with a specific macro? Kelly T. Ano Ren=E9 H. Hartman wrote: It's not the STRPCCMD you tell, it's the invocation of Excel.

Excel has a number of commandline switches. Just specify the macro start switch with the macro name with the invocation of Excel. I'm not at a PC with Office at the moment, but the Excel help should have the info on what switches exist.

You'll get something like STRPCCMD PCCMD('start excel.exe -s macroname K:/DUNRESP.xls') PAUSE(.NO) where -s (or /m or something) is the switch to start a macro and macroname is the name of the macro to start. HTH - 'bcarver' schreef in bericht news.560@g44g2000cwa.googlegroups.com. How do you tell the STRPCCMD command which macro to run?

We are using STRPCCMD PCCMD('start excel.exe K:/DUNRESP.xls') PAUSE(.NO) =20. This is a multi-part message in MIME format.=NextPart00000B.65141F40 Content-Type: text/plain; charset='Windows-1252' Content-Transfer-Encoding: quoted-printable IBM should know, it's just herself is killing iSeries/400. He invest = too much money in Webfacing, HATS, PASE, Web Access and RPG V. But = how many users are planing to use them???

IBM should focus = on how to imporve the running time performance of Websphere on iSeries, = How let user can build java/web application as easy as SDA. AS/400 won = in 1988 because compare with the Unix, VAX/VMS and DOS, AS/400 is such = easy to be used to create application system. But now, Java on iSeries = is nightmare. Compare with Unix, Linux and Window platfrom. Websphere on = AS/400 has very low performance, It's very difficult to be install, Very = bad SQL/JDBC performance, to build application is as difficult as unix = and other open system, even more.

Much expensive than unix, linux and = windows. So Why user choose iSeries???? Almost all my customer = complain as I said above everyday. Honestly If I was ordered to build = a web base application, I'd rather use Linux, but not OS/400! OS/400 can = not give me almost none benefit for Web Application! Also AS/400 is not = a very good DB server too.

Just wish I could install Linux and AIX on AS/400 box without the OS/400 = primary partition soon. And hope IBM sell the new box as cheaper as = pSeries (RS/6000).=. I came up with a solution to automate the creation of an Excel spreadsheet with current I-series information.

Without boring you with the details; has anyone found a way to open an Excel spreadsheet off hours without being logged on? The code below is part of a CL program I wrote to open an Excel Spreadsheet.

Once I opened the Excel Spreadsheet, the AutoOpen Macro took care of the rest. Everything worked great until I tried to schedule the CL program with iSeries Navigator. I found out the hard way that STRPCO and STRPCCMD only work interactively. Any suggestions. Open Excel Spreadsheet./ /./ STRPCO PCTA(.NO) MONMSG MSGID(IWS4032) EXEC(DO) GOTO CMDLBL(ENDCLPGM) /.

not a PC./ ENDDO MONMSG MSGID(IWS4010) /. already started = OK./ STRPCCMD PCCMD('start excel.exe M:/bcpobo.xls') + PAUSE(.NO) If you know Java, you can use POI (this is an Apache project) to update the spreadsheet directly.

Matt You want a PC to be able to open an Excel file on a shared network drive mapped to the iSeries IFS? You would be looking for a PC product to execute a time scheduled batch file including an Excel file open. I don't think you need STRPCO on the PC if the Excel file you create is on the IFS, and the PC logon and password matches the iSeries user profile and appropriate system values allow IFS access with those values. That is definately a possibility.

I tried to Schedule the spreadsheet to open using Control Panel. Hello all, I'm working on a program that needs to send a print job to a printer connected to an AS/400.

I've tried using the SpooledFileOutputStream and I've also tried using one of the SCS Writer classes. Neither solution is working. With the SpooledFileOutputStream I am at least able to create my print file, but when my program ends, the file is still not being printed. This program does not run on the AS400, it runs on a PC and connects to the AS400 via the toolkit classes. I know this part works as I am able to use the toolkit to access Data Queues, Files and Data Areas without a problem. Is there anyplace anyone can point me to see some examples of how to print a file using the AS400 Java Toolkit? Thanks in advance, Chuck Chuck, What printer data stream is used?

Or how was the printer data generated? I am wondering if the data stream being generated matches the data stream of the printer connected to the iSeries? What printer is attached to the iSeries and how is it configured? The iSeries info center has some Toolbox examples: ProgrammingJavaIBM Toolbox for JavaIBM Toolbox for Java Classes Access ClassesPrintCreating.

Dave Chuck wrote: Hello allI'm working on a program that needs to send a print job to a printer connected to an AS/400. I've tried using the SpooledFileOutputStream and I've also tried using one of the SCS Writer classes.

Neither solution is working. Hi, What software do I need to make the files in AS400 to tables in Microsoft Access? My hope is to query information from Access, instead of running queries in AS/400 then exporting the data manuall, then importing the data to Excel. Any help will be greatly appreciated. James Mos.StaLL@gmail.com writes: What software do I need to make the files in AS400 to tables in Microsoft Access?

My hope is to query information from Accessinstead of running queries in AS/400 then exporting the data manuallthen importing the data to Excel. Any help will be greatly appreciated. The iSeries software package for your PC contains an ODBC-driver which Access should be able to use to do a remote connection.

I believe that currently it is called 'IBM iSeries Access for Windows'. Thorbj�rn Ravn Andersen And if you have that software already installed, then you can select whatever columns and rows directly from Excel under Data tab, Trsnsfer from iSeries to generate a.dtf without first copying into tables in Access; i.e. No reason to add yet another query/copy when the intent was to eliminate that type of activity in the first place. Regards, Chuck - All comments provided 'as is' with no warranties of any kind whatsoever. Thorbjoern Ravn Andersen wrote: Mos.StaLL@gmail.com writes: What software do I need to make the files in AS400 to tables in Microsoft Access?

My hope is to query informa. I have created an application for an external user. This application has been running for a year now without problem.

Recently I made some changes, one of which was a data dump to excel and then doing some formatting from code. I am using office 2002 and they have office 2000. Could my code or the reference to Microsoft Excel 10.0 Object Library cause problems on their end? If so, is there a way I can fix it so both sides can use this application? Thanks, apgoodb@yahoo.com (apgoodb) wrote in news:868c8f6b@posting.google.com: I have created an application for an external user. This application has been running for a year now without problem.

Recently I made some changes, one of which was a data dump to excel and then doing some formatting from code. I am using office 2002 and they have office 2000.

Could my code or the reference to Microsoft Excel 10.0 Object Library cause problems on their end? If so, is there a way I can fix it so both sides can use this application? Thanks, Are you sending them an MDE. It seems MDEs cannot adjust their references. If they don't have Excel 10, then they could not use an MDE which references the Microsoft Excel 10.0 Object Library. If this should be the problem, the solution is to create your MDE in AC2K.

Convert Text File To Excel Using Python

Lyle (for e-mail refer to Can I reference the object library inside the code? It seems like from what I have read, there is. I have an A2K app that generates a mail message in Outlook. It properly fills in the To and CC lines in Outlook, but Outlook doesn't attempt to resolve the names until the user manually changes something. (The user has to manually edit something on both the To line and the CC line) Anyone know of a way to force Outlook to attempt to resolve the names so the user can simply click Send? -=-=-=-=-=-=-=-=-=-=-=-= Randy Harris tech at promail dot com On Tue, 19 Sep 2006 23:02:56 GMT, Randy Harris wrote: Typically that is not necessary. Just click Send and Outlook will resolve at that time.

I have an A2K app that generates a mail message in Outlook. It properly fills in the To and CC lines in Outlook, but Outlook doesn't attempt to resolve the names until the user manually changes something. (The user has to manually edit something on both the To line and the CC line) Anyone know of a way to force Outlook to attempt to resolve the names so the user can simply click Send? -=-=-=-=-=-=-=-=-=-=-=-= Randy Harris tech at promail dot com On Tue, 19 Sep 2006 23:02:56 GMT, Randy Harris wrote: I have an A2K app that generates a mail message in Outlook.

It properly fills in the To and CC lines in Outlook, but Outlook doesn't attempt to resolve the names until the user manually changes something. (The user has to manually edit something on both th. Hi Everyone, Background: Another department intends to ftp a.txt file from the mainframe, for me to process. The objective is to write a vb script that would be scheduled to run daily to process this.txt file. Goal: I am working on a vba script to: a)open a text file in excel, map the text to columns, save as.xls spreadsheet b) import excel spreadsheet to an access table Accomplished most of (a) using the macro recorder in EXCEL Problem: While the script works, my problem is: I seem to have more than 1 excel instance running.

Assuming this is so because: a) when I go to explorer to open the.xls file that I just created, the computer hangs. If I exit out of access, I can then view the.xls file b) when execute the script for the first time, I get the following error code, which is what I want, because EXCEL should not be already running: 429 ActiveX component can't create object If I run the script again, I get a 0, return code, which means that excel is running. I want to always get a 429. Getting a 0, means a previous instance of excel exists.

' Function WasExcelRunningBeforeThisExecution As Boolean On Error Resume Next Set objExcel = GetObject(, 'Excel.Application') WasExcelRunningBeforeThisExecution = (Err.Number = 0) ' if err.number = 0, true else false Debug.Print Err.Number Debug.Print Err.Description Err.Clear End Function c) if I go to ctl/alt/delete/task mana. Does anyone have some notes, documentation or helful pointers about navigating, command language and DB2 on an AS400 for a guy who has done HP3000, Windows 2k/2k3, MS SQL, HP9000, IBM ES9000/UNIX, SCO UNIX?

Ideally a commands cross reference qaulivalent would be terrific - I.E. HP3000 to AS400.

I'm taking a role in a shop that runs its ERP system on this platform. Get easy, one-click access to your favorites. Your homepage. Hi all We have a number of spreadsheets that access data in other spreadsheets, that were created by an AS400 data transfer.

When this was done via BOS it all worked well. Having just changed the transfer to Client Access it now transpires that the spreadsheets have to be opened and saved in a later format before they can be accessed. We have tried all of the Excel formats available in CA and the problem occurs with all of them. If we change the transfer to QDLS, will this create an XLS file extension that can be accessed by an Excel 2000 or 2003 spreadsheet without having to open and save the data download? Hi, I open MS-Excel from within my progress app and want to set the working directory of Excel to a folder of my choice (so that when the user presses 'save' this folder will open up). Thanx, Werner. I have been charged with the onerous task of investigated testing tools for the iSeries.

So far I have found - Aldon's TestBench and Original Software's product also called TestBench (or are these the same product). Are there are other products out there that deserve a viewing? Regards to all. GSER writes: I have been charged with the onerous task of investigated testing tools for the iSeries. So far I have found - Aldon's TestBench and Original Software's product also called TestBench (or are these the same product). Are there are other products out there that deserve a viewing? If your needs can be fulfilled with a Java tool (i.e.

Everything needs to be driven from Java and results needs to be readable by Java1) then you have a lot to choose from. Look for 'Continuous Integration', where you primarily are interested in the testing part. 1 You can probably do a lot in the underlying code, and just return a 'Yes'/'No' thingie to Java, with an explanation for the report. Thorbj�rn Ravn Andersen They are both the the same product. Original Software is a UK company. We used the Testbench product.

Good for regression testing, good for repeatable unit testing, good for viewing test results, good for test data extraction. Hard to get some of our folk to spend enough time to learn and used, but I think that's a problem in any shop. I currently have an Excel spreadsheet with numerous text boxes and check boxes that I want to populate with data from an Access 97 database. I have used Excel automation in Access before but only to update cells not controls like text boxes. Can someone steer me onto the correct path? I am not using a VBA form in Excel it is just merely various text boxes and checkboxes placed on a worksheet.

Any help would be much appreciated. Regards, Mark You can use alt-F11 to display the VBE pane for your spreadsheet. There are two dropboxes at the top of the right-hand pane - the left-most one has a list of all the objects (including text boxes and check boxes) on your spreadsheet. You should be able to get the names of your objects from there. HTH - Turtle 'Mark C' wrote in message news:Y6CdnWZhKdJnEWTcRVn-rQ@comcast.com.

I currently have an Excel spreadsheet with numerous text boxes and check boxes that I want to populate with data from an Access 97 database. I have used Excel automation in Access before but only to update cells not controls like text boxes. Can someone steer me onto the correct path? I am not using a VBA form in Excel it is just merely various text boxes and checkboxes placed on a worksheet. Any help would be much appreciated. RegardsMark I understand that, but how do I reference the Excel control from Access.

Normally I would wr. Hello, Let me start off by saying I am not the best C program in the world(and probablly in the room). I have been tasked to take a histogram and put it into a 2D graph in EXCEL.

I have looked around for wrappers that would help with this but they either won't compile correctly or are a bit to complicated. I dont need any special functionality except this one graph from excel. Basically I need to input 256 numbers and put them on a bar graph from C. Thank you for any help or guidance sorry, wrong topic. Excel Data Automator is an Excel Add-in designed to release you from repeatedly extracting data from external data sources and putting into Excel. It works with all types of data sources through ODBC. A unique and intelligent mechanism is built-in to combine data with the origin query (static or dynamic), so you can refresh the data with a single button click.

Hi, I'm adding events to my automation servers. I've done this for XceedZip & Backup and Word. This is working fine.

Only for excel it doesn't work. PFunc:= SELF:VTable( IConnectionPointAdviseINTERFACE ) hResult:= PCALL( pFunc, SELF:pInterface, pIUnknown, @dwCookie ) wrote in message news:868c8f021.198eec45@posting.google.com. I have code that formats an excel report.

Most of the time this code works; however, sometimes it bombs out at the statement: With XLApp.ActiveSheet.Range(rangedef).Select ActiveSheet.Paste.Copy.PasteSpecial Paste:=xlFormulas, Operation:=xlNoneskipblanks:=False, Transpose:=False End With With the message 'Object variable or With block variable not set (Error 91)' Why would this work sometimes but fail others? Thanks, It needs a dot in front of ActiveSheet, that's for sure. Also, you better have a reference to the prevailing Excel Object Model if you're going to. I have a database that I built some functionality to export a query to excel and then do some formatting. After reading a lot of comments it seems I need to use 'late binding', because some of the users use 2000 while the others use 2002. This worked using early binding, but after changing the code to what I thought I needed I have a few errors.

Caution: The following code is only an example. IBM accepts no responsibility for its correctness. If the Start PC Command ( STRPCCMD) uses a URL with a special character (like the & sign) or if it is case sensitive, you must put the value of the URL in single quotes and then in a double quote. The IBM System i products requires only the single quote.

Because the command is sent to DOS and then DOS sends the command to the browser, the double quote is needed so DOS does not truncate the URL. You will get message CPD0744 if the value is over 123 characters. Note: This CL program needs to be run in an interactive session, not as a batch job. The following is a CL example using STRPCCMD: PGM DCL VAR(&URL) TYPE(.CHAR) LEN(123) + VALUE(' ') DCL VAR(&STRCMD) TYPE(.CHAR) LEN(123) STRPCO PCTA(.NO) MONMSG MSGID(IWS4010) CHGVAR VAR(&STRCMD) VALUE('START IEXPLORE.EXE' &URL) DMPCLPGM STRPCCMD PCCMD(&STRCMD) PAUSE(.NO) ENDPGM: ENDPGM If you compile and run this program, it should bring up a browser session and go to the URL you specify.