I am really struggling to get the attached code to run. I am quite inexperienced at VBA but could really use some pointers on this. I would also really like to add to this code the ability to overwrite the sheet if it already exists in the workbook but have been unable to get that to work either.
Thank you all for your consideration
I keep getting this error Capture.JPG
Please Login or Register to view this content.
Last edited by soulspike; 08-27-2015 at 01:16 PM.
This may not resolve your current issue, but I did notice that you haven't declared what impList is but it is used in the 1st If/Then code.....Ex. Dim impList as ?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
I updated the code above and removed the superfluous code. I also colored the line that I error out on on.
thanks
Try
Please Login or Register to view this content.
I tried that and continue to get the same error, I am sure i am missing something small.
That makes 2 of us because I cant figure out why it is giving that error either.
Ok I think I have figured it out. I am running these from a ribbon and I have other code working but nothing that copies sheets. When I open excel with a .xlsx extension it doesn't work, but .xlsm does. So it has to be the permissions, I guess i need to figure out how to make the code in my ribbon trusted to allow it to run outside of an .xlsm.
I think, in order to run macros, it has to be the .xlsm extension.
Well i have other macros that are formatting and calculating inside of its own workbook.
They work just fine in any .xlsx file. The copy code works fine up to the point where i try to copy from the other book.
In fact it opens the first book in the list but just fails the copy method.
As I said. "I think....." I'm pretty inexperienced with VBA as well, so sometimes what I say is completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks