Active Workbook

[Aurum]

I use a workbook that processes real time stock prices with a VBA timer and sends out an alert when a price goes into a desired range. But this requires this workbook to be always the active workbook, and when I opened another workbook the alert failed. I tried adding something like ThisWorkbook.Sheet1 to all the Ranges in the code, but it didn't work.

Could anyone please tell me how i can make reference to the specific workbook that runs in the background, so that another opened workbook won't cause confusion? Thanks.

 

[SamTYler]

VBScript. Run it when Windows starts. Take this question over to

http://www.vbaexpress.com/forum/

 

[Richard Schollar]

Hi

What nature is the alert? ie is it an email, a popup or what> Also, please could you pot your code so we can see what it is doing.

 

[Aurum]

Thanks for your replies. Actually I have solved this problem on my own but at that time I could not post a reply here - seems there were some problems with the database here.

I need to read a range of prices with for loop - in the form of Range("Price").Offset(i,0) , where Price, a cell I name, is the column header of prices. I tried ThisWorkbook.Sheet1.Range("Price").Offset(i,0) but it didn't recognise the range Price, instead I tried ThisWorkbook.Sheets("Realtime prices").Range("Price").Offset(i,0)and it works. Turns out that it recognises only the sheet name but not the code.