| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
saving w/sheet to different location
Hi I am a complete novice with vba and have a worksheet which I would lik to save to a folder by pressing a command button. The worksheet needs t be saved with the variable contents of cell C2 as the name. I trie recording a simple macro which almost worked but I couldnt get it t "save as" using the variable contents of C2 as the name. Can anybod help me with this please? Thanks Nige -- Nige ----------------------------------------------------------------------- Nigel's Profile: http://www.excelforum.com/member.php...fo&userid=2569 View this thread: http://www.excelforum.com/showthread.php?threadid=47357 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems saving a worksheet with links to a New Location | Excel Worksheet Functions | |||
| Saving Excel in more than one location | Excel Programming | |||
| VBA for saving a file to a specific location | Excel Programming | |||
| Saving in a location | Excel Programming | |||
| Programmatically saving a workbook to a ftp location fails | Excel Programming | |||
![Nigel[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
