Search results

Thank you Galaxiom. That is good news, and how can i execute a hidden session of Excel from VBA Access? I will try to develop the IIF function in Access to correct data directly from the text files. About the other issue, is it possible to select a folder and execute a "while" loop for...

I am using Excel mainly to execute linear interpolations to correct data from the text files. The interpolations are based in multiples if functions, extrating values from a table in excel to correct a single value (the imported text value). Can Access perform the "if" functions as well as...

Hello everyone! I am new to the forum and a begginer in VB Access. Is it possible to create a macro in Access to open a folderpicker dialog box, import all the .txt files to an Excel file to perform calculations and next to import the data to the Access database? So far I have acomplished the...