Thanks for the help Skip! But where it is actually truncating the text is when I export it from one spreadsheet to another - not during the Excel to ACAD conversion. Does this change your response at all? Or do I need to change the font as you suggested. I use Arial which I like the best...
You need to format the date. If entering in Excel, just format the cell to the output you want. If formatting from vba use:
.Numberformat = "dd mm yy"
Hope this helps...
Sue...
I create a title block for our drawings in excel and then export the sheet from a large spread sheet before inserting the block into AutoCad. All this is done with VBA code. Everything works great except that in some of the cells there is a good size quantity of text (notes and disclaimers)...
Thanks Zathras! Actually I thought of a good work around and it works just fine. I substituted a name for the lookup range thereby bypassing the ugly ! and VBA is happy! When VBA is happy so am I!!!!
:-D
I guess I wasn't very clear. I had typed it wrong initially but the code I was trying to use was just as you said it should be but it still does not work. VBA is rejecting it and I guess because of the !... Any new ideas?
Thanks very much!
No, that's not it. It is included in my code - I just typed it wrong here. It actually is:
Range("E22").Formula = "=IF(E20=0,0,VLOOKUP(E20,List2!U80:V89,2,1))"
Sorry about the earlier post... [bigglasses]
I probably have just developed a brain clot, but I am unable to make the following work:
Range("E22").Formula = "=IF(E20=0,0,VLOOKUP(List2!U80:V89,2,1))"
VBA seems to stick on the ! and using quotes or double quotes does not seem to work.
This is for a worksheet that I...
Well it helps me out since I am working on a "reirement-length" project that I am continually opening and closing. I can bypass the annoying dialog box with just that one spreadsheet. So I love it but can sure see the potential problems! Must be something Microsoft overlooked and...
Is there any way to create a Splash Screen with a UserForm and embedding WordArt? Or any other way of creating "fancy" text? I want the splash screen to jump out and grab the user's attention.
Thanks much!
Sue
Thanks for all your responses! My original question really had to do with speed and stability. This spreadsheet started out as an engineering aid that I developed using Excel 95 and it has grown from there to the monster that it currently is.
Initially all the controls were made using the...
FYI, after much head banging and trial and error procedures, I finally just replaced my register with an earlier version and the problem cleared up. Still don't know what caused the problem but could have been a corrupted registry...
Thanks for the help I received.
Just for my edification, when would a programmer choose to use checkboxes (for example) using ActiveX controls vs. Excel Forms controls? Would it be a good rule of thumb to use excel checkboxes whenever possible?
Suddenly I am unable to connect to my company's server to access my inbox. I start Outlook and first of all get this message:
Your Microsoft Exchange Server is unavailable.
I keep hitting the "Retry" button. Then I go thru the process of Outlook attempting to access the server...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.