 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / October 2005Transfer Excel Worksheet
When transfering data in from excel is there a way to refer to a specific sheet and not a specific range. The excel file I want to import from has several worksheets and I do not want to have the user set a named range as the range changes. I just want to be able to say the file name and worksheet name. The stCombine below is the file path with subdirectories. DoCmd.TransferSpreadsheet acImport, 8, "Ssaintv", stCombine, True, "" Thank you for any information... The Range argument can refer to a sheet. Put the sheet name you want to import where I have "SheetName" DoCmd.TransferSpreadsheet acImport, 8, "Ssaintv", stCombine, True, "SheetName" > When transfering data in from excel is there a way to refer to a specific > sheet and not a specific range. The excel file I want to import from has [quoted text clipped - 7 lines] > > Thank you for any information... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.