File path ERROR

hey there. i have some VB code used in an MS Access database that strings a file path to save my query results in excel on my c drive.

the file path is defined as follows: Const FILE_PATH As String = "C:\Reporting\mdb- ad hoc rpting\Program\Cost Reports"

when i run the code the export completes but does not save in the correct location (ie the file path above). in fact, it saves to my defualt folder under "C:\Documents and Settings\tuk tuk\My Documents".

any ideas?

You probably need to make the resulting string be quoted, since you have spaces in the path.

Try Const FILE_PATH As String = """C:\Reporting\mdb- ad hoc rpting\Program\Cost Reports"""

Still no go. I tried to cut the file path down and only go from my """C:\Repporting""" and it still defaulted to the same location that i stated previously.

My path to get to my C-drive is the same and all other machines i've been on..namely....Desktop\My Computer\local disk (C.

Might i need to set a reference in my coding/MS VBA??????

I appreciate you help.
T

Put in a breakpoint and step through your code with the debugger.