R help - May 2011 - XLSM Question

Hi,
 
I would like to ask you how to read an arrary from an *.xlsm file? I have tried
different packages such as xlsReadWrite and RODBC. Everything is performed on
the final versions of addons and R.
 
Additionally, when I tried the RODBC received the following
error:
> library(RODBC)
> con = odbcConnectExcel("C:\\Temp.xlsm")
Warning messages:

1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) :

[RODBC] ERROR: state HY000, code -5120, message [Microsoft][ODBC Excel Driver]
External table is not in the expected format.

2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) :

ODBC connection failed

 

Many thanks,

Alexandros


	[[alternative HTML version deleted]]