Dear everybody:

I want to add a personal.xls to a computer without such a fil
automatically by Excel VBA, the problem is How can it figure out th
location of xlstart folder that is in use?

Looking forward to your help

--
Message posted from http://www.ExcelForum.com

Hi chrisrita,
You can use Application.StartupPath

MP

"chrisrita " a écrit dans le
message de ...
Dear everybody:

I want to add a personal.xls to a computer without such a file
automatically by Excel VBA, the problem is How can it figure out the
location of xlstart folder that is in use?

Looking forward to your help.


---
Message posted from http://www.ExcelForum.com/

Hi ....,
You can let Excel do it for you when you record a macro.
After it has been added it would be like any other open file
(I think, even though it is hidden).

Didn't think you would like that answer so did a quick search
perhaps this posting:
http://groups.google.com/groups?thre...GP11.phx. gbl

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"chrisrita " wrote in message ...
Dear everybody:

I want to add a personal.xls to a computer without such a file
automatically by Excel VBA, the problem is How can it figure out the
location of xlstart folder that is in use?

Looking forward to your help.


---
Message posted from http://www.ExcelForum.com/

Guess my search techniques just failed me. You already
have two good answers before I could say mine stinks.

you people are so kind and really good. thank you a lot. one mor
question to David, can macro automatically make another macro

--
Message posted from http://www.ExcelForum.com

Do you mean to use VBA to create VBA code? If so, see some of the
examples at www.cpearson.com/excel/vbe.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"chrisrita " wrote in
message ...
you people are so kind and really good. thank you a lot. one
more
question to David, can macro automatically make another macro?


---
Message posted from http://www.ExcelForum.com/

Thank's Chip, I'm familiar with your vbe.htm but I guess not that
familiar that that would be the one to look for. I would have known
it would be on your site though.

But looking at why I was specifically asked about how to have a macro
create code, I looked back at the earlier response of mine. So...

Hi Chris/Rita,
By letting Excel do the work for you I meant recording a macro,
where you start recording (a macro) and do the things exactly
like you want the macro to do, and the recorder does everything
(usually) that can get you to the same result if you start with the
same conditions and worksheet data. Unfortunately what is
generated is very specific as exactly which cell is being changed,
moved, etc.

So by letting Excel do most of the work, the purpose is to see
what instructions "might" be used and generally one wants to
make their macro a lot more generic so that it can be used for
a lot of different situations the more general, usually the better,
because it means less work to do in the future.

The real reason I indicated to record a macro though was
so that the personal.xls workbook would be generated for
you in the correct place meaning within the XLSTART directory.

Once you have your personal.xls workbook (mine is actually
named slightly differently), you can add modules and code to that
manually -- that is what I really meant. Information on getting
started with macros in
Getting Started with Macros and User Defined Functions
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Once you started working with macro, you might want something
with additional information in it:
Install Macros and User Defined Functions
http://www.mvps.org/dmcritchie/excel/install.htm

There is another kind of macro that is triggered on an event
such as manually entering data into a cell, switching worksheets,
selecting a cell, double clicking a cell, right-click, and more.
Event Macros, Worksheet Events and Workbook Events
http://www.mvps.org/dmcritchie/excel/event.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chip Pearson" wrote ..
Do you mean to use VBA to create VBA code? If so, see some of the
examples at www.cpearson.com/excel/vbe.htm .

"chrisrita " wrote ...
you people are so kind and really good. thank you a lot. one more
question to David, can macro automatically make another macro?