10-26-2020
11:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
10-26-2020
11:59 AM
simply change your code like this:
set oWorkbook = oExcel.WorkBooks.add
Also, a Workbook created from VBA does not contain any sheets. you must add them first