Save file as File path in Cell 18D

[scottie1]

Hello There

I've got my macro running and then saving the finished file at the end to a specific folder. I did this by putting the file path within my command button_click. Wahat I would like to do is for the macro to find the file path on the actual spreadsheet ie cells(18, 4).

 

[TonyJollans]

Hi scottie1,

In your Command Button Click Event Code, you simply pick up the contents of that cell and place them whereever you previously had the hard-coded value, for example if you had ..

[purple]

myPath = "C:\Documents and Settings\etc"

[/purple]

.. use, instead, ..

[blue]

myPath = ActiveSheet.Range("D18").Value

[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.