-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Data from Access to Excel
- Thread starter Brawn
- Start date
Not much detail to go on 
Here is some code that should point you in the right direction.
Shout back if you need more specific help.
Edit
I forgot to add that you will need to make a reference to do this.
in any module go Tools>Reference... and scroll down select the "Microsoft Excel Object Libary"
HTH
Peter
Here is some code that should point you in the right direction.
Shout back if you need more specific help.
Code:
Sub XlExport()
Dim appXL As Excel.Application
Dim wk As Excel.Workbook
Dim rst As Recordset
Set appXL = New Excel.Application
Dim xxx As Variant
' The path/name of the XL file goes here.
Set wk = appXL.Workbooks.Open("C:\a 2\temp.xls")
'open Query/table here
Set rst = CurrentDb.OpenRecordset("zztemp2", dbOpenForwardOnly)
wk.Worksheets("sheet1").Range("a1") = rst!Field1
rst.MoveNext
wk.Worksheets("sheet1").Range("a2") = rst!Field2
'clean up behind yourself and quit excel
Set rst = Nothing
wk.Close (True)
Set wk = Nothing
appXL.Quit
Set appXL = Nothing
End SubEdit
I forgot to add that you will need to make a reference to do this.
in any module go Tools>Reference... and scroll down select the "Microsoft Excel Object Libary"
HTH
Peter
Upvote
0
Two things. More examples of technique.
http://www.mvps.org/access/modules/mdl0035.htm
And, you forgot something bat. This line needs to be included in your closing/cleanup segment at the end.
I believe this is the post where I first found my answer/explanation of why this is mandatory.
http://www.mrexcel.com/board2/viewtopic.php?t=76988&highlight=usercontrol
Nice work through all the other posts - you've been hammering out the correct answers for the last couple days and only leaving the itty bitty stuff for the rest of us.ray:
Mike
http://www.mvps.org/access/modules/mdl0035.htm
And, you forgot something bat. This line needs to be included in your closing/cleanup segment at the end.
Code:
appXL.UserControl = TrueI believe this is the post where I first found my answer/explanation of why this is mandatory.
http://www.mrexcel.com/board2/viewtopic.php?t=76988&highlight=usercontrol
Nice work through all the other posts - you've been hammering out the correct answers for the last couple days and only leaving the itty bitty stuff for the rest of us.
ray: Mike
Upvote
0
I have no problems getting out of Excel with out using UserControl usink Win2K/O2K but I will try to add it to other examples in case it is a version specific problem.
Help implies that it should not be a problem as it releases XL when the last reference to it is released.
Access is fun, biggest problem I usualy have is deciding what the question is actualy asking
The other problem I get is ammount of time I can commit, as projects come and go I may be in and out all day or not here for weeks at a time, but I like to answer when I can, as solving other ppl's problems often gives me a head start when something simmilar crops up for me.
Peter
Peter
Help implies that it should not be a problem as it releases XL when the last reference to it is released.
Access is fun, biggest problem I usualy have is deciding what the question is actualy asking
The other problem I get is ammount of time I can commit, as projects come and go I may be in and out all day or not here for weeks at a time, but I like to answer when I can, as solving other ppl's problems often gives me a head start when something simmilar crops up for me.
Peter
Peter
Upvote
0
I'm also W2K/O2K - and I get it every time. Primary visible symptom is it'll close the visible window, but if you check task manager, you'll see a running instance of Excel.
I'm pretty sure my installation is current - have tossed my employers standard install in favor of O2Kdeveloper off my personal CD's.
Here's a test question for ya Bat. What's *your* default property value for it? Could yours be defaulted to true?
Mike
I'm pretty sure my installation is current - have tossed my employers standard install in favor of O2Kdeveloper off my personal CD's.
Here's a test question for ya Bat. What's *your* default property value for it? Could yours be defaulted to true?
Mike
Upvote
0
nope, it shows as false when I test it. I check taskmanager to make sure there are no instances and there is no XL.
Only other thought I have on this is whether there is a difference in using early/late binding?
And I was slightly misleading with versions as I have W2K / O2K but with A97 and just to add to the confusion I have also had AXP installed to help with ppl who have had their pc's upgraded.
peter
Only other thought I have on this is whether there is a difference in using early/late binding?
And I was slightly misleading with versions as I have W2K / O2K but with A97 and just to add to the confusion I have also had AXP installed to help with ppl who have had their pc's upgraded.
peter
Upvote
0
Really don't know - I'm using the same technique as yours above/early.
I'd be curious as to the culprit - may try copying your precise sample in a fresh mdb just to see if it preforms any differently.
I'm wondering if it's a limited subset of the actions you can do that's triggering the save/close issue for me.
Mike
I'd be curious as to the culprit - may try copying your precise sample in a fresh mdb just to see if it preforms any differently.
I'm wondering if it's a limited subset of the actions you can do that's triggering the save/close issue for me.
Mike
Upvote
0
Similar threads
- Question
- Solved
