Recent content by vbcad

test for url

Where can i attach the file? I see the upload button is missing

I have a spreadsheet for some workouts. What i am trying to do is make the previous selection for each list be unavailable in the following weeks sheet. for example in Week1/Day 1 I can pick "Front Dumbbell Lateral Raise" from the list in the first section. Then on Week 2/Day 1 I would like...

I am currently using data validation and allowing a list from a named range.

Thanks I have started to look into this but MS Query this is completely new territory for me.

I have a workbook that uses named ranges for data validation in drop down lists. For example "table1" (named range) has item 1, item 2 and item 3. this table is referenced to a drop down list in sheet 1cell a9 for example. this table is also referenced in cell a9 on sheet2 in the workbook. The...

Thanks. forgive my ignorance a bit. Where in the code do i paste this (if at all) I tried to run it and i get an error. i did enable the microsoft scripting referance. I want the sheet to have a header that says "project number" and another header "date last modified" date column is obviuos of...

Below is some code that works for what it was originaly intended. however all I would like to have it do now is create the list of Folders withing the main directory and only one sublevel below that. I do not need any file names just the folder names. I have attached a file to show what I would...

Below is some code that works for what it was originaly intended. however all I would like to have it do now is create the list of Folders withing the main directory and only one sublevel below that. I do not need any file names just the folder names. Sub prjFiles() Workbooks.Add ' create a new...

I have some new code. The selection set works fine.I changed the layer just to see if my selection set would work.( i dont need to do that) How do I select the arc and/or spline objects within the block definitions and change the lintype? I am a bit lost. (defun c:fH (/ ssets acadDocument...

I have since been updating the code. It now looks nothing like this. I will post new code if needed. Thanks for any help

Below is some code I am attempting to translate to visual lisp. We have upgraded to 2010 and would like to get away from the VBA editor and I can see it will eventually just go away. What it does is takes some blocks on two specific layers and changes the arcs and/or splines and changes the...

I would like to create a reactor lisp to run the posted code. What I need to do is to rotate the attributes of all block back to zero when I use the commands "insert","Execute tool", "copy" "rotate" Basically any command that would change the orientation of the attribute. I have know idea on...

I have a reactor lisp obtained from another website, (author was not given) It works great for attributes but I am trying to figure out how to use it for plain text in a block as well. Any ideas how this can be modified to rotate the text and attributes back to zero? below is the code. (defun...

Let me know if you get the message i sent