Basically I have 2 workbooks open at the same time say (WS and WB)
WS<--- where the macro is
WB<--- a workbook opened during runtime
during runtime WB is activated to check for comparisons and if the values are not
equal I need to write something on WS for the log and then continue the check on WB.
how do I do this?
I tried
but it results to error.
Please Login or Register to view this content.
Any help would be greatly appreciated thank you!
Last edited by JBeaucaire; 09-04-2012 at 08:02 AM.
it seems like its not on the workbook referencing that has an error...its
the .value part...it says Run time error'1004'; Application-defined or object-defined error
but I cant seem to figure out why because I'm pretty sure
.value is a property of range.
Your syntax above appears correct.
THe error you've noted usually indicates an object may be missing and the only objects I see are ThisWorkbook and Sheets("log". Does that sheet exist in the workbook that stores that macro?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
yeah....it does exists... I figured out how to solve this one...I used this
I don't know though how it solves the problem..bec. as far as I knowPlease Login or Register to view this content.
range and cells are the same except for the parameters....
You are correct. There is no objective difference between these two syntaxes:
Please Login or Register to view this content.
If that takes care of your question, please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks