Save xls file as cell value

[Birilac]

Hi, Need to save the file I am working on as the value in one of the cells
(Cell value changes)


Example. The value in cell b109 is "John Dow"

I would like to save the file as John Dow.xls without having to look at the
value in b109

Thanks for the help

Tom

 

[Graham Mandeno]

Hi Tom

I suggest you repost this in one of the Excel newsgroups. This one is for
questions on Microsoft Access, the database application development tool
that is part of the MS Office suite.

I think the answer will probably involve something like:

ActiveSheet.SaveAs Range("B109").Value & ".xls"

 

[Birilac]

oops sorry, meant it for the Excel group... bad fingers

Thanks

Hi Tom

I suggest you repost this in one of the Excel newsgroups. This one is for
questions on Microsoft Access, the database application development tool
that is part of the MS Office suite.

I think the answer will probably involve something like:

ActiveSheet.SaveAs Range("B109").Value & ".xls"

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi, Need to save the file I am working on as the value in one of the
cells (Cell value changes)


Example. The value in cell b109 is "John Dow"

I would like to save the file as John Dow.xls without having to look at
the value in b109

Thanks for the help

Tom