HI,
I've tired to do this on my own and and as in my previous post I need help on this.
I opened a workbook and moved data from it. Now I would like to close the workbook with out saving to a different folder.
This is a code that I tried. But, it ask if I want to save. Which I do not.
The test code is in my master workbook. Not the file I'm trying to close.
Please Login or Register to view this content.
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
How about this?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi,
Thanks for your reply. However, the file does not go to the "QCProcessed" folder.
Hi,
The file I wish to move to a different folder is in the main folder called "QCcard".
With in it I have 2 folders. One is called "QCComplete" and "QCProcessed".
The code that I currently use will move the "Completed" file to the correct folder.
My problem is still with the "QCProcessed". I've tried revamping the code supplied by Backerman.(Thanks) But, I still can not the file to move to the "QCProcessed" folder.
If someone can shed more light on this. I would be grateful.
Hi,
After more research this is a bit of code that helped me.
Please Login or Register to view this content.
Sorry for late response but due to obligations at work no time to look in it further.
This could also have been a possibility.
BTW Thanks for adding rep points.Please Login or Register to view this content.
Last edited by bakerman2; 08-28-2016 at 02:15 AM.
Thanks for the code will keep it.
Charles
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks