Hello dear ExcelForum!
I need vba code to: upon activatting form contttrol button, wich triggers another code inside workbook, please dear Excel, make a copy of workbook in the same folder eg. BOOK1-Copy.xlsm
Thanks in advance, God Bless!
Hello dear ExcelForum!
I need vba code to: upon activatting form contttrol button, wich triggers another code inside workbook, please dear Excel, make a copy of workbook in the same folder eg. BOOK1-Copy.xlsm
Thanks in advance, God Bless!
Like this one ?
File damaged, unable to open.
@porucha vevrku
Sorry for off-topic interjection:
Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.
Thanks again for all your hard work here!
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There is an issue with later versions of Excel 2010 and on opening .xls files from the internet. I cannot open your file either. I have tried the workarounds that Google offers to no avail at this time. Please re-read my post #4 above and supply a solution in the body of the thread.
Meanwhile, I am still looking for a workaround that will allow me to open .xls files.
ok. Solved the issue of opening the file.
1. Open control panel in your windows PC
2. go to Programs
3. Uninstall a Program
4. Highlight MS Office
5. Click on Change at the top
6. A repair program will run for about 4 minutes.
7. File should be available to open
Thank you so much, but I need to modify this, i need to overwright existing book1-copy.xlsm file inside folder. How to do that?Please Login or Register to view this content.
Check if the file(workbook) exist in that folder. If so, delete it before copying.
Read about the "SaveCopyAs" method and see if that's what you want and to check physically, how does this code work, nothing else.
From MS help: "SaveCopyAs Method - Saves a copy of the workbook to a file but doesn't modify the open workbook in memory."
This code will overwrite the file with the same name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks