ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   use macro to append records to worksheet (https://www.excelbanter.com/excel-programming/318181-use-macro-append-records-worksheet.html)

goingtospace

use macro to append records to worksheet
 
Hi. I am very new to writing macros and would really appreciate some
help. I have an excel macro that opens outlook, looks for certain
messages and extracts data from them to excel. so far so good. The
problem I have is that each time it runs, it creates a new worksheet -
I would like it to run in the same worksheet each time and append the
new records at the end. Any tips very gratefully received.
Thanks loads



All times are GMT +1. The time now is 04:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com