LinkBack URL
About LinkBacks
Hi
I have this VBA that work for me, but I want to update my sheet without opening the other file. any idea how i can do this?
thanks in advance.
Please Login or Register to view this content.
Hi
I have this VBA that work for me, but I want to update my sheet without opening the other file. any idea how i can do this?
thanks in advance.
Please Login or Register to view this content.
Last edited by robrobet; 07-04-2013 at 02:04 PM.
I guess you could try something like:
Please Login or Register to view this content.
Thanks for reply, this code work fine but when it copy the value then show me ref, ref in all cells,
Sorry little more, is it possible when it copy to active worksheet then it start from active cell insted of sheet 1 range b5 :g42
Weird, dunno what is happening there but I think this should fix it:
Please Login or Register to view this content.
For Each cL In wb.Sheets("Sheet1").Range(activecell,cells(activecell.row+37,activecell.column+5).Cells
this line show red when I run it
Thanks for helping.
Originally Posted by robrobet
Please Login or Register to view this content.
I get this error
wb.ActiveSheet.ActiveCell.Resize(38, 6).Value = wb2.Worksheets("POMaster").Range("B5:G42").Value
Object does not support this property or method
Ok then try this...
Please Login or Register to view this content.
it work first time but now showing error,
DestCell.Resize(38, 6).Value = wb2.Worksheets("POMaster").Range("b5:g42").Value
Last edited by robrobet; 06-26-2013 at 04:26 PM.
Cross-post
http://www.mrexcel.com/forum/excel-q...ive-sheet.html
A message to forum cross posters
One more try:
Please Login or Register to view this content.
Thanks Yudlugar,
It work but not the way I want. Please help to change to.... I want copy the data from sheet pomaster range b5 :g42 and paste it to selected cell.
Hi, robrobet,
instead of
tryPlease Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
I get this error when I change it
Object does not support this property or method
Hi, robrobet,
my bad (file needs to be open) - could you explain to me why you would not open the other workbook, copy and then close again? Maybe read Copy a range from closed workbooks (ADO) for more information.
BTW: please apply to use code-tags on the procedure in the opening post. If you canīt edit that post maybe contact a Mod/Admin to do so. Thanks.
Ciao,
Holger
Robrobet,
In future, please do not post duplicate threads. Its against forum rules 5.
As per forum rules 3, you need to put code tags whenever you post code in this forum.
As per rule 4, do not PM questions to other forum members.
Dont freak out by so many rule violations. You are new to the forum and will learn. Just pay attention to the forum rules a little more.
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]
Thanks you
Last edited by robrobet; 07-04-2013 at 11:57 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks