export table to CSV via VBA

[Gregorys05]

Hi Guy's
I need to automate a file export to CSV. i want to export a table called NotePadOutput and save to a csv on my desktop.

I have searched Google but can not find anything that works???

Any help would be great?

Thanks

 

[alansidman]

Look at this link

http://social.msdn.microsoft.com/Forums/en/isvvba/thread/d5432b8e-08f6-4b6a-b13d-fc7656970704

Alan