Copy file using VBScript?

[Base]

Hi all,

Can anyone help me with VBScript syntax to copy a file from a folder under c:\program files\ to the desktop.

or else to create a shortcut of a specific file.

I can't seem to get the syntax right.

Thanx
Base

 

[Joe4]

I am assuming you mean in Access VBA, since you posted it in the Access board.

If so, take a look at "FileCopy" and "CopyFile" in Access VBA help.

 

[Base]

Hi jmiskey,

To tell you the truth - I was looking for the VBScript syntax. The thing is other forums are not like this one (where people actually answer you). So I tried posting it on VBScript website forums but no answer. Hence me coming back here to check for someone with cross-know-how.

I did come right with the syntax (but using a .bat file) but my major problem was that I wanted to create a shortcut on all my client's desktop (Win95 -> XP). But as you know with later versions of Win the desktop no longer sits at C:\windows\desktop. So I ended up with the following batch file:

C:
cd program files\clubbase
copy clubbase.lnk "c:\documents and settings\all users\desktop"
copy clubbase.lnk "C:\Windows\Desktop"

To make sure the shortcut gets created on all versions of Windows.

Thanks for your help though
Base