How do I get an Excel macro to run completely using the keyboard?
 

I created an Excel macro. If I go to Tools - Macro- Select macro - Run, the
macro runs to completion. If I start the macro using the keyboard shortcut
that I defined when I recorded the macro, it executes the first line of the
macro and then stops. It acts as though I was "Stepping" through the macro.
What do I need to do to get the macro to run to completion using the keyboard
shortcut?
--
George

How do I get an Excel macro to run completely using the keyboard?
 

George,

Please post your macro code.

At the beginning of your posted code, *enter the following without the
quote marks*:
["code"]


Your code goes here.


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

How do I get an Excel macro to run completely using the keyboard?
 

George, are you getting an error? if so what is it?

George;421132 Wrote:
I created an Excel macro. If I go to Tools - Macro- Select macro - Run,
the
macro runs to completion. If I start the macro using the keyboard
shortcut
that I defined when I recorded the macro, it executes the first line of
the
macro and then stops. It acts as though I was "Stepping" through the
macro.
What do I need to do to get the macro to run to completion using the
keyboard
shortcut?
--
George


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117182

How do I get an Excel macro to run completely using the keyboa
 

--
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

How do I get an Excel macro to run completely using the keyboa
 

I get no error. The code is simple. It opens three spreadsheets. What
happens, it opens the first spreadsheet and stops. The code follows:

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

--
George


"Simon Lloyd" wrote:


George, are you getting an error? if so what is it?

George;421132 Wrote:
I created an Excel macro. If I go to Tools - Macro- Select macro - Run,
the
macro runs to completion. If I start the macro using the keyboard
shortcut
that I defined when I recorded the macro, it executes the first line of
the
macro and then stops. It acts as though I was "Stepping" through the
macro.
What do I need to do to get the macro to run to completion using the
keyboard
shortcut?
--
George


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117182

How do I get an Excel macro to run completely using the keyboa
 

Drop the shift key from your shortcut key and you'll be set.

George wrote:

I get no error. The code is simple. It opens three spreadsheets. What
happens, it opens the first spreadsheet and stops. The code follows:

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

--
George

"Simon Lloyd" wrote:


George, are you getting an error? if so what is it?

George;421132 Wrote:
I created an Excel macro. If I go to Tools - Macro- Select macro - Run,
the
macro runs to completion. If I start the macro using the keyboard
shortcut
that I defined when I recorded the macro, it executes the first line of
the
macro and then stops. It acts as though I was "Stepping" through the
macro.
What do I need to do to get the macro to run to completion using the
keyboard
shortcut?
--
George


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117182



--

Dave Peterson

How do I get an Excel macro to run completely using the keyboa
 

I think using Ctrl+Shift+ causes problems - try removing Shift from your
shortcut.

Another way you could do your macro:

Sub Daily()
Dim FName()

FName = Array("C:\Documents and Settings\George\My
Documents\WEIGHT\Exercise.xls", _
"C:\Documents and Settings\George\My Documents\WEIGHT\2009dietpl.xls", _
"C:\Documents and Settings\George\My
Documents\MEDICAL\GeorgeBloodPressure.XLS")

Application.ScreenUpdating = False

For na = 0 To 2

Workbooks.Open Filename:=FName(na)

ThisWorkbook.Activate

Next na

Application.ScreenUpdating = True

End Sub
--
jb


"George" wrote:

I get no error. The code is simple. It opens three spreadsheets. What
happens, it opens the first spreadsheet and stops. The code follows:

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

--
George


"Simon Lloyd" wrote:


George, are you getting an error? if so what is it?

George;421132 Wrote:
I created an Excel macro. If I go to Tools - Macro- Select macro - Run,
the
macro runs to completion. If I start the macro using the keyboard
shortcut
that I defined when I recorded the macro, it executes the first line of
the
macro and then stops. It acts as though I was "Stepping" through the
macro.
What do I need to do to get the macro to run to completion using the
keyboard
shortcut?
--
George


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117182

How do I get an Excel macro to run completely using the keyboa
 

The "shift" was the problem. Thanks for the help.
--
George


"john" wrote:

I think using Ctrl+Shift+ causes problems - try removing Shift from your
shortcut.

Another way you could do your macro:

Sub Daily()
Dim FName()

FName = Array("C:\Documents and Settings\George\My
Documents\WEIGHT\Exercise.xls", _
"C:\Documents and Settings\George\My Documents\WEIGHT\2009dietpl.xls", _
"C:\Documents and Settings\George\My
Documents\MEDICAL\GeorgeBloodPressure.XLS")

Application.ScreenUpdating = False

For na = 0 To 2

Workbooks.Open Filename:=FName(na)

ThisWorkbook.Activate

Next na

Application.ScreenUpdating = True

End Sub
--
jb


"George" wrote:

I get no error. The code is simple. It opens three spreadsheets. What
happens, it opens the first spreadsheet and stops. The code follows:

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

--
George


"Simon Lloyd" wrote:


George, are you getting an error? if so what is it?

George;421132 Wrote:
I created an Excel macro. If I go to Tools - Macro- Select macro - Run,
the
macro runs to completion. If I start the macro using the keyboard
shortcut
that I defined when I recorded the macro, it executes the first line of
the
macro and then stops. It acts as though I was "Stepping" through the
macro.
What do I need to do to get the macro to run to completion using the
keyboard
shortcut?
--
George


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117182