--
George
"stanleydgromjr" wrote:
George,
Please post your macro code.
At the beginning of your posted code, *enter the following without the
quote marks*:
["code"]
Sub Daily()
'
' Daily Macro
' Macro recorded 7/1/2009 by George Clovis
'
' Keyboard Shortcut: Ctrl+Shift+D
'
ChDir "C:\Documents and Settings\George\My Documents\WEIGHT"
Workbooks.Open Filename:= _
"C:\Documents and Settings\George\My Documents\WEIGHT\Exercise.xls"
Workbooks.Open Filename:= _
"C:\Documents and Settings\George\My Documents\WEIGHT\2009dietpl.xls"
ChDir "C:\Documents and Settings\George\My Documents\MEDICAL"
Workbooks.Open Filename:= _
"C:\Documents and Settings\George\My
Documents\MEDICAL\GeorgeBloodPressure.XLS"
End Sub
At the end of your posted code, *enter the following without the quote
marks*:
["/code"]
Have a great day,
Stan
--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117182