| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i obtain a file name from a cell contents and use it to sa.
I am trying to run a macro to save a file but want to obtain the filename
from the contents of a specific cell |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i obtain a file name from a cell contents and use it to sa.
Activeworkbook.Saves fileName:= Range("A1").Value
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Paul Bond" <Paul wrote in message ... I am trying to run a macro to save a file but want to obtain the filename from the contents of a specific cell |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i obtain a file name from a cell contents and use it to sa.
i think bob has an inadvertent typo in is code
ActiveWorkbook.SaveAs Filename:=Range("A1").Value -- Gary "Bob Phillips" wrote in message ... Activeworkbook.Saves fileName:= Range("A1").Value -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Paul Bond" <Paul wrote in message ... I am trying to run a macro to save a file but want to obtain the filename from the contents of a specific cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need hyperlink function to obtain range name from a cell (contents | Excel Worksheet Functions | |||
| Obtain imported file modified date | Excel Programming | |||
| VBA macro to obtain file names using WIN32 API | Excel Programming | |||
| Trying to save contents of cell as the file name | Excel Programming | |||
| Saving a file(new) using the multiple cell contents as a file name | Excel Programming | |||
![Paul Bond[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
