Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use Macro throughout Department
How about putting the macro in that same workbook.
Put a button (from the forms toolbar) on an instruction worksheet that has your macro assigned to it. SharonInGa wrote: The Excel spreadsheet named "Investment Reviews" is email to several people. Those people need to be able to click a command button which saves that spreadsheet to their C drive and manipulates the information using the VBA module "Sub ProcessPortfolioHoldings() Where do I need to place the macros so that everyone in the department can run this report independently on their PCs? Why is this command not running the second macro? ActiveWorkbook.RunAutoMacros xlRunPortfolioSetup Sub ProcessPortfolioHoldings() Workbooks.Open Filename:="C:\Investment Review.csv" ActiveWorkbook.SaveAs Filename:="C:\PortfolioHoldings.xls", FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False ''Workbooks.Open "PortfolioHoldings.XLS" ActiveWorkbook.RunAutoMacros xlRunPortfolioSetup -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar chart by division, department, region date | Charts and Charting in Excel | |||
add number of days within a department for a given time period | Excel Worksheet Functions | |||
Automating Department Payroll | Excel Discussion (Misc queries) | |||
Calculating Working Days - Department of Pathology | Excel Discussion (Misc queries) |