LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 345
Default #1) value vs. formula #2) personal.xls and xlstart pathway

Hi All -
#1)
I do a lot of character string manipulation in an application. If I'm
dealing with only text in a cell, what are the the practical differences, if
any, among the following ? I don't want to type more than I have to.

stringvar = range("c3")
stringvar = range("c3").value
stringvar = range("c3").formula

#2)
I don't know how to debug a situation that is bothersome.
2a) I know the pathway to the xlstart folder that contains personal.xls
2b) In D:\documents and settings\MyName\Application data\.......\xlstart the
personal.xls file DOES NOT open.
2c) for a different pathway, different desktop, same computer, the only
difference is instead of MyName, its DiffName, the personal.xls file does
open when excel starts.

How do I get 2b) above to work ? I am considering setting up a new desktop
and getting rid of the MyName one that does not appear to work well.

Thanks,
Neal Z.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CAN YOU CREATE A PATHWAY OF CELLS LIKE A PROGRAM Dean Costa Excel Programming 2 March 28th 06 10:31 PM
Vlookup Pathway Daffy Duck Excel Discussion (Misc queries) 5 June 16th 05 08:55 PM
Shortcut to personal.xls in XLStart forlder Jackie Excel Programming 1 November 3rd 04 08:59 PM


All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"