Copy paste excel file from Access VBA (1 Viewer)

Rakesh935 · Mar 31, 2015

Hi,

Have a requirement in which I'm really confused how to proceed.

All I need to do is copy an excel file from a location (while coping the file, the location of the source file remains same all the time)and paste that excel file where ever I want (Browser Option) from an Access VBA.

Request for your advise.

Thank you
Rakesh

Gasman · Mar 31, 2015

I did something similiar, had to import an excel file everyday, and I just used a macro running the saved import. Also used a macro to delete the existing data.

Reason for the macro route was others had to maintain it and had no knowledge of VBA.

That was using Access 2007.

HTH

Rakesh935 · Mar 31, 2015

Thanks for your reply.

But over here I already have a access database which will open the excel file (excel file is a template file), update, save and will close the excel file. And the same excel file is accessed by multiple users which leads to excel file corruption very often.

So I need something in the access (VBA code) to duplicate the same file and save it to some different location (Browser option)

Thank you
Rakesh

Gasman · Mar 31, 2015

Use FileCopy ?

http://www.rondebruin.nl/win/s3/win026.htm

Frothingslosh · Mar 31, 2015

Sounds like what you're looking for are FileCopy and Application.FileDialog.

Copy paste excel file from Access VBA (1 Viewer)

Rakesh935

Registered User.

Gasman

Enthusiastic Amateur

Rakesh935

Registered User.

Gasman

Enthusiastic Amateur

Frothingslosh

Premier Pale Stale Ale

Similar threads

Users who are viewing this thread