hello
this macro write data on closed workbook, and i need to change little bit in code,
i don't want to use GetOpenFileName. I want to set the target workbook always = "Z:\42766\Jan 2 Dec 2014\1.5.14\MasterFile.xlsm"
I mean when i run this code then this workbook ( "Z:\42766\Jan 2 Dec 2014\1.5.14\MasterFile.xlsm") auto update without getopenfilename
thanx
Please Login or Register to view this content.
Hi, haroon2015,
with more than 600 posts you should be able to adapt that change on your own .
I donīt like the Activate and Select part in order to copy data.Please Login or Register to view this content.
Ciao,
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
hello, HaHoBe
this one is becoming yellow
script out of rangePlease Login or Register to view this content.
Hi, haroon2015,
I thought the code was running as you wanted except for the Application.GetOpenFilename? It canīt as there is only one entry for varCopyDest as well as varCopyTarg while whoever adapted the code didnīt consider the number of entries and allowed the code to raise a run-time error when trying to copy for the second (not available) areas.
Ciao,Please Login or Register to view this content.
Holger
works perfect as alway
thanx HaHoBe will add repu
Ciao,
Holger
Hi, haroon2015,
Yes but only as varCopyDest and varCopyTarg are identical, those 2 variables need to be changed/swapped if the areas are different (otherwise the copyto area would be copied and pasted into the copyfrom area).works perfect as alway
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks