Problem to save the exported chart data into excel through macro

[Anonymous]

Hi Geniuses,

I have got one dashboard on web which actually help me to pick the data of different objects and save it into the different sheets of the excel file

Now the problem is its not saving that file, I want that once I reload the dashboard macro will run create the workbook and save it to the specified path and when I run the dashboard again it will replace the excel with the current data that is truncate and load, I dont want concatenation

I am attaching the application please look the macro exportToExcel_Variant2 I want to modify this macro.

Please help me as I have to submit this today

Thanks in advance

Shashank

[Anonymous]

Still its not closing same hanged screen problem

[omyahamburg]

This works with me.

[Anonymous]

Can You upload it again I think its not properly uploaded as I am not able to open it

[omyahamburg]

Try to use this in your macro

filePath ="C:\M"&".xlsx"     'try this path first, then change to your path

objExcelWorkbook.SaveAs filePath

objExcelWorkbook.Close 

Please note, this closes the Excel file, not Excel itself.

[Anonymous]

objExcelWorkbook.Application.Quit

I used this and it worked

But realy thanks for ur awsum help