Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
What commads can I use to test a value in a given cell on a worksheet?
I want to open a secondary worksheet based on the number in a cell. -- BobMayers |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
Hi,
Try something like this Sub stantial() If Range("A1").Value = 1 Then Path = "C:\" fname = "Testbook.xls" Pass = "mypass" Set mybook = Workbooks.Open(Path & fname, Password:=Pass) End If End Sub Mike "BobMayers" wrote: What commads can I use to test a value in a given cell on a worksheet? I want to open a secondary worksheet based on the number in a cell. -- BobMayers |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
Thank you Mike - - but I am not real familier VB I am using 4.0 macro language
have been trying stuff like this =SET.NAME("MAG1",1) =SET.NAME("MAG2",2) =SET.NAME("MAG3",3) =IF(ABS("RC[11]")=MAG3,ACTIVATE("M3")) =IF(ABS("RC[11]")=MAG2,ACTIVATE("M2")) =IF(ABS("RC[11]")=MAG1,ACTIVATE("M1")) -- BobMayers "Mike H" wrote: Hi, Try something like this Sub stantial() If Range("A1").Value = 1 Then Path = "C:\" fname = "Testbook.xls" Pass = "mypass" Set mybook = Workbooks.Open(Path & fname, Password:=Pass) End If End Sub Mike "BobMayers" wrote: What commads can I use to test a value in a given cell on a worksheet? I want to open a secondary worksheet based on the number in a cell. -- BobMayers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |