| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro target to MsWord
Pls correct me on this formula: something wrong on opening file.
Sub openreport() myPWD = Application.InputBox("Password Protected! Please Enter Authorized Password to Continue!") If myPWD = "ems5657sifooc1" Then Application "C:\EMS-Senior1\Individual Report Class1.doc" Else MsgBox "Wrong Password! Bye!" End If For Each w In Workbooks w.Save Next Application.quit End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Editing a simple macro | Excel Worksheet Functions | |||
| Can T Get Macro To Run! | New Users to Excel | |||
| macro with F9 | Excel Discussion (Misc queries) | |||
| Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
