Attach File Macro

  • Thread starter Thread starter Benji
  • Start date Start date
B

Benji

I have a network with shared files in say S:\work
All the files are in another folder under s:\work\final\
Under the Final directory are all our files the first 4 digits represent the
first folder under \final\
A second set of 4 digits represent a subdirectory under the first 4 digit
directory. example s:\work\final\0000\0001 and so on and so on
This only goes 2 directories deep so a total of 8 digits.

I would like to create a macro that prompts the user to enter an 8 digit
file number to open a directory, inwhich they would like to attach a file.
Can anyone help with this. I dont know where to start. I am not good with
VBA. Basically I would just like to an another menu idem called (Company
Attach Button) and the prompt would be displayed.

Thanks abunch
 
Hi Benji,

for adding a commandbar please see:
http://www.outlookcode.com/d/tips/commandbarfun.htm

Splitting 8 digits:
first4=left$(yourDigits,4):last4=right$(yourDigits,4)

For a file open dialog you could use the Common Dialog Control, but I´ve
read from people, that this sometimes doesn´t work in VBA. Anyway, if
you like to deploy your solution to several users then the best way
would be to build a COM Add-In, e.g. with VB - so you could use the
Common Dialog Control definitely.
 
Back
Top