Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having trouble importing CSV files with a macro
Hi all,
I'm having a problem with a small amount of VB code I've written fo use with Excel on my mac (Excel X). I need to prompt the user to selec a particular CSV file, copy it, and paste it into the current workshee I'm using. When I open the CSV file i'm using it populates it correctly, but a soon as I use the macro some of the cells end up being merged into on cell. Am i using the correct datatype for CSV? If so, has anyone go any other ideas as to what might be wrong? Sub Test() Dim sImportFile sImportFile = Application.GetOpenFilename Workbooks.OpenText FileName:=sImportFile, DataType:=xlDelimited Comma:=True ActiveSheet.UsedRange.Select Selection.Copy ActiveWorkbook.Close Worksheets("Marks and Grades").Range("A1").Activate ActiveSheet.Paste End Sub Thanks a lot in advance, Lia -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having trouble importing CSV files with a macro
Why don't you simply open the csv file and let Excel do all the work
Workbooks.Open Filename:=sImportFile |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having trouble importing CSV files with a macro
Looks like you must be running additional code that is doing the merging.
There is no statement in what you have posted that would merge the cells. It may be that all the data is not being read into individusl cells. Stop the code immediately after reading in the CSV file and expand the columns and see if the data is not properly read in. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Sportiva " wrote in message ... Hi all, I'm having a problem with a small amount of VB code I've written for use with Excel on my mac (Excel X). I need to prompt the user to select a particular CSV file, copy it, and paste it into the current worksheet I'm using. When I open the CSV file i'm using it populates it correctly, but as soon as I use the macro some of the cells end up being merged into one cell. Am i using the correct datatype for CSV? If so, has anyone got any other ideas as to what might be wrong? Sub Test() Dim sImportFile sImportFile = Application.GetOpenFilename Workbooks.OpenText FileName:=sImportFile, DataType:=xlDelimited, Comma:=True ActiveSheet.UsedRange.Select Selection.Copy ActiveWorkbook.Close Worksheets("Marks and Grades").Range("A1").Activate ActiveSheet.Paste End Sub Thanks a lot in advance, Liam --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having trouble importing CSV files with a macro
Liam
I am using this to import a tabed file in to excel (windows) Workbooks.OpenText FileName:= _ strfilename, Origin:=xlWindows, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=True, Comma:=False, _ Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), Array( _ 3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)) Do not know about a mac system, buy look at the DataType, which can be set to Mac, and the TextQulifier, ie xlcomma, It might be easyiest to import one by hand and recored the output using the macro recorder Good luck Ross |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having trouble importing CSV files with a macro
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing and merging Excel files by using a macro | Excel Discussion (Misc queries) | |||
Macro for importing text files but the file name changes | Excel Worksheet Functions | |||
trouble with pxl files | Excel Discussion (Misc queries) | |||
importing from notepad trouble | Excel Discussion (Misc queries) | |||
Having trouble with web query, importing not consistent. | Excel Discussion (Misc queries) |