Transfer Spread Sheet

B

Bryan

I have a transfer spreadsheet macro that goes out and gets
an excel file and places the data in my table
named "ApplicantImportTbl". This works fine but
occasionally we need the flexibility to look in other
folders when we import and at times the names of the files
change. Right now the excel file has to have a certain
name and be in a certain folder. Is there a way to open
the window to browse for a different file with a different
name? I plan on having two buttons, the one I have now
and a browse button. Thanks. I know some very basic VBA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Synchronization problems while moving folders to new email 1
Mail Merge Directory Conditional Page Break 0
Grouping Names in Mail Merge 0
Excel - Wich Function should I use? 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Embed the same Excel multiple times 0
Automation of scanned file storage based on content 0
VBA - exporting serial letters to single documents 0

Top