Capture a value from a wizard form

  • Thread starter Thread starter DSScxe via AccessMonster.com
  • Start date Start date
D

DSScxe via AccessMonster.com

Hi, I am trying to programmatically capture the Table name value (that a user
would designate) from the Linked Spreadsheet Wizard. I have a project that
(via code) makes use of this built-in wizard to link to external
spreadsheets; however, I cant seem to find the object that would give me
access to (in VBA code)the Wizard's input box where a table name is specified.
Is it even possible? Any help would be greatly appreciated.
 
I don't know the answer to the question as you state it, or whether it's
even possible, but one way round it if nobody comes up with anything better:

Before you kick off the wizard, take a snapshot of the current list of
tables, and another when the wizard completes. Compare those and you should
be able to pick out which the new one is.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data entry for a table from a form 1
Access Create option group without using wizard? 2
capturing the Sub or Function name in the error message 8
Creating A Wizard Type Form 3
Can't create a report from my query in Access 1
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Data Entry VBA 4

Back
Top