Long File Names/Folders

[BobChesh]

I am trying to open Excel from Access 97 on an NT o/s, using the RunApp macro command. I can get Excel to open, but since the sheet that I want is deeper than the root directory, I have problems getting there. It would seem that I am limited to 6 characters for the folder name, and anything longer is replaced by the tilde character (~), but this can only be used once. So how can I open a sheet that is in say S:\Business\BusinessFaults\Oftelfaults\oftel.xls? as S:\Busine~1\Busine~1\oftelf~1\oftel.xls does not work.

Cheers

BobC

 

[xlbo]

You could do it via code rather than a macro - and then run the code from the macro if necessary - this should work:

Option Compare Database
Option Explicit
Sub OpenExcel()

Dim objExcelApp As New Excel.Application
Dim objExcel As Object
'create Excel
Set objExcelApp = New Excel.Application
'open file
Set objExcel = objExcelApp.Workbooks.Open("S:\Business\BusinessFaults\Oftelfaults\oftel.xls&quot
objExcelApp.Visible = True
end sub

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[BobChesh]

Geoff,

Brill. It works, sort of.

Since I got an error, I converted my macro to code, then changed the path and all is well.

Thanks, that has saved me a lot of heartache, and the cause of numerous other problems I have elsewhere.

Bob C