Graham,
Thanks for the detailed explanation. As you may be able to tell, I've been diving in the deep end without really knowing how to swim (e.g., here in Colo, "binding" is something we use on our skis). I think this will allow me to gain deeper understanding. That's what I prefer because then I'll be able to do a lot more, whereas just blindly copying code may only solve the immediate problem. Sometimes I can figure out the underlying processes from that, as I did several years ago with a function AD wrote for me (I have since written numerous other complex functions), but that takes time, and doesn't always work (it didn't in this case).
Re binding: what do the following lines mean an do?
Debug.Assert xlCenter = -4108
Const xlCenter = -4108
Why should I put all the Excel VBA code in Access instead of using "xlApp.Application.Run "FileName!MacroName"?
When do I need to use:
xlApp.Quit
Set xlApp = Nothing
xlBook.Close (or is it xlDoc)
The Range I am referring to is six, not two cells, SumRow,6:SumRow,11
Also, in Excel, it lets me define a range as columns("E:E","G:G","I:I").NumberFormat = "$#,##0" to format non-consecutive columns, or columns(5,7,9). That doesn't seem to work when I run the VBA from Access. Any idea why?
Adam
I'm the one who posted the original question. Phil was just trying to help.
Posted by: runuphillracing@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (14) |
Tidak ada komentar:
Posting Komentar