Saving sheets without the Macro.

[cjpicc11]

Hey guys,

I'm running a macro for work where sql statements are ran and it than applies this data to a worksheet, it then saves the file on a Network drive. How would I be able to just save that information on to the file without the Macro. I dont want anyone to see the macro. Any help would be greatly appreciated.

Thank You

 

[PHV]

Have a look at the Copy method of the Worksheet object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886