Need to create a batch file or vbs script to copy a file to multiple user profiles

Use Robocopy, it's so simple.  Try this:

From a command prompt with administrator level privilege run the command:

Robocopy C:\Users\USERWHEREFILEISYOUWANTTOCOPY\Downloads C:\users\%usernames%\appdata\Roaming\Microsoft\Windows\Startup\Programs folder

Simple.

Excuse my mistake on the first suggestion it should look like this:

C:\Users\USERWHEREFILEISYOUWANTTOCOPY\Downloads C:\users\%usernames%\appdata\Roaming\Microsoft\Windows\Startup\Programs folder filename.file

Sorry for the three comments in a row, I just wanted to point out that you use first

Robocopy

Then the location of the current file you want copied (i.e. C:\users\userinquestion\downloads

Then the location where you want the file copied to (i.e. C:\users\%usernames%\appdata\Roaming\Microsoft\Windows\Startup\Programs folder)

Then the actual file name (filename.file)

Robocopy takes the first command, the first location, and the last location and says ok move this file to this location.

How could i use robocopy to copy it to all the profiles? when i tried the above, the robocopy only copied it to the admin's profile location.

I think you need %username% instead of usernames.  Also, make sure you right click command prompt and select "Run as Administrator"

Just copy files to this location and it will be available to all users.
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup

You are wanting to copy file c:\Downloads\test.vbs to all profiles all at once, right? The above examples will work to copy the file to the profiles WHEN the users logon again. In other words, by using either GPO or a logon script the above solutions will copy the required file to the user's profiles once they logon. And I think you want a solution to copy that file to each profile NOW and not when they logon, am I right?