VBA to Save a file to a different format but keep original
You can always to
Application.ScreenUpdating = False
' sample code provided to save the file
application.ScreenUpdating = True
and you will not see the sheet pop up.
--
Regards,
Tom Ogilvy
"groutch" wrote in message
om...
That did it - thanks Tom - Although it's a bit ugly to have a new
sheet pop up just to do this ?
Don Guillett's proposed solution leaves the workbook renamed as
aa1.csv, just as my attempt did, so is not a solution.
Thanks,
Richard
|