Hi, all,
I have an Access database that pulls up reports in Excel. I need a bunch of these reports to pull up another one-page workbook, copy in the data from A:K to a sheet with the same name on the report, then close the one-page workbook without saving. The problem is that, while the report (second function) runs, it doesn't seem to be doing anything with the first function. I would be very grateful for any help.
Please Login or Register to view this content.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
1. But these are not functions, just the usual/ordinary "Sub" procedures ?
2. Missing 'Set xlApp', without 'Set' when deklaration is 'Dim xlApp As New Excel.Application'
3. "xlCoDivDepSheet" - this is missing in the code, in addition to the declaration
4. Missing 'Set xlBook'
Thanks for your reply. Unfortunately, I didn't write most of this code and I've never gotten good with VBA. I'm trying to modify what I was left to suit my purposes. For 2 and 3, I don't understand what the declaration is supposed to actually be. For 4, I need it to be whatever xlBook is in the sub that is calling the first sub. Is there a way to do that or would that happen automatically if not declared? Thanks for your help.
Try, maybe this way ?
Please Login or Register to view this content.
Since I have to put this in literally over a dozen places, I was hoping there was a way to just call it in. If there's not, though, I understand. I'll just revert back to the way it was and start copying it over. Thanks for your time, though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks