I am very new to excel's macros and vba coding...
I've made my first macro to run 16 regressions, but 16 times I get the warning box for overwriting existing data, so I have to click OK button 16 times in a row and it annoys me.
Application.DisplayAlerts = False
I tried this solution, put it everywhere in the script but it doesn't help.
Any ideas?
Thanks!
Last edited by paupaj; 10-19-2020 at 03:45 AM.
You just place Application.DisplayAlerts = False before the process is invoked and don't forget to set it back to true after the proces is completed
Without a sample of what you're doing that's all I can say
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Here's my simplified code I'm working with.
Attachment 700241
Tried Application.DisplayAlerts = False before the code, in between all regression lines, nothing worked.
invalid attachment - paperclip does not work - follow instruction on big yellow banner.
Added a simplified excel workbook
@papaj: not much use without the workbook it refers to !!!
@Keebellah: Sorry, I don't understand...I can't find how it is refered in another workbook... I've just created this new file , created new macro and uploaded
Toen i suggestie you take a look at the file you attached
This is the macro named Regression in your attached file:
I suggest you explain this: "ATPVBAEN.XLAM!Regress"
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks