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

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
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
116
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,608
Messages
6,179,872
Members
452,949
Latest member
Dupuhini

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