Onlyadrafter, your code is easy to follow and helpfull but could you explain what "IV5" and x1toleft refer to in the context of the code?
For MY_COLUMNS = 1 To Range("IV5").End(xlToLeft).Column
Tim
I'm not sure because I use an older version of light. When I can do something by selecting buttons but don't know the command, I do it one then hit f2 to see what commands were used. I then use the same command with a - or _ in front of it to force it to be all text entered. Then I can...
A friend stopped by with a question earlier and I found him a quick answer but I'm wondering if there is a better answer.
He had a list of text in some excel cells and he wanted to know how many entries were in the list.
ex:
A B
1 Name1 5
2 Name2 17
3
4 Name3 0
5...
about the template file
First_tag_here c 040 000
Second_tag_here c 040 000
the c stands for text or string or someting like that
the 040 sets the limit of upto 40 characters and it can be changed. The 000 refers to decimal places when importing a number.
Tim
The following is the format for at template file that you might just save as template.txt
First_tag_here c 040 000
Second_tag_here c 040 000
The trick about this is no extra spaces or [enters]
now the scrit file(access.scr) to extract the data is:
-attext
c...
Alright, I opened the file and the code you want doesn't look to hard. First I want to thank you because your file showed me vlookup wich I had never seen before.
You can aproach this from a few different ways. Either you can set up a macro that you run after each data entry or one that does...
I learned this mostly between this web site and the tek-tips site. (plus reading different help files once I heard of the commands)
(I am using Autocad lt 2000 and access 97)
(Do not use spaces or you may need to find other ways of doing this)
1st) how to make a "block" that...
I only know how to do this 1 way so far. I can insert a block with defined attributes into an Autocad file and I can also pull out those defined attributes into access but I don't currently know how to change from access the attributes already in an autocad file. Would this information be of...
Page requested not found.
Reading your note makes me think you understand the logic needed to do what you want to do.
First are all 3 sheets in the same workbook?
It sounds like you shoud be able to put in your "sticer sheet" =checklist!a1 if the information you want is always...
Heres what to do. (I assume you know how to use access better than I do) Bellow is an example.
I created a file named insert_text_two.dwg (note it is best to avoid using spaces)
The file has everything drawn out plus I have two parts of text that can be changed.
To make text that can be...
I've learned how to extract attributes from my drawing file and now I'm trying to import them into access. When I do this manually I have a choice for text descriptor and set it to '. But now I'm trying to do this in VB code and I don't see any way of removing the singlequote. Does anyone...
