Tere ja head jätkuvat aastat! Seekord vaatame makro koostamist Excelis. Esmalt tuleb avada Excel, vaadata, kas Arendaja (ingliskeelses Excelis Developer) […]

Exceli töölehe lisamine ja kustutamine: https://support.microsoft.com/et-ee/office/t%C3%B6%C3%B6lehe-lisamine-v%C3%B5i-kustutamine-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2 Kontroll, kas Exceli tööleht on olemas, ja kui puudub, lisa VBA abil: https://www.exceldome.com/solutions/check-excel-worksheet-name-doesnt-exist-and-then-add-a-worksheet/ […]

Exceli lühijuhend: https://support.microsoft.com/et-ee/office/t%C3%B6%C3%B6vihiku-loomine-excelis-94b00f50-5896-479c-b0c5-ff74603b35a3 Tabeli loomine Excelis: https://support.microsoft.com/et-ee/office/tabeli-loomine-excelis-bf0ce08b-d012-42ec-8ecf-a2259c9faf3f Tabeli vormindamine Excelis: https://support.microsoft.com/et-ee/office/exceli-tabeli-vormindamine-6789619f-c889-495c-99c2-2f971c0e2370 Exceli tabelid ja VBA: https://www.thespreadsheetguru.com/blog/2014/6/20/the-vba-guide-to-listobject-excel-tables Töölehe ümbernimetamine: https://support.microsoft.com/et-ee/office/t%C3%B6%C3%B6lehe-%C3%BCmbernimetamine-3f1f7148-ee83-404d-8ef0-9ff99fbad1f9 […]

Tabelitega toimetamine: https://docs.microsoft.com/en-us/office/vba/api/word.table Tabeli lahtritega toimetamine: https://docs.microsoft.com/en-us/office/vba/api/word.table.cell Failidega toimetamine: https://docs.microsoft.com/en-us/office/vba/word/concepts/working-with-word/working-with-document-objects