G
Guest
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
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