Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
We have entered the attached code into a workbook (Testing Stores.xls) but when we run the code it does not perform the task below. Windows("Store Response List " & stDate).Activate which is meant to activate workbook Store Response List (date).xls so we can update the file. The stDate is the date which is provided from a cell found in workbook (Testing Stores.xls). For some reason when it comes to this code it jumps back to the begining and does not activate the required workbook. I beleive it has to do with the stDate which I dont know how to get araound. Any help would be greatly appreciated. Thanks Noemi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to refenence ranges on a closed workbook | Excel Discussion (Misc queries) | |||
How do I protect a worksheet from being opened inside a workbook | Excel Discussion (Misc queries) | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Can macro/userform run depending on HOW workbook is opened? | Excel Discussion (Misc queries) |