Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Multiple Excel worksheets: unknown identifier & ExcelSheet
#1
Hi, all,

I would like to copy several columns of figures from another program into a worksheet in Excel, then I would like to copy a specific column from this data into another worksheet. However, running the macro yields an 'unknown identifier.' error message and it highlights the first occurrence of 'ExcelSheet' in the file. I then tried running the sample 'Easier Excel functions' and I also get that message ......

My code is below, and this is with Excel 2010 and Windows 7. When it runs, it stops at "ExcelSheet es.Init("Buffer" 1)". Thanks for your time & any insight you can give.


act results
'Ca
'Cc
int excel=act(win("Excel"))
ExcelSheet es.Init("Buffer" 1)
'CH
'Cv
ExcelSheet bufferDonor.Init
bufferDonor.ws.Range("C1:C200").Select
'Cc
ExcelSheet es2.Init("Data" 1)
ExcelSheet dataDonor.Init
dataDonor.ws.Range("I2:I201").Select
'Cv


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)