A voir également:
- Vba : copier modepoint excel07 word00
- Mkdir vba ✓ - Forum VB / VBA
- Vba récupérer valeur cellule ✓ - Forum VB / VBA
- Excel compter cellule couleur sans vba - Guide
- Vba range avec variable ✓ - Forum VB / VBA
- Vba dépassement de capacité ✓ - Forum Excel
1 réponse
encore moi, désolée je recommence: voici mon code exact :
xlApp.DisplayAlerts = False
xlApp.Visible = True
xlApp.AskToUpdateLinks = False
xlApp.Workbooks.Open FileName:="..xls", updatelinks:=0, ReadOnly:=True
xlApp.ActiveWindow.WindowState = xlNormal
xlApp.ActiveWindow.Width = 530
xlApp.ActiveWindow.Height = 200
xlApp.Workbooks(1).Sheets(page1(2 * i - 1)).Select
xlApp.ActiveChart.ChartArea.Select
xlApp.ActiveChart.CopyPicture Appearance:=xlPrinter, Size:=xlPrinter, Format:=xlBitmap
Options.ReplaceSelection = True
ActiveDocument.InlineShapes(i).Select
Selection.Paste
xlApp.ActiveWindow.Close
xlApp.Quit
xlApp.DisplayAlerts = False
xlApp.Visible = True
xlApp.AskToUpdateLinks = False
xlApp.Workbooks.Open FileName:="..xls", updatelinks:=0, ReadOnly:=True
xlApp.ActiveWindow.WindowState = xlNormal
xlApp.ActiveWindow.Width = 530
xlApp.ActiveWindow.Height = 200
xlApp.Workbooks(1).Sheets(page1(2 * i - 1)).Select
xlApp.ActiveChart.ChartArea.Select
xlApp.ActiveChart.CopyPicture Appearance:=xlPrinter, Size:=xlPrinter, Format:=xlBitmap
Options.ReplaceSelection = True
ActiveDocument.InlineShapes(i).Select
Selection.Paste
xlApp.ActiveWindow.Close
xlApp.Quit