Can someone tell me what is wrong with this path?

[ThriftyFinanceGirl]

strTemplate = "\\Nas01\dol_exch\Departments\Accounting\Sales Tax\ " & _
"Sales Tax Database\Templates\TourReallocationJE.xlt"

 

[Dorian]

You have embedded spaces in it, which may not be good , depending on how you
will use it. Also your slashes might be the wrong type depending on how you
are going to use it.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Jack Leach]

I think you may have an extra space between Sales Tax and Sales Tax Department

Sales Tax\ " & _
"Sales Tax Database

this portion would translate:

"... Sales Tax\ Sales Tax Database"


though, as Dorian pointed out, you may need to enclose the whole thing
depending on usage:

strTemplate = """\\Nas01\dol_exch\Departments\Accounting\Sales Tax\" & _
"Sales Tax Database\Templates\TourReallocationJE.xlt"""


hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[ThriftyFinanceGirl]

Thanks Jack, the space was the problem... hate it when I miss syntax stuff!