VBA: Adding assignment to the task

**kyosang** · 04-02-2008

I am trying to export data from Excel to MS Project using VBA. I want to do resource allocation programmatically based on their work hours. I am also getting an error that says:

Runtime Error : 1101
The argument value is not valid

Dim t As Task
t.Assignments.Add TaskID:=4, ResourceID:='test', Units:= 'hrs/meeting'
t.Assignments.Add TaskID:=4, ResourceID:='test1', Units:= 'hrs/meeting'

Is there anyone who can help me out? Thanks.

**Benjamin** · 04-02-2008

You are not supposed to specify TaskID when you are adding an assignment to the task.

**kyosang** · 08-02-2008

I have removed the task id, but am still getting the same error message. I am getting a type mismatch error like below:

t.Assignments.Add ResourceID:=t.Resources("test").id, Units:=8

I am using Project 2003 and I dont have any idea what does this means? Thanks for any help.

**LaverneB** · 25-03-2011

I've been reading this guide and it seems pretty straight forward. Seems like a sweet way of backing up all your Wii games to a hard drive so that you don't have to keep putting the discs in. The laser in my drive has been failing so it seems like a pretty good option.

Has anyone actually tried this? Is there any chance of breaking my Wii forever? For those who have already tried it, did you get banned from playing online?

**Garonman** · 26-03-2011

Originally Posted by LaverneB

I've been reading this guide and it seems pretty straight forward. Seems like a sweet way of backing up all your Wii games to a hard drive so that you don't have to keep putting the discs in. The laser in my drive has been failing so it seems like a pretty good option.

Has anyone actually tried this? Is there any chance of breaking my Wii forever? For those who have already tried it, did you get banned from playing online?

The main thing is that, hacking in online games can never be stopped and hackers will find ways around the ban codes, even brawl and MK hackers still hang around. There are public who are are using either action replays gameshark or homebrew to do all of this. There are also softwares that are kind of - go and bypass the games codes. People would just keep moding their software to get around it and continue hacking.