I'm not getting any errors but nothing is happening when I run the macro. Thanks to the comments below I've updated the code: Sub ImportCSV() "Sub or Function not defined (ThisWorkbook 7:26)" Set wsMstr = ThisWorkbook.Sheets("Sheet1")įPath = "/Users/bensimmons/Downloads/GMI/"Ĭolumns(1).SpecialCells(xlBlanks).Value = ActiveSheet.NameĪ wsMstr.Range("A" & Rows.Count).End(xlUp).Offset(1) ' adding a field in column A listing the CSV filenames It is designed for Windows users to convert PDF files back to. 'Summary: Import all CSV files from a folder into a single sheet PDF to Excel Converter is a practical conversion tool to help you convert PDF to Excel 2003/2007/2010 Spreadsheets (.xls. ![]() ![]() You can also convert a Numbers spreadsheet to Excel via iCloud on any system, if you’re not. xls (older version used before Microsoft Excel 2007) Select Next. I recorded a macro loading data from one csv file and the path generated is shown below. Click Advanced Options if you’d like to change. The path structure in MAC OS is different than Windows. ![]() So every line brought over from that file with have the file name in column A. I want to place them all on one worksheet and place the file name in every cell of a column for data coming from that file.
0 Comments
Leave a Reply. |