save as the file with default yes

[vimalanathk]

Hi,

after running my macro i wanted to save as the file. while saving as system is giving the attched warning mesg where i have to click on yes. now i wanted to fix that in script where it accepts yes and save as the file.

activeworkbook.close is closing only the internal window. please let me know how to close complete excel appliction through script.

regards,
vimala k

[judgeh59]

add this to the beginning of your code

Please Login or Register  to view this content.

and put this at the end

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[vimalanathk]

then how to close the complete excel application?

[judgeh59]

the Application.Quit should be the very last statement. It should close the XL file and instance, so be careful

[vimalanathk]

hi,

this is working fine for me.... one last doubt.

i need to put the month and year as 2014_10 if i am running the macro in October. if i am running the macro in september it should give me 2014_09.

can you help me on this.

regards,
vimala k

[judgeh59]

not sure where you want this but this should work

Please Login or Register  to view this content.

[vimalanathk]

column m of my report contains the dates.... where i wanted to chage that column to the format of YYYY_MM.

it should be (_) and not (-).

hope this is clear.

regards,
vimala

[judgeh59]

I mis-understood....you just want to change the format in the dates in COL M to YYYY_MM...try this...

highlight the column and go to format cells...
go to custom format and type in the "Type:" field YYYY_MM
click OK

that should change the way they look

NOTE: this will only work if the dates are real XL dates...

[vimalanathk]

but i want this in script. the user is not allowed to select and choose the options. so help me out the same in a script.

regards,
vimala

[judgeh59]

sorry, I'm not sure what you are talking about...

[vimalanathk]

direct in sheet i can go to the sheet and select that option what you have given... but i wanted this activity in the script.

regards,
vimala