shut down popup warning boxes

[stibbetts]

when i run my program it works fine except that there is a warning box that pops up every time i open a file with it, the warning box is valid but if it wouldnt pop up the next line of code in my program deals with the situation that it is warning for. So, everything is working, its just that i have to close that box for every file that the program runs, this is very annoying as there can be a couple dozen files run an i want to be able to walk away while the program does its thing. anyone know how to close it automaticaly or even keep it from opening? (the box poping up is an autodesk inventor box not one from my program)

 

[Luis939]

try,
application.displayalters = false

 

[stibbetts]

i dont have the option of displayaltars, know any hokey ways that might work on a really old version of vba?

 

[Luis939]

well i apologize, i mispelled it, it should be
Application.DisplayAlerts = False
if that doesnt work,,,then I dont know what else will.

 

[Luis939]

oh i forgot to mention, that line must be in your code, it wont work if you do it seperatly, becuase after code is executed, it defaults back to true, so i suggest putting that perhaps in the beginning of your code and then set it to true if you need to display certain messages.

 

[stibbetts]

the code is as follows:

Dim InvApp As Inventor.Application
Set InvApp = GetObject(, "Inventor.Application")
'this does not allow me to access the display alert
'function
invapp.displayalerts

am i doing something wrong?

 

[Luis939]

when i do it i put the actual words
application.displayalerts = false

or you could put Excel.application.displayalerts = false if your using Excel and you want to put the application's name there....so i think for your purposes you could maybe try

InvApp.application.displayalerts = false

 

[Luis939]

what version of VBA are you using?

 

[stibbetts]

vba version 6.3

 

[Luis939]

that is the version i have, so i would go along and test
InvApp.application.displayalerts = false or simply
application.displayalerts = false

 

[stibbetts]

still cant get to it :-\ , the program i am working with is autodesk inventor though not excel, could that have any bearing?

 

[Luis939]

oh well my familiarity is only with Excel, but im thinking that would work with all office application....maybe it only works with office applications, and not one that you define yourself

my last resort would be to use
inventor.application.displayalerts = false

if that doesnt work, sorry.

 

[stibbetts]

nope... i looked it up in the object browser, that command exists in excel but not inventor, back to the drawing board, thanks anyway

 

[Luis939]

out of curiosity, what is inventor?

 

[stibbetts]

I design windows and doors, Inventor is a 3 dimensional modeling program that makes design pretty darn easy (once its all set up, its alot harder tehn autocad untill then), you can define variables for as amny different dimensions as you want and design anything that you want, the neet part is that the variables you define can be spreadsheet drivenm so, i designed a bunch of templates off from one spreadsheet and all i have to do now is enter sizes into a spreadsheet and inventor draws everything for me