Access 2000 VBA

M

M. Griffith

Can I use Access VBA to copy an excel file from one directory to another
directory?
I have users that see different servers. Currently, I call a module that
creates the excel file twice just changing the file output string. This
doesn't seem to be very efficient.

Thanks
 
M

M.L. Sco Scofield

Don't suppose you bothered to try help, did you?

If you had searched for "file copy", "copy file", or even just "copy", you
would have found the FileCopy statement complete with a sample in 1/4 the
time it took you to post this question.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Top