Recent content by xcruc1at3r

Kindly if anyone can help me with Excel Report in terms on weekly comparison Chart report by counting the dates with exist in F column 31-mar-2014 if we click Monday so it should show 2 weeks comparison chart of Monday and should have multiple option as well of clicking week days!. with dynamic...

i am trying to do that hui, i have registered few of the VB Forums...like you said.. i'd let you know if i succeed

Yes i have a worksheet called "yoursheet" i am trying that out Hui thanks for your advice you have rectified the error "WbSource is dimensioned as an object but not assigned to anything, which looks odd" so what can i do about it ?

Hui Need your help.... this is executing but stops at LR = excelApp(WbSource).WorkSheets("yoursheet").Range("B65536").End(xlUp).Row is not able to find the source !... i have reached this far!! Hui .... error : object doesn't support this property or method property let procedure not defined...

we log in once and after that we start working on it for as along as we want and we can move through screens as well... if the software stays idle for 20mins so it logs out...

hmm!! when i open it shows the Snapshots and when u are opening it so its not !! i guess its not properly uploaded thanks to Google.doc! let me email it to you if you dont mind ! i have your email address with me :) cause you have helped me a lot...

well if you would open it in Google.doc so it wont display the snapshots Hui! u need to download it!!...

this is the link of the reflection Screens step by step ! https://docs.google.com/spreadsheet/ccc?key=0Ah3qQ3ZqPOsPdHhlckhsdmctbXIybmhVVkJQZ2VfSWc i was thinking !...as data is in B & C rite like this B C APZU4626368 APA9919941 TRLU3853663 APA9910157 what if we rearrange...

as i tried to run it it said Dim c As Range is not Defined do i need to add all the method that created as it is for C as well after Next c ?

well i surfed internet and got some the top part to link excel with reflection from 1 site and then the Password area is recorded and next is recorded mixed if my efforts in trying and testing...!! laid out in what sense ! maybe i can explain !

Dim B As Range Dim C As Range for each B in excelApp.ActiveSheet.Range("B2", Range("B1048576").End(xlUp))?? for each C in excelApp.ActiveSheet.Range("C2", Range("B1048576").End(xlUp)) ?? well its not clear to me am not that good with all this!! if you could add the Loop in it and create a...

yes so on..starts from picks data from b2 1st then c2 , then b3 then c3 ....and so on...but the coding is a test coding and as you can see in the last of the coding its till b4 .. i forgot to add after .WaitForDisplayString "SEALS..:", "30", 4, 2 z = excelApp.ActiveSheet.Range("C4").Copy...

well hui thanks for showing your interest ! 1st of all..... well Excel is linked with a software Reflection of IBM.... Set excelApp = GetObject(, "Excel.Application") Set excelApp = GetObject("C:Documents and SettingsmintezarDesktopBook1.xlsx") z = excelApp.ActiveSheet.Range("B2").Copy...

I here any possibility that can we Make it Excel dynamic range cause the excel varies its range? if the code would be really big so it would take load of time and memory as well Sub macro_22333() Dim excelApp As Object Dim z As Integer Set excelApp = GetObject(, "Excel.Application") Set...

Need help around here !! plss!!