| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Exported data automatically from Access database
Thanks for all your help, I got the issue resolved.
"joel" wrote: Remove the line MyQuery = "AC_WC_DEMOG_CRSTAB Query" I added this to test with one of my databases. You just neeed the line MyQuery = "Excel Exportb" "microsoft" wrote: Hi This line of code is giving an error "LastRow = .Range("A" & 65536).End(xlUp).Row" Error - Run time error 1004 Application defined or object defined error Hope to hear from you soon. Thanks again "microsoft" wrote: Hi I created an Access database which exports data to Excel. I would like assistance in creating the required code which would allow me to sum some selected columns automatically after the data is exported (kindly note that I do not want any additional columns created to capture the total figure). Note that the rows from the database may vary hence the excel rows will also vary. Code to determine the row count would need to be included. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exported from Access - text has a character before it | Excel Discussion (Misc queries) | |||
| Some columns exported from Access do not sum | Excel Discussion (Misc queries) | |||
| Sending Data to Access Database | Excel Discussion (Misc queries) | |||
| Conditional Formatting not applied to data exported from Access | Excel Worksheet Functions | |||
| excel to get data from an access database | Excel Discussion (Misc queries) | |||
![microsoft[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
