Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to import csv file data to already open worksheet (in C#)

Hello,

I need to import data from a csv file into a worksheet on an already opened
workbook (programmatically using C#). I have been able to use the
....Workbooks.OpenText() method but it opens a new workbook. I can see that
using the menu options Data/import external data/import data does the trick
(and I've recorded the macro and can see what it's doing - in VBA of course).
I need to know how to perform this macro task in C#. Can anyone give me a
clue?

Thanks!
--
"If we new what we were doing, it wouldn''t be called research!"
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do a import data from a text file to an excel worksheet madlin Excel Discussion (Misc queries) 4 January 12th 10 05:04 PM
CAN I IMPORT DATA FROM A CLOSED FILE TO A NEW WORKSHEET Paul Excel Discussion (Misc queries) 1 January 11th 07 03:30 PM
Find first blank row in worksheet to import data from txt file DDK Excel Discussion (Misc queries) 1 December 19th 06 05:39 AM
How do I import text file, analyze data, export results, open next file Geoffro Excel Programming 2 March 6th 05 09:02 PM
open file dialog-select file-import worksheet Divinedar Excel Programming 1 January 16th 04 08:13 PM


All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"