Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

open export window

Status
Not open for further replies.
tinoco

tinoco

IS-IT--Management
Feb 16, 2005
49
ES
Hi!
Is it possible to open from vba code the same window that the one we open when we click with the right buttom on the table name and then export?
thanks
 
Sort by date Sort by votes
[tt]DoCmd.TransferText()[/tt] or [tt]DoCmd.TransferSpreadsheet()[/tt]?

Funny thing about being unemployed, weekends don't mean quite so much, just means you get to hang out with your working friends. Primus
 
Upvote 0 Downvote
[tt]DoCmd.RunCommand acCmdExport[/tt]

Funny thing about being unemployed, weekends don't mean quite so much, just means you get to hang out with your working friends. Primus
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
462
Moss100
Moss100
breezett93
  • Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open 1
Replies
14
Views
951
dhookom
dhookom
Moss100
  • Locked
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
596
Moss100
Moss100
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
501
TheAceMan1
TheAceMan1
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
328
combo
combo

Part and Inventory Search

Sponsor

Back
Top