Hi
Very new to excel 2007. I have the following piece of code that allows me to import and array the data in excel 2003 but does not work for excel 2007. Does anybody have any ideas?
Application.StatusBar = "Importing 0367 Era.Dat File..." Workbooks.OpenText Filename:=txtDirectory, Origin:=xlWindows, _ StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), Array(10 _ , 1), Array(37, 1), Array(45, 1), Array(64, 1), Array(85, 1), Array(97, 1), Array(101, 1)), _ TrailingMinusNumbers:=True
Thank you in advance
Matt
Last edited by TMShucks; 01-16-2012 at 03:14 AM. Reason: Added Code Tags
Please attach the text file so we can test it at our end.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
It won't let me upload the file. Not sure if this is against forum rules but if you PM me your email address I can send you both files
Cheers
Matt
Last edited by mattyk; 01-16-2012 at 03:10 AM.
You can try zipping the file and then uploading it. Its better you upload the file here so that others too can assist you.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
per attached
Cheers
Matt
Are you getting any error msg while importing it in 2007?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks