Perhaps it wouldn't hurt if you closed the account down and open up a new one.
Or maybe you need to actually place a bet on your UniTab account.

Good Luck with it.

The solution to find the problem is simple, if you know where the data comes from then do a manual import of the data to a separate sheet and record a macro of this process then compare the 2 vba codes to see the difference.

I don't have a unitab account other wise i would do this for you, last time i went to open one they wanted a $400 deposit.

Spreadsheet Result..
 

Good evening all that have posted here or have read this thread.
I spoke to the unitab people today, to ascertain if my account was valid, and had they changed their web configuration.
Well, my account is 100% Ok.
However, they have changed from tabonline.com.au to unitab.com, plus have updated their formguide access points. All this is sort of gobbly gook to me, not being web or programme savvy, but it virtually has rendered my spreadsheet unusable.
I have a work colleague who is right into VBA (uni and all that stuff). He looked at the spreadsheet (code and macros) for me and advised me that the spreadsheet has outlived its ''use-by'' date and I should look for other avenues of gaining the form I want.

Again, I wonder if OZDOC has had the same problem I have encountered, and if so, has he built another spreadsheet that is compatible to the new unitab set-up.... I hope so. Until i hear from him, i will endeavour to look for another avenue of downloading detailed form into excel.

Thank you all for attempting to assist me in solving this problem.

Kind Regards..

gsdanger

When you go manually to the web page that has the detailed Form that you need , what is the name of the page?

That means when you are on the page , what does it say up top of your address bar?

Like http:// unitab/tabonline.com.au/17-08-2010-MR06.html

That is perhaps what needs to be placed instead of the name that is in your websheet at the moment.

I'll send someone to brouse your document and hopefully help you.

Moee can you send me the spreadsheet

I think the non working version or versions are here , along with what it is that the member is having problems with
http://forums.ozmium.com.au/showthread.php?t=20306