Macro works - just need to send result to Excel and not MsgBox

[D_N_L]

Hi all,

With the wonders of the web I've managed to cobble the below code which successfully tells me how many emails are in a particular folder. However the result is displayed in a message box. I really want to send the result to an Excel sheet that has the following details:

Name: 'CountofEmails'
Location: C:\Documents and Settings\My Documents\Downloads

Can anyone help?

Please Login or Register  to view this content.

[LaffyAffy13]

you want the name of the file to be "how many emails exist"?

[D_N_L]

Hi Laffy,

Yes that's fine. Thank you very much!

[LaffyAffy13]

or do you want to to literally be called "Count of Emails"

[D_N_L]

Hi Laffy,

'Count of Emails' will suffice.

[LaffyAffy13]

Is that a file already created on your computer that you want to open and replace old data with, or are you looking for something that will delete the file and then recreate it every time?

[D_N_L]

Hi Laffy,

Yes that's a very good point. The file already exists and would need overwriting each time (keeping the same filename)

[LaffyAffy13]

Ok well this deletes the file and then creates it again.

Please Login or Register  to view this content.

And this one just opens the file up and edits it. Let me know if something doesn't work properly.

Please Login or Register  to view this content.

[D_N_L]

Hi Laffy,

Thanks! I tagged the first one on the end of my original code - is this what I am meant to do? I then clicked run and the the word 'Windows' in the below code is highlighted and the following error comes up:

Please Login or Register  to view this content.

Compile Error: Sub or Function not defined

[LaffyAffy13]

Oh, yeah. Here replace the "With" area with this and tell me if it fixes it:

Please Login or Register  to view this content.

[D_N_L]

Sorry. Still the same thing. This is my complete code at present:

Please Login or Register  to view this content.

[LaffyAffy13]

When you get to the error, is there at least a new workbook named "Count_of_Emails"

[D_N_L]

Yes, i already created it and put it at the loacation

[LaffyAffy13]

I don't know what the problem is, but I do know that you can just use this code and it will do the job as well.

Please Login or Register  to view this content.