Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 1st, 2007, 04:15 PM
Friend of Wrox
 
Join Date: May 2006
Location: Jonesboro, AR, USA.
Posts: 144
Thanks: 0
Thanked 0 Times in 0 Posts
Default TransferSpreadsheet

Hi,
I'm trying to use "transferspreadsheet" to bring in an excel spreadsheet and insert it into a table. It works, but sometimes the spreadsheet may have multiple sheets.
Is there a way to not import all the sheets in a spread sheet? It would be great if I could set up a prompt to ask which sheet to import.

Thanks for any help,

David

  #2 (permalink)  
Old March 16th, 2007, 09:07 AM
Registered User
 
Join Date: Mar 2007
Location: Dallas, TX, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Not exactly sure what you're getting at - are you bringing in an existing Excel sheet or a new sheet? On the server save an Excel workbook with one sheet in it on as a template. In your code do a FILECOPY to put the wkbk on a user's computer, and the TRANSFERSPREADSHEET. If you are trying to open up a new Excel workbook for some reason, it will show up with three sheets unless you change the setting in Excel's Options - General tab.

Jeff Stubing
  #3 (permalink)  
Old March 16th, 2007, 02:45 PM
Friend of Wrox
 
Join Date: May 2006
Location: Jonesboro, AR, USA.
Posts: 144
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, I've already found a way around this. What I was asking about was the TransferSpreadsheet method.
I was trying to find a way to import an excel workbook which had 5 or 6 different sheets. It was only bringing in the first sheet when I tried to import it and I wanted all the sheets.


Similar Threads
Thread Thread Starter Forum Replies Last Post
TransferSpreadsheet darkhalf Access VBA 2 February 15th, 2008 04:23 PM
TransferSpreadsheet kaleb0521 Access VBA 1 August 28th, 2006 12:59 PM
transferspreadsheet command Vince_421 Access VBA 2 May 3rd, 2006 11:29 AM
transferspreadsheet ajmil11 Access 3 January 19th, 2006 03:42 AM
TransferSpreadsheet ajmil11 Access VBA 1 January 19th, 2006 02:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.