Search results for query: *

I have done a little research and my take on this is that Save as... creates a format and that that isn't necessarily how the text is transmitted or parsed in regular communications.

I am programming in an SAP system and I can send e-mail messages out and format them as HTML. Is there a way that Outlook would intepret an HTML tag to fill in the Categories field in the Options menu? Help here could also be useful in sending e-mail messages from web pages etc.

ps remember to set Tools/Macro/Security/Trusted sources to trust access to Visual Basic project. Again thanks for this dead-on tip crslack

Gizzy17, Thank you very much. This is manna indeed. You should make this a FAQ. crslack

I am truly a vba novice but I am not a programming novice. I appreciate everyone's good intentions. I did search for modules & lines but nothing looked like it would allow for code creation. One example that produced activesheet.range("A1") = "Hello world" would be manna...

Thank you both. Two good ideas.

I tried a key word search but I can't find anything. Perhaps I am using the wrong key words or can't recognize what is obvious to others. Any suggestions on a search strategy?

I am very novice at vba but I use some interpreted languages that allow the programmer to create statements at run time essentially by building a series of strings that comprise executable code then executing them. Does vba have this sort of dynamic coding option?

Here is the recorded macro that I forgot to post. Sub Macro1() ' ' Macro1 Macro ' ' Selection.TextToColumns Destination:=Range("I2"), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 1), Array(3, 1), Array(9, 1)), TrailingMinusNumbers:= _ True End Sub

My VBA macro will bring in a flat text file and a separate description of the text file that will describe how to take the fixed width data (no delimiters) and change it to columns. Excel's texttocolumns functions seems to be the way to go but I need to know how to dynamically set the number of...