Excelpromax123
Board Regular
- Joined
- Sep 2, 2021
- Messages
- 167
- Office Version
- 2010
- Platform
- Windows
Hi everybody . I want to export an area on the working file to a new file on the dekstop, what should I do?
I would suggest the following procedure:
1. Check if there is a file named "New.XLSX" on the Desktop. If not, create a new file "New.XLSX" . If yes, then Export overwrite it
2. Copy the area to be exported For example: Sheets("data").range("C7:E16").copy to the file "New.XLSX" created on the Desktop and paste the Value at position A1 in Sheet1
3. Close File "New.XLSX"
Sincerely thank everyone
Sincerely thank everyone
I would suggest the following procedure:
1. Check if there is a file named "New.XLSX" on the Desktop. If not, create a new file "New.XLSX" . If yes, then Export overwrite it
2. Copy the area to be exported For example: Sheets("data").range("C7:E16").copy to the file "New.XLSX" created on the Desktop and paste the Value at position A1 in Sheet1
3. Close File "New.XLSX"
Sincerely thank everyone
Sincerely thank everyone