I have this situation - pressing the button opens excel and the scale is automatically 100%, and I want it to be different.
I found the code here, but I can't use it. Help me please.

 ExcelApp.PageSetup.Zoom := False; ExcelApp.PageSetup.FitToPagesWide := 1; ExcelApp.PageSetup.FitToPagesTall := 1; ExcelApp.PageSetup.Zoom := 70;
  • PageSetup is a scale for printing. Look for another property Zoom - nick_n_a

1 answer 1

 ExcelApp.ActiveWindow.Zoom:=85;

everything worked out))