Search results for query: *

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...

Maybe related, but I am having a problemwith saving as well, i create a new document and want to save it, if i use 'doc.save' it prompts me with the saveas window and asks for a name. but if i use 'doc.saveas "c:\filepath\filename"' I get an error message that saveas is not a valid method or...

vbajedi thanks. that should do what i wanted. docjohn52, Im not exactly sure what you are saying?

have an applicaiton that creates a new idw from a template. well.. it creates it if i run it from the vba editor. when i run it fro the macro's box the app opens up fine and performs all other commands to that point fine but when its time to '.add kdrawingdocumentobject, "path here", true' it...

I have a multipage user form, there is a command button that creates a new page and inserts several things, a picture, 6 comboboxes and a command button, the problem is that i cant seem to make the command button perform any task. i write code for it but it wont do anything. any ideas?

oops, silly me, i was referencing the wrong page. the picture was coming in but on the first page over the origional so i couldnt tell :-[