option explict

[rhino4eva]

Option Explicit
Dim fileloc As Long
fileloc = "G:\Infection Control\CDRNE\CDRN Prism Data\MLVA data\IC RAW EXPORT TABLE"

I want t use this fileloc string in several subsequent modules but I get an error message

Compile error Invalid outside procedure

Any ideas please

 

[njimack]

Try using
Public fileloc as String

 

[rhino4eva]

sorry that did not help

 

[RoryA]

You can't initialise a variable outside a procedure but it looks like you really want a constant anyway, so:

Public Const fileloc As String = "G:\Infection Control\CDRNE\CDRN Prism Data\MLVA data\IC RAW EXPORT TABLE"

 

[rhino4eva]

RoryA
it works the first time use it but not the next

 

[RoryA]

What exactly does that mean?

 

[rhino4eva]

I have two sub routines in the same module that need to use the same path in different ways

Public Const fileloc As String = "G:\Infection Control\CDRNE\CDRN Prism Data\MLVA data\IC RAW EXPORT TABLE"

works in the 1st sub but not in the 2nd

 

[RoryA]

Post the code please. I'd guess you've declared fileloc in the second routine.