Hello everyone, I have certain problem of activating sheet name of another workbook. Like I have value of in Book1 Sheet1 A1 of "Jun-10" on Book2 I have a worksheet named "Jun-10".I just want to select that particular worksheet..or select the other worksheet if i change the value on Book1. Thanks!
Simple...in your code use this statement -
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
You need to activate the other workbook first and then select the sheet you want.
Good luck.
hi again. I really appreciate your help.i didnt mentioned that the Book2 should be opened also through VBA code.hope you get my point.by then let say the book2.have content each sheet..should be copied back to book1.
Why dont you attach a sample of both book 1 & 2?
here is the sample workbook..Book1 and Book2.on Book1.Sheet1 A1 has value and command button.Once the command button press it will open Book2 and selected the sheet name on Book1("Jun-12"),and the value inside sheet name Jun-12 Column A and B will be copied back to Book1 sheet1 column G and H.Thanks..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks