Macros save as CVS but only a Specific sheet

[CeLxIcFeTlON]

Dear All,

I need your help pls.

Using powerQ i'm populating sheet1 with fresh data which is then amended on sheet two. i created 2 macros.

1. refresh all - and it works
2. save-as only sheet 2 as CSV but keep the excel open - didnt work

What i'm getting instead is all sheets saved as CSV and the Xlsm is closing

Attached is the excel

[Artik]

Get interested in the SaveCopyAs method.

Artik

[mohadin]

Hi
Try

Please Login or Register  to view this content.

[CeLxIcFeTlON]

will do thank you any good link

[CeLxIcFeTlON]

Hi
Try

Please Login or Register  to view this content.

It did work but since i'm not an export on Marcos with this correction i lost that additional info where the .csv is saved

MsgBox "File " & Name & " has been Created and Saved under: " & FileName, , "Copy & Save Report"
Application.DisplayAlerts = True

Attachment 769820

[mohadin]

Please Login or Register  to view this content.

[CeLxIcFeTlON]

thank you