Links vs OpenWorkbook method

  • Thread starter Thread starter dancing fish
  • Start date Start date
D

dancing fish

Dear All,

I have an old spreadsheet that accesses files via remote referenc
links. The people that use the spreadsheet do not have access to th
files, yet the links work.

I have recently redeveloped the spreadsheet to open the files and brin
back the information instead of linking to the file. However, the macr
i use to do this says it cannot find the file.

Why did the links work but the workbook open method doesnnt?

Is there a workaround in VBA to access files you dont have permissio
to view (hiddenfiles perhaps)?

Or, does anyone know anything about a workaround using the I
infrastructure here (we are on NT) that does not include giving acces
to the files to the users of the spreadsheet.

Regards

DF
 
This surprises me.

Are you sure that the users don't have access?

Are you sure the links are being updated--not just real old values?

I'm not aware of anyway of allowing access via code.

Well, if the users have access to the workbooks, but don't know the password for
changes????

You could have a macro open the workbook (supplying the password), retrieve the
data, close the workbook all pretty much invisble to the user.

Look at VBA's help for workbooks.open. You can specify a password there.
 
Back
Top