Windows 200 excel VB in Excel X

[chris wilder]

I have an excel sheet, containing many VB macros, made in excel 2000
& running in win 95. The sheet contains much of the data, but in order
to produce analysed data & graphs, reference is made to a folder on
the remote server to access the .csv raw data files. When i transfer the
sheet & the .csv folder to the mac, understandrbly the directory
reference path is incorrect. I have tried several path descriptions, but i
keep getting file not found errors or device not found errors.
How can i direct the macro at the folder which currently is on my home
desktop folder?
All help gratefully received. Thanks. Chris W

 

[J.E. McGimpsey]

I have an excel sheet, containing many VB macros, made in excel 2000
& running in win 95. The sheet contains much of the data, but in order
to produce analysed data & graphs, reference is made to a folder on
the remote server to access the .csv raw data files. When i transfer the
sheet & the .csv folder to the mac, understandrbly the directory
reference path is incorrect. I have tried several path descriptions, but i
keep getting file not found errors or device not found errors.
How can i direct the macro at the folder which currently is on my home
desktop folder?
All help gratefully received. Thanks. Chris W

One way:

Const MYPATH = "Macintosh HD:Users:chrisesktop:myFolder"
Workbooks.OpenText _
FileName:=MYPATH & "myData.csv", _
DataType:=xlDelimited, _
comma:=True

Adjust MYPATH to suit...