Search results

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!!

well main frame will import from excel... if the path i given with input location such as given in the attached excel file...

well the excel worksheet is based on 2 columns A & B only well In A u'd Find Comtainer No. like this >>>AMFU3011682 and in B you will find SEAL : APA9916698 << like this... for your ref below are sum seals ( sorry for the late reply) you can create a Example excel file in...

SirJB7... Thanks a lot for all your Help and efforts...May you gain more knowledge...

something like this ... Sub Collect_Trade_Data() ' Open Data Dump workbook Workbooks.Open Filename:="c:pathsample.xls" Windows("sample.xls").Activate ' Check if the first cell contains data. If not then close file If Range("Sheet 1!A1") = "" Then ActiveWorkbook.Close...

well We have already approached them and they are saying whats benefit cost saving and would it cut the resource !... if they would do it so... that will send 1 guy home!!... bro... due to which i would like Chandoo's forums support!...so that i would help us decrease the Work Load... as i see...

This is the link for the file http://speedy.sh/6NBSk/Paste-Data.xlsx

is it possible to run macro in the software which should copy data from excel sheet and paste field ?!!...lets try it with 1 application window!.. let me attach the link for that...

yes The blue link the Https you need to down in order to see the snaps shots ! sorry for the late reply

well i have created a Excel Sheet with snaps of the Software and the sample Excel sheet format... kindly check..... https://docs.google.com/spreadsheet/ccc?key=0Ah3qQ3ZqPOsPdENKNlNkOUZyN1FiSEtTU0JfRUxLS3c

Luke the software we are using are made by IBM... a customized software.... it records macro as well i tried to record so it did... like i recorded a macro for login...so it did... the recorded macro coding End SubSub START_BOOKING() With Session .WaitForEvent rcEnterPos, "30", "0", 1, 1...