Transfer Spread Sheet

  • Thread starter Thread starter Bryan
  • Start date Start date
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
 
Back
Top