Search results for query: *

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

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

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

Greetings All, So, why doesn't Play All or Play Selected from the side bar menu (under Music Tasks) work however highlighting the songs then right-clicking and play or double clicking them does work? Thanks in advance

Ah, I see, I've been going by the dialog box, i.e yes, no or cancel. Good eye, thanks!

Correct. If the changes are saved then it reverts back to the original file size and if not saved it keeps the new smaller file. For some reason by the command line it works but not in LISP.

...and got to bare bones: (setvar "CMDECHO" 0) (setvar "EXPERT" 2) (command "QSAVE" "WBLOCK" (strcat (getvar "dwgprefix") (GETVAR "DWGNAME")) "y" "*") That works fine but closing the drawing requires a save or no save. If I manually type in CLOSE and N at the prompt the new purged drawing is...

That's the trick I needed, have a star!