Import Data

Tutorials Win: Microsoft Windows Forum

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
Top

Re: Import Data by Jay

Jay
Thu Apr 20 21:49:00 CDT 2006

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
<JohnSutton@KansasBankersSurety.com> 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
Top

Re: Import Data by John

John
Fri Apr 21 08:28:17 CDT 2006

Sorry, thanks, I'm working on seperate problems in both.......
John
On Thu, 20 Apr 2006 22:49:00 -0400, Jay Freedman
<jay.freedman@verizon.net> 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.

Top