Big Brain needed to TransferSpreadsheet

[CondtllyFrmttd]

Ok, I know my problem is simple but I cannot figure it out. I am using

a the TransferSpreadsheet property, I do everything right until I
specify the range.


My worksheet's name is "Inventory Report" so I know that my range
specification needs quotes"". I needed columns A:G but everytime I use

that I get blank rows in my table.


Here is where I trip up:


transferspreadsheet,,,,,Range:="Inventory Report!a1:" + strInvEnd


So I want the sheet called Inventory Report from A1 to range I
specified in strInvEnd


Someone with a large brain help!!!!!
(I've got my Excel and Access Object Libraries & ActiveX so that's not
the problem)
Using XL 2003 + ACC2003

 

[Cathy]

Would a simple solution be to take the space out of 'Inventory Report' so you
won't need the quotes?

Hope this helps.

~Cathy