Recent content by stibbetts

Private Sub CommandButton1_Click() Application.Run "Book1!HelloWorld" End Sub this code works for another macro in excel, does anyone know how to run a macro in another program from excel? the specific program is autodesk inventor (drafting) but even a push in the right direction from another...

thanks rodie, that solved one of my questions too ;-) it got rid of the change cell event in the spreadsheet that fired a sub in a module (i dont like convoluted)

I know I'm Digging up bones resurecting this old post but I have the same question as that origionally posed by sabascal, how do i give the pdf a name? I am a fairly novice code writer so without a help file or object browser for the adobe pdf writer or distiller i dont know how to attack the...

oh, gotcha. that should work. thanks much :-)

AFAIK?

you dont happen to know if there is any significant functionality lost if i save the archive as a .csv file so that the macro can differ it from the .xls which isnt an archive? good idea though thanks ;-)

I have a program that automaticaly archives an Excel workbook when it is opend for edit. it does so with .savecopyas() the problem is that when i open the archived file that sub runs again and makes an archive of the archive :-\ is there any way that i can de-activate a macro through code? or...

how would I go about filling in a dialogue box using vba? I ask becasue I have a very old versino of autodesk inventor and noone can figure out how to create a drawing view with it but i can get the dialogue box that does that to pop up. so is ther eany way to automatically fill in those...

i gave up and attacked it from a different angle thanks to those who tried though :-)

saveas gives me an argument not optional error, save however works but makes saveas pop up becsue its a new document. and its in autodesk inventor just an fyi incase it helps. thanks though

can anyuone think of anything else that may cause this?

no dice :-\

Set InvApp = GetObject(, "Inventor.Application") DoEvents Set dwgref = InvApp.Documents.Add(kDrawingDocumentObject, ("w:\Inventor\Templates\LHW.idw"), True) like that?

oops, forgot to clean that up :-[ but even cleaned up it still doesnt work properly

i have this piece of code, it works sometimes, sometimes it gives me an error and if i click debug and then run again it works, sometimes i have to do this a couple times, sometimes it doesnt work at all, on top of that its completely random as to when these happen. ive tried restarting the...