addmmore computer name or range in code

[iamhsn]

i have this code which wont let excel to open the workbook if the computer name is not M8. it works but i need to put few more computers name to make it work perfectly. can someone please help?

Please Login or Register  to view this content.

also is it possible to make the file open in specific IP range?




(i figured out the enable macro problem. so thats not a problem now. no macro no file open)

[Special-K]

Try something like

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[iamhsn]

2nd method worked cool