Can't Get Macro To Work

**Camel** · 07-19-2012, 04:26 AM

Hi

I have spent 2 days trying to get a spreadsheet to work! Can anyone help me out?

I have tried various versions of the sheet. Checked all extra spaces in the API credentials. I use windows 7 and Excel 2010.

Can you assist to see why the macro is not working? It seems like a simple setting issue.

Many Thanks!

**martindwilson** · 07-19-2012, 05:21 AM

what happens? do you get an error? can you record macros?

**Camel** · 07-19-2012, 05:22 AM

Yes. It just doesn't get working.

When I run the visual editor it gets an error when I run it.

Can you check if there is anything I can do to get it to work?

**martindwilson** · 07-19-2012, 07:06 AM

well pointing out the error would help,when i run it it stops at
URL = Replace(URL, "http://", "") what version of excel are you using?

**Marcol** · 07-19-2012, 07:16 AM

Have you read the intro to the script?

' Excel Interface to the SEOmoz Free API
' Written by Jason Green
' BusinessHut.com
' 4/18/2011 - Beta 1
' 9/22/2011 - Beta 2 - Changed to "on demand" function and added rate limiter.
'
' Verified in Excel 2007 and 2010 on Windows XP and Windows 7
' Does not work on Macs unless running a Windows OS on a VM
'
' Post your questions and suggestions for improvement at the URL below:
' http://www.businesshut.com/seo/using...ree-api-excel/
' To get your own API key, visit: www.seomoz.org/api *There are both free and paid options.
'----------------------------------------------------------------------------------

Can't Jason help for free?

**Camel** · 07-19-2012, 07:45 AM

Hi Martin

I really appreciate your effort in help me here!

I am using Excel 2010. I have read all the comments on the forum where the sheet was posted. I have done all they said.

When I enter in the details and run it, it starts to run and then says wait while it works...then I leave it for ages and it does nothing.

Others have got it to work and I have done exactly the various fixes that the forum mentioned.

Is there a way to see which line in the macro is generating the error?

Many Thanks!
Alex