I am very new to VBA and am trying to achieve the following:

Starting in Access:
Open up a new book in Excel
Prompts the user to browse for a .txt file on their system
File is opened in Excel
Sort the data to columns
(based on various parameters) export the data back into an Access table.
Excel Document Closes without saving
Access Document Saves.

I started the process in excel and managed to get the first 5 steps sorted. (With lots of help from the internet and member on here! Thanks)

However, i have copied the code to a module in Access and now the "Application.GetOpenFileName" line fails, is it because the Application has changed? Anybody know how i can achieve what i want to? Thanks

Please Login or Register  to view this content.
Any help would be greatly appreciated!