Recent content by laks143

hi I am trying to Copy Mainframe screen and paste it in to Word document.I am getting an error like autECLMacro Sub or Function not defined. Here is my code Dim word Dim autECLSession, autECLPS, autECLOIA Set autECLSession = CreateObject("PCOMM.autECLSession") Set autECLPS =...

Hi I am trying to open an excel through Excel VBA. I am getting Sytax error at sheet.workbooks.open "C:\Documents and Settings\"&sapid&"\Desktop\mysheet.xls" ,true,false Here is my code Dim sheet Dim sapid sapid = InputBox("Enter your SAP ID :") Set sheet =...

Hi Mark , Set WSHShell = CreateObject("Wscript.Shell") pathToDesktop = WSHShell.SpecialFolders("C:\Documents and Settings\1055214\Desktop") WSHShell.Run (pathToDesktop & "PCSWS.exe") the code that you gave is working fine I have given the ip address in the link parameters and i...

Hi Mark , Set WSHShell = CreateObject("Wscript.Shell") pathToDesktop = WSHShell.SpecialFolders("C:\Documents and Settings\1055214\Desktop") WSHShell.Run (pathToDesktop & "PCSWS.exe") the code that you gave is working fine I have given the ip address in the link parameters and i...

I want to open mainframe session through VBA.Can any one tell me how to do this. PCSWS.EXE is placed on Desktop. Thanks In Advance !!! Lakshmi.

hi i am trying to paste a screen shot which is in clipboard in to a word set word= CreateObject("Word.Application") Word.Visible = TRUE Word.Documents.add() word.document.parentwindow.clipboard.getimage() word.Selection.Paste but the above code is pasting the...

Hi i am trying to read & copying the content of an excel which is already opened to another excel i am getting 'Activex component cannot create object' error messge. please correct the following code. Dim sheet Dim sheet1 Set sheet = CreateObject("excel.application") sheet.Visible =...

Hi i want to read the excel which is already opened in VBA.can any one help me in this...

Hi, i want to export a PS in to EXcel in rexx.Can any one help me in this.. Thanks in Advance!!!

hi how can i get data from mainframe dataset to excel through vbscript

I am trying to call private events . sheet.Worksheets(1).CommandButton1_Click this macro tool is placed in share ...and no one can edit this.the events in the tool are private ..i am not able to call.how can i call this events without changing them from private to public. thanks in Advance !!!

additional information : vb script is written in Mainframe macro editor. i want run the excel macro which is already opened.

Hi all, I want to run a excel macro tool which is already opened by giving proper inputs like date(20/12/2008) in B4 cell and 10 digit policy number in A4 cell .. even i want to know how to press the buttons on the tool by VB script.button names are like 'run policy value' ,'database' If...

how can i make sure that the excel sheet in share is loaded completely. sheet.workbooks.open "H:\plan\pv.xls",false,true This sheet will take atleast 4to 5 minutes to open. do i need to wait the script for 5 min...how can i make it

thanks PHV,one more help ... how can i make sure that the sheet is loaded completely. This sheet will take atleast 4to 5 minutes to open. do i need to wait the script for 5 min...how can i make it?