SimpleSimon88
New Member
- Joined
- Jan 15, 2014
- Messages
- 19
Hello excel wizardry!
I'm fairly confident in VBA.
I have two questions which I'm struggling to iron out.
[REF1] I would like to ask how to use application.quit to close this workbook.
Currently, if I let the code run, it closes my workbook down but also any other workbook that is open.
Also
[REF2]
I need to find a place to research how to unload a form into a workbook that I do not want to open from address.
As an example,
Main workbook (with codes etc) = MAIN.xls
The workbook I would like to unload data would be = "Backup files.xls"
which example address would be = "C:\Users\Simon\Desktop\Backup files.xls"
Any help would be much appreciated.
Thanks
Simon
I'm fairly confident in VBA.
I have two questions which I'm struggling to iron out.
[REF1] I would like to ask how to use application.quit to close this workbook.
Currently, if I let the code run, it closes my workbook down but also any other workbook that is open.
Also
[REF2]
I need to find a place to research how to unload a form into a workbook that I do not want to open from address.
As an example,
Main workbook (with codes etc) = MAIN.xls
The workbook I would like to unload data would be = "Backup files.xls"
which example address would be = "C:\Users\Simon\Desktop\Backup files.xls"
Any help would be much appreciated.
Thanks
Simon