Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASSISTANT FILENAME
Hello NG,
Assistant.Filename = "ROCKY.acs" works well in my PC but when I run my macro to another PC I got an error saying something about the assistant filename. When I do a filesearch on that another PC, it turns out that the file has different file extension "acg". So, I thought of revising my code to CurrentUser = Environ("UserName") If CurrentUser = "MyName" Then Assistant.Filename = "ROCKY.acs" Else Assistant.Filename = "ROCKY.acg" End If Still, the macro runs well in my PC but never on that another PC. I never thought that there will be this kind of conflict because both PC have Windows XP and Office XP installed. Please help ! Jon-jon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASSISTANT FILENAME
Never mind. I figure it out. Assistant is not fully loaded on the other
PC. Thanks anyway. "JON JON" wrote in message ... Hello NG, Assistant.Filename = "ROCKY.acs" works well in my PC but when I run my macro to another PC I got an error saying something about the assistant filename. When I do a filesearch on that another PC, it turns out that the file has different file extension "acg". So, I thought of revising my code to CurrentUser = Environ("UserName") If CurrentUser = "MyName" Then Assistant.Filename = "ROCKY.acs" Else Assistant.Filename = "ROCKY.acg" End If Still, the macro runs well in my PC but never on that another PC. I never thought that there will be this kind of conflict because both PC have Windows XP and Office XP installed. Please help ! Jon-jon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office Assistant | Excel Discussion (Misc queries) | |||
How do you get an Assistant? | New Users to Excel | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
Avery Assistant add-in | Excel Discussion (Misc queries) | |||
set filename to <filename-date on open | Excel Worksheet Functions |