Perhaps... instead of trying to cause a pause, use a dialog box (design form) in the middle of the logic that would take your input and pass it back to the program which would continue after pressing OK.
Columns A thru D are used to import data from a database. (PGSales2005.mdb) Although there are many columns available in the database, I only need four - ("Paid", "Customer Name", "ZIP" & "Item") so I use the "Import External Data" menu and go through the necessary dialogue to specify the columns I need.
The database is indicated in cell B3 (I typed it in, although it would be nice to have the field activate a navigation so I can browse to the DB file.)
The table name is indicated in cell B4. (Again, I typed it in. It would be very helpful if this cell was actually a drop down list that showed tables available in the DB called out in cell B3.)
I'd like to build a macro that automates the dialogue necessary to bring in the proper DB/Table/Columns. Any macro I build has absolute reference to a given DB and table. I'd like the macro to reference the DB and table called out in cells B3 & B4 respectively, so it's a relative reference instead of absolute.
I hope this makes sense. If anyone has the gumption to give me a hand with this, I'd appreciate it immensely!