Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by MacroMania
-
Methods Failed
Just wanted to add, in order for OpenText to work corectly, FieldInfo will need an Array(#, #) for each column, so that each columns is labeled what type of data Excel is importing. Here's the Code for using FieldInfo for all the columns: .Workbooks.OpenText...- MacroMania
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Methods Failed
I have it set up as FileName:="\\path\" & filename (I) I had just shortened it to "\\path\filename(I)" because I was in a hurry. Actually, I've figured out what the problem is, and this is kind of weird, but I guess makes sense. When I use the command...- MacroMania
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Methods Failed
I've been playing with the files and importing data a cell at a time, and I think it might have something to do with the word "TRUE". There are a few strings in the Bad Files and contains strings that begin with "TRUE " or "TRUE, ". If I change "TRUE" to...- MacroMania
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Methods Failed
I am experiencing some errors with my program and can not figure out what is going on. I have a VB Program that calls Excel to create a set of workbooks for each given text file in a directory. However, it errors out on 5 textfiles with the following error "Method 'OpenText' of object...- MacroMania
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
