Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Script for Excel

Status
Not open for further replies.
mtepfer

mtepfer

IS-IT--Management
Apr 21, 2003
55
US
I would like a script that when the person opens the spreadsheet they are propmted to choose a source file from a directory location.

Once selected the files in this folder are then copied to another static folder.
 
Sort by date Sort by votes
there is an on open sub for excel, i.e. a sub which is called when the workbook opens. there is also a FileDialogue method which launches an excel folder chooser which will be of use....perhaps as this is in excel the vba forum would be the best place for this post
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Brianfree
  • Locked
  • Question
Excel Rows to Column 1
Replies
2
Views
558
Brianfree
Brianfree
bdwilcox
  • Locked
  • Question
Script seeing input variable value as blank but sees hard-coded value 4
Replies
6
Views
984
bdwilcox
bdwilcox
wchull
  • Locked
  • Question
How do I resolve this permissions error in my script?
Replies
0
Views
444
wchull
wchull
Katto
  • Locked
  • Question
Excel VBA functions in VBScript
Replies
4
Views
578
dhookom
dhookom
jahelka
  • Locked
  • Question
script editing - base64 for files in folder
Replies
1
Views
323
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top