5 posts / 0 new
Last post
error importing new shapefile

I'm trying to import a new map (which is in the required shaprefile format) and keeping getting a 'run-time error 1004' message  ... "The information cannot be pasted because the Copy area and the past area are not the same size and shape.
I have tried importing the default map.dbf file provided as part of the original setup files but that gives the same error when trying to import from within the StatPlanet_data_editor.  I'm hoping I'm doing something clearly wrong at the setup stage.  I did see another message poted on the forum but that appear to be answered offline. 
any clues would be greatly appreciated

StatSilk's picture

Hi,
 

That's odd that it doesn't even work with the map.dbf. There has been an issue with an update to Skype causing issues with paste in Excel, which you can read more about here - http://www.statsilk.com/support/faq#error1. Other than that, I am not sure what could be causing it.

 

Would you be able to click on 'DEBUG' and then indicate the line number? It should open the 'code view' and in the top of the page somewhere it says the line and column nr, e.g. "Ln 23 / Col 28".

 

Best,

 

Frank

 

Hi,
Ln 546 ...
'Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:= _
                False, Transpose:=True'
I am wondering if its because I am using Excel 2003 whereas the StatPlanet_data_editor2 file was developed with a more recent version of Excel.  I'm assuming that the first column in the Indonesian example dbf file is the ID column and that NAME2 (col 4) is the correct column for names of the areas to be mapped (NB: the ID column is numeric and col4 for names does contaoin spaces).
I removed Skype of the PC but that didn't remedy the error.  I'll try it on my home PC which has office 2007 but if you have any other thoughts, that would be much appreciated.
Steve
 

all sorted now - thank you.
it is indeed a version related error with office 2003 not compatible with the SP data editor. 
thanks again :)
 

StatSilk's picture

Hi Steve,
Glad to see that you identified the issue. I am surprised this line does not work in Excel 2003 as it should recognize the syntax. If you wish to use Excel 2003, maybe replacing it with the following would work: 
 

'Copy map IDs        
Cells(1, 11 + colShift).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True
Sheets("Import names").Select
Cells(2, 11 + colShift).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True        
 

Best,

 

Frank

 
 

USER LOGIN