Still the same issue I'm afraid
The full script:
Sub CATMain()
Set objexcel = CreateObject("Excel.Application")
objexcel.Visible = True
Set objWorkbook = objexcel.workbooks.Add()
Set objsheet1 = objWorkbook.Sheets.Item(1)
objsheet1.Name =...
Hi all,
I have the same issue (trying to export coordinates to excel) and came across this thread from the search function.
The macro looks like it would fit my needs perfectly but when I try to run it it fails on Line 13 "dim coords(2) As Variant".
I really have no programming experience...