Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mac issue with macro recording user login & date (run time error '
Hi,
Based on feedback from a post I entered early this week, I used the code below (entered in the "General Declarations" section of the "This Workbook" sheet) to record the user ID and date of when a spreadsheet is opened. The issue is the person using this spreadsheet has a Mac and said they are getting the following error when opening the spreadsheet: "run time error '5'". He said that the error apparently is stopping the userid from being recorded (the date is populating OK). Any help on how to get around this is appreciated! - Robert Private Sub Workbook_Open() Dim rng As Range Set rng = Sheets("Proj.Mngt.").Range("I45").End(xlUp).Offset (1, 0) rng.Value = Now() rng.Offset(0, 1) = Environ("UserName") End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mac issue with macro recording user login & date (run time error '
Environ method not available on Macs. Would Application.UserName in
place of Environ("UserName") do? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mac issue with macro recording user login & date (run time err
Thanks!! One more question -- how do I change the 'Application.Username'
value? Thanks, Robert " wrote: Environ method not available on Macs. Would Application.UserName in place of Environ("UserName") do? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mac issue with macro recording user login & date (run time err
Did you try setting the property?
Application.Username = "whatever" In article , "Linking to specific cells in pivot table" crosoft.com wrote: Thanks!! One more question -- how do I change the 'Application.Username' value? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mac issue with macro recording user login & date (run time err
Robert,
Application.Username is Read/Write. However, it is an Office wide property, so Word, Access etc will pick up the change. NickHK "Linking to specific cells in pivot table" crosoft.com wrote in message ... Thanks!! One more question -- how do I change the 'Application.Username' value? Thanks, Robert " wrote: Environ method not available on Macs. Would Application.UserName in place of Environ("UserName") do? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mac issue with macro recording user login & date (run time err
If you are looking to change it on individual computers, look in Tools,
Options and I believe General tab. "JE McGimpsey" wrote: Did you try setting the property? Application.Username = "whatever" In article , "Linking to specific cells in pivot table" crosoft.com wrote: Thanks!! One more question -- how do I change the 'Application.Username' value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Recording Macro | Excel Discussion (Misc queries) | |||
First Time Macro User--Stop Recording Toolbar | Excel Discussion (Misc queries) | |||
Macro Issue - Run time error 1004 | Excel Discussion (Misc queries) | |||
Macro to record user name and date/time | Excel Discussion (Misc queries) | |||
Recording user and date of when a file is opened | Excel Programming |