how to link data automatically from excel spresheet to a csv file

I

imy1971

New Member
Joined
Apr 26, 2011
Messages
18
HI There I am trying to link data from an excel worksheet to different csv file. Is there a formula or another way i can use.

Can you have a formula with out opening the csv file but can be referenced to a csv

Appreciate your assistance
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Sort by date Sort by votes
Hi

Csv files are simple text files so Excel can't link to specific "cells" in one unless it is opened. Best bet would be to save down as an Excel file instead.
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Solved
Formula with Link not working in VBA
Replies
2
Views
273
woodsy74
W
S
  • Question Question
Merge two table from different csv files
2 3
Replies
24
Views
654
Soly_90
S
TryingToLearn
  • Question Question
Open a csv file but don't import all data and don't insert ""
Replies
1
Views
127
DanteAmor
DanteAmor
P
  • Solved
VBA to insert filename in a new column for all files in a folder
Replies
2
Views
115
psion2600
P
T
  • Solved
CSV import overwriting the next column after the last one in the CSV file
Replies
7
Views
328
Joe4
Joe4

Forum statistics

Threads
1,224,600
Messages
6,179,834
Members
452,947
Latest member
Gerry_F

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top