I'm a novice with macros so this could be completely wrong but it seem
to me that instead of

SavePath = "G:\Labs\Request Form\Database\*"* & Range("v32").Value

it should be

SavePath = "G:\Labs\Request Form\Database\ & Range("v32").Value*"*

I haven't tried that but it's a suggestion...

Also, I'm working on macros to do similar things and have gotten a bi
stumped.

I want me macro to check whether or not the cells it is getting th
filename from actually have anything in them. How would I do this? Do
just put the formula I would use in a spreadsheet to do this

--
sir_gle
-----------------------------------------------------------------------
sir_glen's Profile: http://www.excelforum.com/member.php...fo&userid=1476
View this thread: http://www.excelforum.com/showthread.php?threadid=27256