Dim xls As Workbook, Dim Csv As ????

's Computer Specifications

When you deine xls you use workbook, e..g Dim xls As Workbook, Set xls
= Workbooks.Open

What about with csvs, should they simply be:

Dim csv
Set csv = .Open

Thanks fro your help

's Computer Specifications

A csv file opens as a Workbook

Dim sFile as string
Dim wb As Workbook

sFile = "c:\<path>\filename.csv"
set wb = Workbooks.Open(sFile)

Regards,
Peter T

"Simon" <(E-Mail Removed)> wrote in message
news:54f7a100-d404-4724-b74e-(E-Mail Removed)...
> When you deine xls you use workbook, e..g Dim xls As Workbook, Set xls
> = Workbooks.Open
>
> What about with csvs, should they simply be:
>
> Dim csv
> Set csv = .Open
>
> Thanks fro your help

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Possible to remove Workbook window title bar? Or other ways toarrange multiple workbook windows.	minimaster	Microsoft Excel Programming	4	15th Sep 2009 11:47 AM
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook	burl_rfc	Microsoft Excel Programming	1	1st Apr 2006 08:48 PM
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ??	WimR	Microsoft Excel Programming	9	25th Jul 2005 12:44 PM
Workbook.XLS worked fine. Now I installed workbook.XLT and both open very slowly in XL97	Marvin Hlavac	Microsoft Excel Worksheet Functions	0	2nd Feb 2004 11:26 AM
What commands do you use to name a workbook, save a workbook,open a workbook	Steven R. Berke	Microsoft Excel Programming	1	24th Jul 2003 11:37 PM