Please use ruby-lang instead of this mailing list (or StackOverflow.com) for generic Ruby questions. This mailing list is to discuss bugs and new features of Ruby. On Tue, Nov 11, 2014 at 8:21 AM, David Morrison <davesruby / gmail.com> wrote: > 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, "Risers" >> 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 >> >> >