Access 2000 VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

export VBA code in forms, modules and reports 3
Override dialogue prompt for overwrite during export 2
Access 2007 & Vbs Output Restrictions 9
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Possible to create XL file then run XL VBA (to format & filter XL file) from Access VBA? 2
Access VBA creating an Excel spreadsheet with a total line 5
VBA Code to add "Microsoft Excel 12.0 Object Library" to Access .mdb VBA module 6
How do I code an Excel formula in Access VBA 9

Back
Top