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!

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

exporting from acess to excel with vba, saves multiple workbooks?

Status
Not open for further replies.

wh0wants2know

IS-IT--Management
Mar 23, 2005
10
US
I'm trying to create an excel spreadsheet from my access application and when I try to use the save method, it only saves one .xls file, called test.xls. however, when I open test.xls, the correct spreadsheet comes up and a second one opens that is similar to the first and called "book2.xls" and it just sits there, and then when I close book2.xls, it asks me if i want to save it (i haven't changed anything in this file) but then when i close test.xls, it just closes and doesn't prompt me to save it unless i actually make any changes to it. where the hell is this other file coming from? I only want one file to open.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top