When I run this code in Sketchup, it performs it's duties, then opens
excel, enters the info, then I want it to save as the Address.
And that is where I am having the problem.
Thanks.
ents=Sketchup.active_model.active_entities
···
prompts = ["Company Name", "Address","One","Two","Three","Four"]
defaults = ["My Co","69 Your Street",1.0,2.0,3.0,4.0]
input = UI.inputbox prompts, defaults, "Stuff"
a,b,c,d,e,f=input
ent = Sketchup.active_model.entities
pts =pts[0] = [0,c,0]
pts[1] = [0,d,0]
pts[2] = [0,0,e]
pts[3] = [0,0,f]# Add the face to the entities in the model
face = ent.add_face pts
face.pushpull 4
#Open excel and enter info
require('win32ole')
excel = WIN32OLE.new('Excel.Application')
excel.Visible = true
workbook = excel.Workbooks.Open('C:\TestFolder\Test.xlsx')
ws = workbook.Worksheets(1)ws.Cells(1,1).Value = a
ws.Cells(1,2).Value = b
ws.Cells(1,3).Value = c
ws.Cells(1,4).Value = d
ws.Cells(1,5).Value = e
ws.Cells(1,6).Value = f# workbook.SaveAs("C:\TestFolder\" + b + ".xlsx")#trying to get 'Customer Address' as the saved workbook