Search results for query: *

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

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?

i have an image created at runtime and I have loaded a picture into it but it's not displaying, i know that the image works becaseu it is displayed on the page before. i am using this code for the process: Dim newpic As control, imim As String, objcontrol As control, imag As IPictureDisp Set...

i have a user form with one tab, on this tab there are 6 combo boxes, is there any 'For Each' statement or something else (to bad there isn't a 'For All') that i can use to edit all of them and enter the same info into each list? the reason i ask is because although there is only one tab to...

I have an .IPT that is linked to a spreadsheet, I am re-Linking that to another spreadsheet. thats all that I need to happen. However When I do So I have a couple of issues. One I get an error that the Ole Links Appear to be Inconsistent as soon as I open the part, if i open the spreadshet...

the #REF! error appears in several worksheets that i have created it is in a cell that is a formula off from several other formula cells. when i open the worksheet (which happens to be a copy of another worksheet) some cells have that error, if i slect the cell, then click in the formula bar...

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

would anyone happen to know off the top of their head how to start the actual excel program through code?

does anyone know how to change which spreadsheet inventor is linking to?

i am using filesystemobject to list some files that i am going to perform some operations on, the issue i am having is that the filesystemobject method of doing this comes up with the 5 files that i put in the referenced folder as well as a couple hidden or system files (im not sure which or...

i have a loop that does a couple things there is a counter and debug.print and a couple other litle things, but inside this loop is another loop, this loop runs till its done then its supposed to go back to the other loop like this: public sub loopy() myname = dir(Specified path, vbdirectory)...

so, this program that i am writing is coming into the home stretch, my problem is that i cant get it to cycle through checkboxes. i have created checkboxes at runtime and names them, big supprise, checkbox1, checkbox2, checkbox3,...checkbox-N. i have a loop inside a loop that determines what...