Search results for query: *

hI! I am tryin to do colum c ( 1 to nth row) split and put it in column M coudl you check it what is wrong in this one. thanks in advance Sub test() Dim strTest As String Dim arrTest As Variant Dim strColC As String, strColM As String, RW as integer strTest = [C1] arrTest = Split(strTest, ",")...

I have column c have text which contain , for example xxx24,yyyyyyyyy,abcde,mnopqrst,lmn12,abc13 i need to sepearate column c xxxx24, abcde,lmn12,abc13 column m yyyyyyyyy,mnopqrst before "," if it is <= 5 words put it in column c else column m is it possible could you provide the code

Hi1 could any body help in this one it is great help for me i have form in that date when i createnew record it shows automaticaly date today in my machine but it is in share drive, it does not show anyhitng in date in other machine. how to fix this one

HI the below code has monday to friday i would like to add holiday code also skip already given the below could you help me where i have to add 'If today is Monday,then check Fridays data else check yesterday's data. If strDayStamp="Mon" Then...

could you help me the below one what i am trying to do if the account- id <> 20.xxxx, yyyy it will write into excel what happens here the below code it shows including 20, xxxx,yyyy and journla id kkkkkk, demo Select case Account_id case "20", "xxxxx", "yyyyy"...

Hi! what is the syntax error the below if account_id <> "xxxx" and <> "yyyyy" <> "zzzzz" then msg box

how do i change the sheet name as Accounts Set xl_sheet_1 = xl_wb.Sheets("Sheet1")

could you help me what is the syntax error obj.Worksheets("Sheet1"("B2:B109").AdvancedFilter Action:=xlFilterCopy,CopyToRange:=("obj.Worksheets("Sheet1") G1").Unique:=True

Hi! anyone help me the below request: the report has main menu date applivation decription ==================================== 1/11/08 Accounts M&C ===================================== 1. 1/11/08 M&C details 40 2. 1/11/08 M&C Accounts 6 how do I GO...

first of all i would like to thank you veyr much SKIP, MR, MILSON, VZCHIN, now i need help for reports from extra! i have a report contains 40 pages, each page press f8 . in each page i need only assets, liablites corresponding values in txt file but each pages assets, liablities has different...

HI! THE BELOW CODE WITH END WITH HAS SYNTAX ERROR. COULD YOU TELL ME WHAT IS THE ERROR? THANKS IN ADVANCE with obj.Worksheets("Sheet1").select obj.Worksheets("Sheet1").Cells("1:4").Font.Size = 12 obj.Worksheets("Sheet1") .Range("1:4") = "x";"Y";"Z";"B" End with OR...

i have Sess0.Screen.GetString(9, 3, 100)) for example xxxyz, xxxyz1234,xxxx7352,yyyME,YYYMEZ10 ..... HOW DO I SEPARATE IN EXCEL SHEET TWO DIFFERENT COLUMN COLUMN A XXXYZ COLUMN B XXXYZ1234

could anybody help me the syntax of the below one thanks If Account no = (obj.Worksheets("Sheet1.cells(RW,"B").value)) then

Hi! coudld you help me in this issue i have excel sheet row 2 to 109 columnB compare with active screen 05/08 if it matches write in screen in column A how do write this code. thanks in advance

could you correct this one. i know somehting is missing here in page 3, 20, 25 copy into excel row 2 so here is the code RW = 2 Sess0.Screen.GetString(3,20, 25))

Could you help me the below one. i dont know how to write it in EB CODE the below code has copied everyhting in screen but only copy the head line and contents only could you guide me iRows = sess.Screen.iRows iCols = sess.Screen.iCols for iCount = 1 to iRows aline =...

Could you help me i have form with cmd button if i create the macro for attachmate extra! do i have to create progress bar? i need to run in attachamte extra and capture the screens and put it into excel sheet how do i do it in vb6. could you explain what i have to do? do i have to create the...

could you help me the below problem that i have it. where can i get it. do you have idea ! could you provide the code for that Excel does not allow me to create the : CreateObject("EXTRA.System") the Excel Ref Lib. does not have a ref to "Extra". I used all of the Public, Set and Dim. but...

could you tell me how to write the code in the below problem 1. i have to capture 4 screens to ecel sheet screen has Account no journl id journla model journal type there are four rows in one screen there are 5 screen each screen write in excel sheet as row wise. like A, B C D could...

Hi! I am new to this form and as well as extra!Attachmate I need help from your experts. how do i capture 5 screens in excel sheet in column vise capture contineously all 5 screens and from vb screen can i write the macro for extra! what really do i have to ? do i need to create the form and...