Search this Forum
As soon as I click the import data button, I get a Microsoft Visual Basic error message. Run-time 1004. Say it cannot find the data I am searching for.
[resolved via e-mail support]
I had the same error message as well. Specifically, when I clicked "debug", the highlighted bit of coding said:
Selection.PasteSpecial Paste:=xlPasteValues, SkipBlanks:=False 'convert formulas to values
Anybody know why this might be? Thanks!
This error can sometimes occur if you are using an older version of Excel. Which version of Excel are you using?
Another possibility is an Excel 'paste' issue caused by a recent Skype update - further details are provided here: http://www.statsilk.com/support/faq#error1 .
Perhaps you could try a little test to see if you can do the 'paste special' command in Excel (i.e. copy some text, then click on 'paste' and select 'paste special' - depending on your version of Excel). If it doesn't work, then it's an issue with Excel itself.