Is there a function to insert the worksheet name into a cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jstokdyk@hotmail.com - 07 Mar 2007 20:50 GMT

I have MS Office Excel 2003.

Reply to this Message

Joel - 07 Mar 2007 21:38 GMT

Your question isn't clear. do you mean to transffer data from Microsfot
works to Microsoft Excel? I dont havve worrks, but check if you can save the
file in .CSV format (commar seperated values). then in excel use data -
Import External data.

On the 1st menu selectt delimited
On the 2nd menu select Delimiters comma

> I have MS Office Excel 2003.

Reply to this Message

Dave Peterson - 07 Mar 2007 21:52 GMT

See Debra Dalgleish's site:
http://contextures.com/xlfaqFun.html#SheetName

> I have MS Office Excel 2003.

Signature

Dave Peterson

Reply to this Message

Harlan Grove - 07 Mar 2007 22:26 GMT

Dave Peterson <peter...@verizonXSPAM.net> wrote...

>See Debra Dalgleish's site:
>http://contextures.com/xlfaqFun.html#SheetName

...

If OP has Excel 2003 and would never be sharing files with users of
Excel 2000 and prior, there's also XLM.

Define WSN as =GET.WORKBOOK(38).

Warning: copying formulas containing names that call XLM functions in
their definitions and pasting into other worksheets will ALWAYS crash
Excel 2000 and prior with complete data loss.

The advantage of GET.DOCUMENT vs CELL("Filename",...) is that the
former works whether the file has been saved or not.

Reply to this Message