Hello,
I have a macro that keeps wanting to open version 4 of a file (the one I created it in), even when I have version 5 open.
If you could take a quick peak at my code and tell me what's going on, I would appreciate it!
See attached.
Thanks in advance!
Justin
Hey I'm new to this macro thing. Should I post the code here rather than the file so that no one is afraid of me sending a virus or something through the code?
Hi,
Your file ThisWorkbook part includes that code;
Even you delete that code your pivottable and pivotcharts works properly...
Please Login or Register to view this content.
What is your question clearly ?
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
Hi Herry,
Thanks for the response!
For whatever reason, when I open the file I attached earlier in the thread, the macro automatically opens another file on my hard drive and runs the macro in that file....and I can't figure out why its doing that.
Any suggestions?
Thanks!
Justin
I cant find any reason why it is doing that...
Are you sure attached file includes everything?
Last edited by HerryMarkowitz; 09-18-2014 at 06:36 PM.
Hey I just discovered the problem! When I run it from the vba window with f5, it works. I had been trying to run it from the "CKS Macros" tab in the ribbon. That's when it wants to open the other file...odd.
Maybe if you could help me with that, that would be great. Otherwise, no problem...I'll mark it solved.
Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks