![]() ![]() ![]() That is it, just setting row heights and column widths within the range specified. I will rarely be changing these values, so I am not concerned about anything fancy, no GUI, just the ability to edit values into the macro. Again, I need to input a value for each column. Then It must set the width for each column from A to M. ![]() I have to be able to input a value for each row. The macro is relatively simple I need it to set the height of the first 40 rows on a worksheet. Is there someone out in this forum whom I could hire to write the macro for me? My brain simply does not work like a programmer! zizi64 was kind enough to send me a sample code, but I just do not know enough about OO Basic to expand it to do what I need. I have been reading and testing, trying to get a relatively simple macro to work. ![]() Rem -ĭocument = ĭispatcher = createUnoService(".DispatchHelper")ĭim args1(0) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:RowHeight", "", 0, args1())ĭim args2(0) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:RowHeight", "", 0, args2())ĭim args3(0) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:RowHeight", "", 0, args3())ĭim args4(0) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:RowHeight", "", 0, args4())ĭim args5(0) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:RowHeight", "", 0, args5())ĭim args6(0) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:RowHeight", "", 0, args6())ĭispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())ĭim args2(1) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:GoDown", "", 0, args2())ĭim args4(1) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:GoDown", "", 0, args4())ĭim args6(1) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:GoDown", "", 0, args6())ĭim args7(1) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:GoDown", "", 0, args7()) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |