LinkBack URL
About LinkBacks
Hi All,
I am new to this forum.
Can anyone help me in writing a macro code for Opening a excel sheet and copy the data in it and close the file???
Hi All,
I am new to this forum.
Can anyone help me in writing a macro code for Opening a excel sheet and copy the data in it and close the file???
this macro opens file, copy sheet1 on sheet2, closes the file
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Thanks for your reply.
But I need that to be copied to a new file....
Hi, girish1989,
maybe try something like this (there´s still some information from your side missing (save to which name, xlFileFormat and where to save):
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
Thanks a lot
If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks