Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Office Assistant clanbull Excel Discussion (Misc queries) 2 September 16th 08 08:48 AM
How do you get an Assistant? Frogger New Users to Excel 2 September 8th 07 12:05 PM
Cell("filename") doesn't update to new filename when do save as. Louis Excel Worksheet Functions 2 March 22nd 07 07:27 PM
Avery Assistant add-in br549 Excel Discussion (Misc queries) 3 February 23rd 07 03:14 PM
set filename to <filename-date on open bob engler Excel Worksheet Functions 2 July 13th 06 05:11 AM


All times are GMT +1. The time now is 04:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"