Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Elkins Park, Pennsylvania, USA
    Posts
    325
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default VBA Import/Export Locations (Word XP)

    Hi again. Can someone help me with a minor annoyance? I notice that, when I want to export or import code modules from or to a document or template, the default location for my workstation always seems to be a network share. (In my case, it's my "personal network storage" share.) I'd like to know if there is a location that one can specify for this. I can't see any overt setting that controls this, but if it takes a reg-tweak, so be it.

    It's a real hassle to keep browsing to my project's directory to save or obtain *.bas or *.cls files.
    <font face="Comic Sans MS">That's what you do in a herd; you look out for each other!</font face=comic> - Mike

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default VBA Import/Export Locations (Word XP)

    I don't know the answer, but you can by drag and drop modules from the Project Explorer to a Windows Explorer window and vice versa. If the Visual Basic Editor is full screen, drag the module to the taskbar button of a Windows Explorer window and wait until the window itself pops up, then drag there.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default VBA Import/Export Locations (Word XP)

    You can also do this with macro's. Attached is a zipped BAS module with example Sub's for exporting and importing VBA files. That can get you started.
    Attached Files Attached Files

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Default VBA Import/Export Locations (Word XP)

    My workaround is to right-click the desired destination in Windows Explorer and choose Create Shortcut. Select and cut the shotcut, and then paste it in the undesired location offered by the VBE. Still an extra double-click, but...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •