Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import
I'm guessing that you've recorded as a macro the steps of importing the .csv
file and have ended up with a macro step that hardwires the workbook name, e.g. ..Name = "Book1" You could change this line as follows to work for whatever workbook happens to be active: ..Name = ActiveWorkbook.Name Hope that helps. "John Sutton" wrote: My apologies if this is in the wrong spot, I could find no obvious place for it. Is it possible to import a .CSV file into an existing .XLS? I want to bring the data into a spreadsheet inside a macro, but I don't want to have to use the file name of the spreadsheet, only the name of the ..CSV file. That way, I can use the same macro no matter what the file is named. Another alternative, is there a way to get the name of the spreadsheet within the VB code, then I could just interrogate the spreadsheet for it's name, open the .CSV file and then do my copy/paste operation to get the data where I want it. John KBS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import XML | Excel Discussion (Misc queries) | |||
import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Import xml | Excel Worksheet Functions | |||
I can import Access Tables. But, I can't import Access queries | Excel Programming |