Help me in fixing the error
I have the below script to copy a range of cells from usc.xls workbook survey details sheet to CSAT US&C Falcons.xlsm workbook in to Raw Data sheet.
It is not working.
Please help me in fixing it.
Thanks in advance...
Please Login or Register to view this content.
Last edited by kishoremcp; 04-26-2012 at 07:23 AM. Reason: Code tags not PHP tags.
Use thisIf the workbooks are not open, you need a separate bit of code to open both workbooks. But if you put the file path into the code like how you did, it wont work.Please Login or Register to view this content.
Let me know if you need the code to open the workbooks as well.
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]
Thank you for your help. It is working.
If what if the workbook is not open. I mean the source file.
I want to copy data from USC to CSAT US&C Falcons.xlsm
Please help.
Then use this codePlease Login or Register to view this content.
Thank you very much. It is working very good.
The only thing is it is making the source file open at the end. It is not closing and I dont want to keep it open. I want to do it silently. Is it possible.
I mean the from file usc.xls, i dont want it open at the end.
Put this line before the End sub.Please Login or Register to view this content.
Its working. Thank you very much. You are really helpful to me from the last 3 days.
Am glad it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks