Your "IT Guys" should know that simply giving a user name won't help,
access to network folders get the network login name for access
purposes, having said that i'm not competent at network issues so could
e wrong, why don't you simply call the macro first, get your number and
then make the workbook protected?
Neil;367517 Wrote:
Hi All,

I'm looking to open a 'register' workbook, look down a column for the
next
available (sequential) index number (first instance of an empty cell in
the
target column), send that number (number above the first empty cell +1)
into
the workbook from which the macro was called, update the 'register'
workbook
by entering the now allocated index number into the previously empty
cell,
save the 'register' workbook and close it.

Seems easy, however there is a slight complication.
The 'register' workbook is in a directory that is generally read only
to
most users.
I need the macro to pass (write) credentials so that it can open the
file,
edit and save, all without the user knowing this is happening
(screenupdating = false).
My IT guys have set up a domain user named 'Macro' that has write
access to
the directory in which the 'register' workbook resides.

Can this be dome within an Excel VBA macro, passing of credentials
whilst
opening another Excel workbook ?
I'm using Excel 2007 but some of my users will be Excel 2000.

Any ideas ?
Thanks,
Neil


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=102953