Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Assistance
Hello All:
I have an Access application that needs to import a "sheet" from a workbook. In this work book, I have "Sheet1", "Sheet2", "Sheet3","Sheet4". In the Access app, I use an input box to have the user enter the appropriate sheet they want to import into Access. For instance, the user types in "Sheet3". In code (Access VBA) how do I import this sheet (Sheet3). The Access code is variable here is the input box result DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, variable, strFileName, True The intent is to import ONLY that sheet. The code above only imports Sheet1, not the intended one. Oh BTW, I have an open dialog box to allow the user to select the appropriate Excel file. Does this make sense ?? Thanks in AAdvance ! G Man |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need assistance | Excel Worksheet Functions | |||
Assistance please | Excel Worksheet Functions | |||
Excel Programming - Formula Assistance | Excel Discussion (Misc queries) | |||
programming assistance | Excel Discussion (Misc queries) | |||
I Need VBA Assistance for EOF | Excel Discussion (Misc queries) |