The Aston Villa striker has made a big impression in recent weeks in the absence of Darren Bent and is hoping to continue his form against the league leaders.
"We are all looking forward [to the match] because Old Trafford is a brilliant place and I think we will go there positive," he told Sky Sports.
"They are the games as a young player you want to play in and I've never been to Old Trafford so to be involved will be brilliant.
|WEIMANN FOR THE JOB?
||188Bet are offering 15.0 on Andreas Weimann scoring the opening goal when Aston Villa meet Manchester United on Sunday.
"But we are not going there thinking we are going to lose. We are going to try and get something out of the game.
"It's not long ago that Gabby [Agbonlahor] scored the winner there so why not again? We drew against a big club away in Liverpool and won at another in Chelsea so why can't we do it again?"
The 21-year-old has admitted that he has begun to look ahead to his international future and believes staying in the Villa team will help him achieve full honours with Austria.
"That is a goal for me," said Weimann. "I've played for the Under-21s, and to play for the first team of your country, is probably the biggest honour you can have.
"I have to try and get into that team. There are World Cup qualifiers in September. I'll just keep playing here, as many games as I can, and that will help me."
Weimann expressed his delight at finally getting off the mark for Villa after having to remain patient and spending time on loan at Watford.
"I'd dreamt of that day when I scored my first Villa goal for a long time and to do it in front of the Holte End as well was special.
"The fans and everyone went crazy, and it was a big relief for us as we'd not won at home for a long time and for me it was an unbelievable feeling.
"I'd scored on loan at Watford but you want to score at Villa because it's in the Premier League, the best league in the world.
"The Fulham goal was a tap-in really but against Stoke I also showed that I could hit a ball and it was up there with the best goals I've scored."
Now that he has made him mark on the first team Weimann has admitted that he will be working towards staying there and is ready for the hard work required.
"When you're on the pitch, you have to try and stay in the team. I'll try every time I'm out there to do my best and show the manager what I can do.
"We'll see if I get another chance. When you come into football you want to play as many games as you can.
"Now I have the taste for it, I want to get a few more games, but it's up to the gaffer."