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