| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use the if statement for Macro coding?
IF( 'E:\file\[1.xls]Sheet1'!$A$1 = 1 THEN
{ / Processing following code Workbooks.Open Filename:="E:\file\1.xls", UpdateLinks:=3 Workbooks("1.xls").Close savechanges:=True } else / Processing nothing Does anyone have any suggestions on how to code the if statement for Excel Macro? Thank in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to confirm the open dialogue box by using macro coding? | Excel Worksheet Functions | |||
| How to close a excel file using Macro coding? | Excel Discussion (Misc queries) | |||
| if then statement color coding (or another function???) | Excel Worksheet Functions | |||
| Hidding Macro names and coding | Excel Discussion (Misc queries) | |||
| soft-coding lines in a macro | Excel Discussion (Misc queries) | |||
Threaded Mode
