Error in Save As

Greetings, gurus.

I'm trying to create a macro that will take a worksheet from an Excel workbook, and save it as a text file, with the name determined from user input, and the location being the desktop of the currnet user's computer.

First I use a function, (provided by RoyUK), to get the name of the current desktop, then I try to use that name, along with my user input, so save the file. Obviously, it's not working, or I wouldn't be here. I get a "Run-time error '1004': The file could nto be accessed". I think it's just a syntax issue with the file name, because debug takes me to the "SaveAs" portion of the macro. Please look this over and see where i've missed it. Thanks in advance ofr any help you can offer.

Please Login or Register  to view this content.

It seems to me like your GetDesktop function already provides the directory at the beginning and a "/" at the end. Why don't you debug.print your save as filename before using the saveas method to see what you are inputting as your filename.