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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Dave Peterson said:
See Debra Dalgleish's site:
http://contextures.com/xlfaqFun.html#SheetName
Click to expand...
....

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

naming cells using insert > name> define 2
Function Arguments dialog vanishes when clicked an inserted shape 2
VBA - retrieve data on last create named range from previous inserted named range 0
Insert Named Range Into a Cell 2
Formula, Macro, or VBA code to find and insert 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Function to Insert Text Into a Formula 3
Using Worksheet Name 3

Back
Top