Read-Only file needs to be Save As to specific folder with Range Name

this code will save the workbook as to the path provided in your first post and the cell in A1's value

Please Login or Register  to view this content.

What does the line

Please Login or Register  to view this content.

refer to?

Nothing... sorry that is from earlier attempts at working on this... it can be removed

Try deleting all of your code so that it looks like this

Sub SaveAS()
'

Please Login or Register  to view this content.

Then try running the macro

I got a run time error 1004
Method 'SaveAS' of object'_Workbook'failed

Can you open an excel document in the path that you are wanting the workbook to be saved an in any cell type

Please Login or Register  to view this content.

then tell me what the cell returns?

\\mspm1bnas04\westc4\Statements_Sent\Aug\[Ohio Valley Medical Center - 1214715.xlsx]formservlet

There's no drive in front of it?
Try changing it to this

Please Login or Register  to view this content.

Now it is just highlighting the cells, nothing else

It's not saving the document to the new location specified?

No nothing other than highlighting the cells around the active cells at the time of the macro run.

Okay try this one, sorry.

Please Login or Register  to view this content.

Still nothing...

what value is in cell A1?

The name of the account, which needs to be the name of the workbook when saved.

Does the name of the account in cell A1 contain any characters that would not be allowed when saving a file name? Such as \ / * ? " < >

Nope, it looks like this "Dhsc Llc - 1155539" though cell A1 is merge & center from A1-I1... would that make a differance?

Hmmm, it shouldn't, I tried on my computer and it seems to work fine.

It has to be something with the filepath that you are supplying.

Do you have Windows on you computer? If so go to the start menu and select Run. Then from the Run window copy and paste the below path into the open box.

Please Login or Register  to view this content.

Then select Okay. This should go to the filepath that you are trying to save your workbook to. Try and find the workbook here.

Is the value in A1 a formula?

No just text

Okay let's try completely readding the code:

1.Press Alt+F8 on your keyboard
2.Clear the macro name box and type NewFile in the blank box provided
3.Select the Create option
4.In between the Sub NewFile() and End Sub copy and paste the following code:

Please Login or Register  to view this content.

Note I changed the xls to xlsm to see if that would make a difference

5.Exit out of the Visual Basic Window
6.Press Alt+F8 again and this time select the NewFile macro
7.Select Run

Yeah, that got us closer!! The workbook saved with the correct name and to the correct file, but it creates a file within the file, not that it is that big of deal I can work around that, I just want to make sure that when I email the workbook out to other people it will read correctly... can we save without the macro enabled?

Try altering the code to look like this

Please Login or Register  to view this content.

And what did you mean by it creates a file within the file?

It saved to the file, but it will not open... I get the filed you are trying to open, is in a different format than specified by the file extension.... I press yes to continute to open the file
Then I get Macros have been disabled. Macros might contian viruses... I click disable Macros button and get nothing...

Hmm.. I just get the first message not the second and the workbook comes up. You might just have to save it as the xlsm. Users can still open it they'll just be asked if they want to enable or disable macros.

Ok, I can work with that.

Thank you!

No problem, sorry I couldn't get it a little farther. Don't forget to mark this thread solved and if I helped maybe give me a little star tap.

Thanks!