| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to write vba code to import another spreadsheet...
Thanks Jeff,
I replied before tryiing your code. It works. Thanks! -- Otium Cum Dignatate "Jef Gorbach" wrote: "joep3" wrote in message ... I know this is simple, but it's not working for me. When I import another spreadsheet a number of column names are not imported. The columns are not on the first row. The first column being 'employee id'. I also tried transferspreadsheet command, but my code isn't even recognizing the docmd. Any hints? -- Otium Cum Dignatate Why not import the entire sheet rather than a subsection? <snip Worksheets.Add , Count:=1 Workbooks.Open FileName:="full path of filename to copy", ReadOnly:=True Cells.Select: Selection.Copy ThisWorkbook.Sheets("Sheet4").Activate: ActiveSheet.Paste Workbooks("file opened above").Close savechanges:=False <snip |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I import data from a closed Excel Spreadsheet? | Excel Discussion (Misc queries) | |||
| Import data to a spreadsheet. | Excel Discussion (Misc queries) | |||
| Can i see code and spreadsheet simultaneously | New Users to Excel | |||
| Using other workbooks.. | Excel Worksheet Functions | |||
| Write code to insert multiple lines | Excel Discussion (Misc queries) | |||
Threaded Mode
