saving file to Month folder as per date after email is sent & also making few cells blank

[KK1234]

Please Login or Register  to view this content.

I have two issues:
1. I want the file in PDF saved in appropriate Month folder as per the date.
Please refer to RED highlighted text.

Secondly

After all the above actions are completed, I want following cells to be cleared or say made blank.
Sheet3
Cells: G9, D11:E31, F22:F24, D33, G11 and F14:F19

I am not sure How do I modify the code to include this.

Need help please.

Regards

[HaHoBe]

Hi, KK1234,

actual date or value from the worksheet?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ciao,
Holger

[KK1234]

Thanks HaHoBe,
I will now incorporate this and will get back to you.
One question.
In a folder where it file is saved, Do I Name folders like ' Jan' , 'Feb' 'Mar' or I have to name them in certain way??

Sorry basic, but I need to get some clarification.
You are a real star to help me so promptly when I badly need it.
Thanks again

[HaHoBe]

Hi, KK1234,

it depends upon what abbreviation you take. If itīs MM it will be displayed as 09 and might suppress the leading 0 (thatīs why I usually take the year first and follow that with the month), if itīs MMM it would mean Sep for the month running and depending on the local system. You would need to elaborate if the folders already exist or need to be created.

If you refer to a different system you would need some help to find out in which folder the file needs to be saved (this help could be an array holding your folder names in the order of the months) and getting the correct folder name from there.

Ciao,
Holger

[KK1234]

Hi
Thanks.
I have saved as follows....my fpath..
c:/ab/cd/Ed/ff/dg.....and now I want to state your code.
I have opened folder as sep oct nov etc
Any help please
Regards

[HaHoBe]

Hi, KK1234,

if you work with windows the normal PathSeparator would be a backslash as opposed to the slash you show in your last post.

From what I understand from the question:

Please Login or Register  to view this content.

Ciao,
Holger