0

Having some trouble streamlining the database creation process in Access. As it stands, I have a bunch of 'raw' .csv files, and a macro to convert them. The macro prompts the user to select file(s) to convert, then converts and saves them. The macro also exists as a function that takes an object consisting of one or more files as an argument, converts and saves them, as well as returns the filename(s) of the converted files. I then import these converted files to Access.

I'm trying to set things up so one button click on a form in Access will convert the raw files, then import them into Access.

I've followed the code here, and can get the stand-alone macro to run, but am struggling to call the function (which takes an argument) to run.

Any help is appreciated. If more information is required, please let me know.

YowE3K
  • 23,852
  • 7
  • 26
  • 40
mitchpehora
  • 9
  • 3
  • 1
    It's best to include your actual code in your question, and show how you've tried to call it and what error(s) you got when you tried that. – Tim Williams Jun 19 '17 at 21:09
  • @mitchpehora Simply give the arguments separated with a colon: https://msdn.microsoft.com/VBA/Excel-VBA/articles/application-run-method-excel – Ibo Jun 19 '17 at 21:10
  • @TimWilliams please see my update :) https://stackoverflow.com/questions/44661823/how-do-i-convert-excel-files-then-import-to-access-in-one-step – mitchpehora Jun 20 '17 at 20:59

0 Answers0