| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
file name on worksheet
Hello. It has been a while since working with vba in excel so I am rusty. I
have created a pivot table using vba language but would like to add the file name in cell A1. I have been able to have a title written inside the vba using the Activecell.formulaR1C1, but would prefer to put the file name in there instead. The language is currently able to be used with any open workbook. Can anyone help in solving this as I am at a loss? Thanks to anyone responding. *** John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet to new file | Excel Discussion (Misc queries) | |||
| copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
| Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
| File opens as worksheet.xls:1 and worksheet.xls:2. Only one exist | Excel Programming | |||
| open file dialog-select file-import worksheet | Excel Programming | |||
Threaded Mode
