Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Sticky filepaths at Assign Macro step

When I assign a macro to a tool, the filepath appears to be relative,
i.e. '[filename]'![macroname].

When I move the file or e-mail it, it will read '[driveletter]\
[foldername]\[filename]'![macroname].

Is there code to make the filepath remain relative, as in the first
example above?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 420
Default Sticky filepaths at Assign Macro step

I don't think so.

You could write a macro that would reassign the macros, but before you do that,
check your other post. I think that solution is easier.

On 02/09/2011 12:48, Hunter O'Connell wrote:
When I assign a macro to a tool, the filepath appears to be relative,
i.e. '[filename]'![macroname].

When I move the file or e-mail it, it will read '[driveletter]\
[foldername]\[filename]'![macroname].

Is there code to make the filepath remain relative, as in the first
example above?


--
Dave Peterson
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
Relative filepaths? Peter Excel Discussion (Misc queries) 6 September 1st 08 10:04 PM
run macro step by step. excel 2003 PBM[_3_] Excel Programming 2 November 19th 05 02:19 PM
Sticky sorting/macro/VLOOKUP problem Ron M. Excel Discussion (Misc queries) 1 October 20th 05 07:56 PM
running macro step by step different from normal run?? Rinze Smit Excel Programming 10 July 26th 05 03:35 PM
I need step by step instructions to create a macro for 10 imbedde. diana Excel Worksheet Functions 3 January 31st 05 01:56 AM


All times are GMT +1. The time now is 07:05 PM.

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

About Us

"It's about Microsoft Excel"