Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Import Data
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 |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Import Data
Boy, are you lost. This newsgroup is for Word, not for Excel. Try
asking in the microsoft.public.excel.programming newsgroup. To get you started, read the Excel VBA help topics on the ActiveWorkbook and ActiveSheet objects. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Thu, 20 Apr 2006 11:54:39 -0500, 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 |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Import Data
Sorry, thanks, I'm working on seperate problems in both.......
John On Thu, 20 Apr 2006 22:49:00 -0400, Jay Freedman wrote: Boy, are you lost. This newsgroup is for Word, not for Excel. Try asking in the microsoft.public.excel.programming newsgroup. To get you started, read the Excel VBA help topics on the ActiveWorkbook and ActiveSheet objects. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there any way to import data into an existing template? | Microsoft Word Help | |||
how to import data from a single-column text file to a multi-columntable? | Tables | |||
How to import XML data into a Word document table | Tables | |||
Import data from Excel into a two column page in word | Microsoft Word Help | |||
Import csv data into a specifically formatted Word table | Tables |