View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeremy R. Jeremy R. is offline
external usenet poster
 
Posts: 5
Default import package from

I have a certain package that I import from the same location on multiple
files each week.

I recorded a macro to import the file but the macro does not automatically
import the file from the location and filename I used when recording the
macro. The macro stops when it gets to the object packager box.

I would like it to automatically select the location and name of the file
since it never changes and then update the form.

What VB code could I use to do this?
Thanks in advance.