uktous
03-19-2012, 08:21 AM
Hi,
I try to use Excel vba to copy a chart in excel to ms paint.
However, it doesn't work.
Could you please amend my macro?
Using the macro below, I can open MS Paint, but can't copy and paste anything to MS paint.
Sub copytomspaint()
Worksheets(1).ChartObjects(1).Select
Selection.Copy
TheEditor = "c:\WINDOWS\system32\mspaint.exe"
TaskId = Shell(TheEditor, 1)
Application.SendKeys "^{V}", True
Application.SendKeys "^{S}", True
End Sub
Thanks
I try to use Excel vba to copy a chart in excel to ms paint.
However, it doesn't work.
Could you please amend my macro?
Using the macro below, I can open MS Paint, but can't copy and paste anything to MS paint.
Sub copytomspaint()
Worksheets(1).ChartObjects(1).Select
Selection.Copy
TheEditor = "c:\WINDOWS\system32\mspaint.exe"
TaskId = Shell(TheEditor, 1)
Application.SendKeys "^{V}", True
Application.SendKeys "^{S}", True
End Sub
Thanks