| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form creates new workbook and pulls data
Is my logic correct? I have a macro running in a workbook that asks the user for the account number. On Click, I want the macro to create and save a new workbook with the account number as file name, then excecute a query to pull data from a database. The macro ran fine when taking the account number and pasting it on a new sheet in the same workbook. Its failing now that I am trying to get the data onto a new xls. Am I trying something not possible? -- luke99s ------------------------------------------------------------------------ luke99s's Profile: http://www.excelforum.com/member.php...o&userid=28016 View this thread: http://www.excelforum.com/showthread...hreadid=475224 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| workbook creates a backup evertime I save it. how to remove? | Excel Worksheet Functions | |||
| Combo Box Pulls data | Excel Discussion (Misc queries) | |||
| How under the insertion pulls in the excel form tabulates the fram | New Users to Excel | |||
| Excel 2k3: Workbook on network drive, when save creates new file | Excel Discussion (Misc queries) | |||
| workbook creates desktop shortcut...HELP | Excel Programming | |||
Threaded Mode
