{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист3","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["G:\\Моя\\Стереть\\a7_H8B3_5xx.xlsx","Путь к файлу"]

{"sheet":"Лист3","index":1,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Workbooks(\"Обработка.xlsm\").Activate"]
["Range(Sheets(\"склад\").Cells(2, 2), Sheets(\"склад\").Cells(Sheets(\"склад\").Cells(Rows.Count, 1).End(xlUp).Row, 11)).ClearContents 'очищаем Диапазон для последующих записей на листе\"остатки\""]
[" Application.ScreenUpdating = False  ' отключаем обновление экрана"]
[]
["'   указываем путь к файлу"]
["Dim sPath As String"]
["sPath = ThisWorkbook.Path + \"\\\""]
["Отчет.txtbPath = sPath"]
["Workbooks(\"остатки.xls\").Activate"]
["  'Копирование данных с файла *остатки.xls* с 9 строки , 2-го столбца и до последней заполненной ячейке"]
["Range(Sheets(\"TDSheet\").Cells(10, 2), Sheets(\"TDSheet\").Cells(Sheets(\"TDSheet\").Cells(Rows.Count, 2).End(xlUp).Row, 12)).Copy Destination:=Workbooks(\"Обработка.xlsm\").Sheets(\"склад\").Range(\"A2\")"]
["       'Активируем рабочую книгу"]
["         Workbooks(\"Обработка.xlsm\").Activate"]
["      'Вставляем данные на лист1"]
["'        Sheets(\"склад\").Cells(Sheets(\"склад\").Cells(Rows.Count, 1).End(xlUp).Row + 1, 1).PasteSpecial Paste:=xlPasteValues"]
["        Workbooks(\"остатки.xls\").Save 'Сохраняем книгу"]
["        Workbooks(\"остатки.xls\").Close 'Закрываем книгу"]
["    'сохраняем текущую книгу"]
["     ActiveWorkbook.Save"]
["   Application.ScreenUpdating = True 'Включаем обновление экрана"]
[" MsgBox \" Данные  успешно скопированы на лист\", 64, \"Подтверждение копирования диапазона\""]
[" "]

{"sheet":"Лист2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}