define vba for only one workbook

**sarelvv** · 08-02-2012, 04:58 AM

Hi (BIG NEWBIE!!)

Wrote a code as per below, but it runs in all active workbooks.

How can I define the code that it only runs for a specific workbook?

Thank You

Sub AutoUpdate()
dTime = Now + TimeValue("00:01:00")
Application.OnTime dTime, "AutoUpdate"
Run "LiveRefresh"
End Sub

Private Function GetValue(path, file, sheet, ref)
path = "H:\ATM_Solutions\Cashing\Gary\Lesley\test"
file = "CIT Dashboard - CIT Unavailable Incidents.xlsx"
sheet = "Page1_1"
ref = "$A$:$n$"
End Function

Sub LiveRefresh()
'
' LiveRefresh Macro
'

'
    ActiveWorkbook.RefreshAll
End Sub

**arlu1201** · 08-02-2012, 05:04 AM

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

**sarelvv** · 08-02-2012, 08:37 AM

Hi

Appologies for not using tags

Do you perhaps have any idea of how I can adjust my code?

Thank You

**arlu1201** · 08-02-2012, 09:09 AM

It will be good if you explain what you are trying to achieve.

**sarelvv** · 08-03-2012, 03:47 AM

I want the code to run on only one workbook and not on the active workbook.

The problem I am currently having is that pivots must update on "Workbook A" every minute, but when I am working on "Workbook B", excel tries to update those pivots as well, causing it to crash.

Please help as I need a "Live Spreadsheet" ASAP for the company.

Thank You

**MrShorty** · 08-03-2012, 09:51 AM

In place of the "activeworkbook" object, using the "thisworkbook" object will cause the code to run on the same workbook containing the code independent of which workbook is active. Is that what you are looking for? If not, you will need to substitute an object referring to the specific workbook in question in place of the "activeworkbook" object.