0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
1 Posted Topic
 | [QUOTE=seagull]Not sure if you've solved this yet. I had exactly the same problem. Got this to work eventually. I needed to explicitly declare a1 as a range Dim xlApp As Excel.Application = New Excel.Application xlApp.DisplayAlerts = False xlApp.Workbooks.Open("c:\test.xls") Dim xlSht As Excel.Worksheet = xlApp.Sheets(1) Dim xlRng As Excel.Range = xlSht.Cells(1, … |