Excel VBA issues *Vista* - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Excel VBA issues *Vista*

ChrisUK Avatar
7y, 2m agoPosted 7 years, 2 months ago
Hi all,

Anyone an Excel VBA expert ?

I've got a macro that basically connects to the net & pulls off several pages of data.

Part of it looks like this:

MyName = "Query2"
ConnectString = "URL;http://web address.php"

Anyway - it works perfect in XP (tried on 3 machines fine), but I've tried it on 2 Vista machines & it doesnt work at all. It just "hangs" :(

Any ideas ???
ChrisUK Avatar
7y, 2m agoPosted 7 years, 2 months ago

All Comments

(13) Jump to unreadPost a comment
Probably firewall settings,you tried it with the firewall turned off?
Yes, still the same mate
You using Excel 97? I've read somewhere a while back that some macros are not compatible with Vista. I can only suggest upgrading to Office 2007 to see if it sorts the problem out.
Office 2003 I'm using !

mmmm, Office 2007 you say, I'll have to have a look at that, thanks
Just upgraded to Office 2007 - same issue ?
Any other ideas ? It not a stupid setting in IE that needs to be ticked is it ?
Just ran another of the queries & found that the import page was pulling through the IE data saying that there were cookie issues (site logged onto 1st in IE, then macro ran in Excel).

Are there any issues with Vista/IE/Office combined ?
The code you've posted connects to the internet for the information then selects the excel sheet and clears the previous download. But what happens after this, the code following what you have posted should be that that copies from the web address to the excel sheet.....can you post that too
besides the easiest way to find errors is to step through the code. Put a break where this code is and then step through it one line at a time to see where the error is occuring.
I cant post it all mate, it's HUGE !

The code itself is not an issue, it does work with Win XP - just ran it fine on my work lappy.

It's when it runs in Vista it has an issue.....
I'm just not aware of any compatibility issues between vista and excel. Not that it should make a difference but are you using IE8 on these machines?
IE8 on the Vista machine, IE6 on the XP machine.....

Good man, I'll try downgrading my Vista IE (dont use IE apart from this, use FireFox most of the time !)
might work I know of loads of compatibility issues with IE8. Its that worst version yet.
Downgraded to IE7 - still the same :(

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!