object doesn't support this property or method
I want to write the data without opening the excel file, but when i try to get the columns and rows, "object doesn't support this property or method"
I want use to TR and TC to find and locate the rows and columns, but error from there, any idea?
Write to WSO.zip
Please Login or Register to view this content.
Moderator's Note: Welcome to the forum, you have to put code tags around codes. Select the code then hit the "#". I'll do it for now. Thank you.
Last edited by vlady; 01-16-2013 at 01:52 AM. Reason: code tags
try it
PS Teowchy, please use code tags around your code in your postsPlease Login or Register to view this content.
thank you nilem, it has been solved when WSO_Record is open, but when target workbook is close, still come out with "object doesn't support this property or method", although i can put On Error Resume Next bypass this error.
again thank.
then maybe so
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks