Open and Save Using VBA
I am using Excel 2010 running in Windows XP. I would like to depress a command button which will allow me to open an Excel file. Once the file is open I would like to save it immediately ensuring the original file isn't changed. How can I programmatically do this using VBA? The name of my original file is called databaseFile and has an extension of xlsx.
Last edited by ajocius; 12-15-2012 at 08:17 AM.
I neglected to mention the need to change the name of the saved file to something else. Sorry.
Hi, ajocius,
assuming that both workbooks are located in the very same folder:
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
Holger, I'm navigating to a different folder and open the databaseFile. Each week I make some changes and Save As with a suffix (date). The new file now is saved in another folder which contains data files for the following weeks changes.
Tony
Hi, Tony,
Is that always the same folder (can be laid down in code) or do you wish to have a Dialog to pick the file?I'm navigating to a different folder
Always the same folder or switching from month to month or year to year?The new file now is saved in another folder
Ciao,
Holger
Holger,
I would like to have a Dialog to pick the file. At the beginning of the year I make 52 folders which represent each week. Each folder has datafiles which I accumulate throughout the week. I put bits of data from each file and place into the database file. I'm always changing from one folder this week to another next week.
Tony
Hi, Tony,
Please Login or Register to view this content.Ciao,Please Login or Register to view this content.
Holger
Holger,
Sweet, this is what the doctor ordered. Awesome. One last request. Is it possible to check MyDocument folder and only open Excel files? That would make this go from 95% to 100%.
Tony
Oh I forgot yet again. I'm using the SaveAs3 function.
Tony
Hi, Tony,
no problem with that.
If you cancel the saving part the workbook stays open - please inform me if you wish to close it in this special case (just a small amendment in the If-clause).Please Login or Register to view this content.
Ciao,
Holger
Holger,
[SOLVED]
This is precisely what I needed. Great job in helping this engineer do his job. Consider this problem solved. Hope you have a wonderful day. Take care and God bless.
Tony
Hi, Tony,
glad if I could have been of some help. Could you please mark this thread as solved (according to FAQ) although you´ve already done it in the post? TIA.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks