Recent content by Volk359

That's it, thanks so much!

There, that's the ticket. Awesome, thanks! One last item, if you please. I'd also like to have the macro clear the filters in the sheet: Rows("1:1").Select ActiveSheet.ShowAllData Which works fine however if none of the columns are filtered then it bombs. I'm familiar with some...

Sorry, for some reason it doesn't like the .Apply

Looks good but for some reason it bombs at .SetRange .Range("A1").CurrentRegion

Greetings All, I wrote a macro to clean up some of our spreadsheets, part of the process is doing a sort when it's done. The problem is it's workbook or worksheet specific and my VBA isn't good enough to be able to remove the part of the code to make it work in all work books...

Greetings All, I'm writing a script to move all objects in a drawing and would like to use the insert point of the title block as a base then move it to 0,0. Since the title block is in random areas in different drawings I can't always move from the same point A to point B. The ideal script...

No, you had it right. Unfortunately "we can't find it" is all too common from our contractors. Since it's embedded the data should be in the drawing so it seems to me there should be a way to digitally extract it.

Greetings All, We've got some drawings that have been turned over to us where an Excel spreadsheet has been linked as an OLE. The data needs to be updated however the original file is no longer available so the table cannot be opened in Excel. By right-clicking on the object and selecting...

I see, by swapping IMAGENAME and FILENAME I don't have to strip out the file extension and reassemble it. Thanks much!!.

OK, that seems to work except it's looking for filename.CAL.TIF. I inserted the line to strip out the last three characters and put the whole thing together properly but I get: Unknown command "C:\DOCUMENTS AND SETTINGS\me\DESKTOP\filename.cal". Press F1 for help. nil (setq imagename...

Greetings all, I've created a lisp routine to automatically repath an image that had already been inserted but where the path/filename was incorrect. It works fine but the problem is the image type isn't always the same, i.e. sometimes they are a .TIF and others they are a .CAL. I included an...

FYI - here's a solution that works very well: LIMITS 0,0 (list (* (getvar 'dimscale) 36) (* (getvar 'dimscale) 24)) zoom all Thanks

Greetings all, I'm trying to write a script that will reset the drawing limits according to the dimscale using the following code: LIMITS 0,0 'cal getvar(dimscale)*[36,24] zoom all It appears to work fine, i.e. no errors, but the upper limits aren't being set. Anything wrong here? Thanks...

Hmmm... not sure I remember that one and it isn't listed in the help anywhere. Doing a search in help returns Extract Block Attribute Data. Anyway, thanks for the answer!

OK, this should be an easy one but for the life of me I can't find it. We've got a user here that is opening several drawings at the same time but instead of all in the same session it's opening each one of them in different sessions. I'm assuming it's a checkbox or variable but looked in...