Hi,
I am trying to create a macro on a template workbook that will open a specific file in the directory and then select the specific sheet name and copy it to the template and then close. For some reason, I am only able to get it to open the specific file. All the code after won't run and I'm not getting any errors. I am probably making a rookie mistake. Can someone please correct it? Thanks in advance.
Please Login or Register to view this content.
Hi,
I am already using following codes...
Check if they are useful for you or not.
Please Login or Register to view this content.Please Login or Register to view this content.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
I am getting an error on the GetOpenFilename line probably cause I'm not inputting my details properly.
Please Login or Register to view this content.
Hi,
1- Put enclosed file named "Template" to your desktop.
2- Put enclosed file named "Bank 010814" to under C:
3- Open "Template" file and run following code.
Regards.Please Login or Register to view this content.
Thank you so much for your quick response and I've used your attached files and it worked perfectly. For some reason, when I put it in my original workbook, I still get an error on the Set newwb line though. Is there anything that will cause this?
Change this line;
to this;Please Login or Register to view this content.
Let me know if it is okey now...Please Login or Register to view this content.
That worked, thanks for picking up the error!!
Dont forget reputation
Dont forget signed as solved...
Last edited by HerryMarkowitz; 09-05-2014 at 10:03 AM.
Done! I hope I did both correctly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks