Uploading a file

[JoeThis]

I am trying to upload a file using VBA. I have an access database that I want to upload a file from the users machine to a folder in a file server; then I want to take the name of the file and store it in a database.

I know that with Visual Basic I could use the CommonDialog object, but I do not see it as an option with VBA.

 

[Chad DeMeyer]

Read the following article and you'll be well on your way:

http://msdn.microsoft.com/library/d...ry/en-us/dnovba00/html/CommonDialogsPartI.asp

Regards,
Chad DeMeyer

I am trying to upload a file using VBA. I have an access database that I

want to upload a file from the users machine to a folder in a file server;
then I want to take the name of the file and store it in a database.

I know that with Visual Basic I could use the CommonDialog object, but I

do not see it as an option with VBA.