V
Victor and TJ Friedmann
I associate this macro with a shape in ppt2007 presentation:
Sub servingsexcel()
Shell "C:\Program Files\Programs\Microsoft Office\Office\EXCEL.EXE" & " " &
"C
ocuments and Settings\My Documents\cookbook\excel servings\marsala.xls",
vbNormalFocus
With Application
.Width = 601.5
.Height = 498.2
End With
End Sub
The idea is to open the escel window as the active window with a particular
size. Closing the excel window will return the user to the ppt presentatio.
What is wrong with this code?
Thanks.
Vic
Sub servingsexcel()
Shell "C:\Program Files\Programs\Microsoft Office\Office\EXCEL.EXE" & " " &
"C
ocuments and Settings\My Documents\cookbook\excel servings\marsala.xls",vbNormalFocus
With Application
.Width = 601.5
.Height = 498.2
End With
End Sub
The idea is to open the escel window as the active window with a particular
size. Closing the excel window will return the user to the ppt presentatio.
What is wrong with this code?
Thanks.
Vic