instanceoftime
Board Regular
- Joined
- Mar 23, 2011
- Messages
- 102
Because of what I already read on here: I open excel then open then open my workbooks through excel.
I used the following code found here for the macro (assigned to ctnrl-k in personal workbook) but it seems to run twice on the first workbook and not at all on the second. (one sheet per book... don't know why it is running twice.
I used the following code found here for the macro (assigned to ctnrl-k in personal workbook) but it seems to run twice on the first workbook and not at all on the second. (one sheet per book... don't know why it is running twice.
VBA Code:
Sub auctions()
' auctions Macro
' Keyboard Shortcut: Ctrl+k
Dim wbkX As Workbook
For Each wbkX In Application.Workbooks
'macro code here'
Next
End Sub