R
Renee
How do I get my Personal Marcro file to open automatically when I open
another Excel file? I am using Windows Vista & Excel 2007
another Excel file? I am using Windows Vista & Excel 2007
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Rech
Personal.xls should be in one of your XLSTART folders. From there Excel
automatically opens it when it starts.
automatically opens it when it starts.
R
Renee
I can't seem to find my XLSTART folders. I looked at where it was on Windows
XP but Vista doesn't seem to have the same folders.
XP but Vista doesn't seem to have the same folders.
D
Dave Peterson
Open xl2007
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
?application.startuppath
For me (xl2007, but WinXP Pro), I see:
?application.startuppath
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
?application.startuppath
For me (xl2007, but WinXP Pro), I see:
?application.startuppath
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART
J
Jim Rech
I'm not running Vista but I would hope that a Find for XLSTART would be
successful. There are 2 such folders on my XP machine, one under the Office
installation folder that applies to all users who log on, and one where your
personal settings are kept (under Documents and Settings under Windows XP).
You can use either.
Another option is to specify the folder you want to act like XLSTART. Say
you put your Personal.xls in a folder named C:\MyPersonal. Click the Office
button in the top left corner of Excel. Then Excel Options near the bottom
right of the Office menu. In the Advanced section scroll down near the
bottom and where it says "At startup open all files in:" enter
C:\MyPersonal. Every file in this folder should open with Excel.
--
Jim
|I can't seem to find my XLSTART folders. I looked at where it was on
Windows
| XP but Vista doesn't seem to have the same folders.
|
| "Jim Rech" wrote:
|
| > Personal.xls should be in one of your XLSTART folders. From there Excel
| > automatically opens it when it starts.
| >
| > --
| > Jim
| > | > | How do I get my Personal Marcro file to open automatically when I open
| > | another Excel file? I am using Windows Vista & Excel 2007
| >
| >
| >
successful. There are 2 such folders on my XP machine, one under the Office
installation folder that applies to all users who log on, and one where your
personal settings are kept (under Documents and Settings under Windows XP).
You can use either.
Another option is to specify the folder you want to act like XLSTART. Say
you put your Personal.xls in a folder named C:\MyPersonal. Click the Office
button in the top left corner of Excel. Then Excel Options near the bottom
right of the Office menu. In the Advanced section scroll down near the
bottom and where it says "At startup open all files in:" enter
C:\MyPersonal. Every file in this folder should open with Excel.
--
Jim
|I can't seem to find my XLSTART folders. I looked at where it was on
Windows
| XP but Vista doesn't seem to have the same folders.
|
| "Jim Rech" wrote:
|
| > Personal.xls should be in one of your XLSTART folders. From there Excel
| > automatically opens it when it starts.
| >
| > --
| > Jim
| > | > | How do I get my Personal Marcro file to open automatically when I open
| > | another Excel file? I am using Windows Vista & Excel 2007
| >
| >
| >
R
Renee
So that all worked fine and it showed me where the file is but when I go into
my windows explorer to copy my old personal macro file to this new file I can
not find the AppData folder under my user name. All I have under this folder
is:
Contacts
Desktop
Documents
Downloads
Favorites
Links
Music
Pictures
Saved Games
Searches
Videos
Any idea how I can find the AppData folder?
my windows explorer to copy my old personal macro file to this new file I can
not find the AppData folder under my user name. All I have under this folder
is:
Contacts
Desktop
Documents
Downloads
Favorites
Links
Music
Pictures
Saved Games
Searches
Videos
Any idea how I can find the AppData folder?
R
Ron de Bruin
In Vista
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTART
Note: Ron is the username in the path above
See also
http://www.rondebruin.nl/personal.htm
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTART
Note: Ron is the username in the path above
See also
http://www.rondebruin.nl/personal.htm
D
Dave Peterson
Go through the VBE stuff one more time.
But this time, select that long path and copy it to the clipboard.
Then hit flying windows r (to see the start|run menu)
paste this long path into that "open" dialog box
and hit enter.
Microsoft doesn't want you to see these important files/folders (unless you
toggle a setting). You could type it in yourself (in the address bar) or paste
it in, too.
But this time, select that long path and copy it to the clipboard.
Then hit flying windows r (to see the start|run menu)
paste this long path into that "open" dialog box
and hit enter.
Microsoft doesn't want you to see these important files/folders (unless you
toggle a setting). You could type it in yourself (in the address bar) or paste
it in, too.
J
Jim Rech
You probably are not showing hidden folders. In Windows Explorer, under
Tools and then Folder Options there is an option on the View tab to show
them. At least in XP but likely Vista too.
--
Jim
| So that all worked fine and it showed me where the file is but when I go
into
| my windows explorer to copy my old personal macro file to this new file I
can
| not find the AppData folder under my user name. All I have under this
folder
| is:
| Contacts
| Desktop
| Documents
| Downloads
| Favorites
| Links
| Music
| Pictures
| Saved Games
| Searches
| Videos
|
| Any idea how I can find the AppData folder?
|
| "Dave Peterson" wrote:
|
| > Open xl2007
| > Hit alt-f11 to get to the VBE
| > hit ctrl-g to see the immediate window
| > type this and hit enter:
| > ?application.startuppath
| >
| > For me (xl2007, but WinXP Pro), I see:
| >
| > ?application.startuppath
| > C:\Documents and Settings\(username)\Application
Data\Microsoft\Excel\XLSTART
| >
| >
| >
| > Renee wrote:
| > >
| > > I can't seem to find my XLSTART folders. I looked at where it was on
Windows
| > > XP but Vista doesn't seem to have the same folders.
| > >
| > > "Jim Rech" wrote:
| > >
| > > > Personal.xls should be in one of your XLSTART folders. From there
Excel
| > > > automatically opens it when it starts.
| > > >
| > > > --
| > > > Jim
| > > > | > > > | How do I get my Personal Marcro file to open automatically when I
open
| > > > | another Excel file? I am using Windows Vista & Excel 2007
| > > >
| > > >
| > > >
| >
| > --
| >
| > Dave Peterson
| >
Tools and then Folder Options there is an option on the View tab to show
them. At least in XP but likely Vista too.
--
Jim
| So that all worked fine and it showed me where the file is but when I go
into
| my windows explorer to copy my old personal macro file to this new file I
can
| not find the AppData folder under my user name. All I have under this
folder
| is:
| Contacts
| Desktop
| Documents
| Downloads
| Favorites
| Links
| Music
| Pictures
| Saved Games
| Searches
| Videos
|
| Any idea how I can find the AppData folder?
|
| "Dave Peterson" wrote:
|
| > Open xl2007
| > Hit alt-f11 to get to the VBE
| > hit ctrl-g to see the immediate window
| > type this and hit enter:
| > ?application.startuppath
| >
| > For me (xl2007, but WinXP Pro), I see:
| >
| > ?application.startuppath
| > C:\Documents and Settings\(username)\Application
Data\Microsoft\Excel\XLSTART
| >
| >
| >
| > Renee wrote:
| > >
| > > I can't seem to find my XLSTART folders. I looked at where it was on
Windows
| > > XP but Vista doesn't seem to have the same folders.
| > >
| > > "Jim Rech" wrote:
| > >
| > > > Personal.xls should be in one of your XLSTART folders. From there
Excel
| > > > automatically opens it when it starts.
| > > >
| > > > --
| > > > Jim
| > > > | > > > | How do I get my Personal Marcro file to open automatically when I
open
| > > > | another Excel file? I am using Windows Vista & Excel 2007
| > > >
| > > >
| > > >
| >
| > --
| >
| > Dave Peterson
| >
R
Renee
I have tried searching for XLSTART and it comes up with nothing but I will
try the option of creating my own folder. Thanks
try the option of creating my own folder. Thanks
R
Ron de Bruin
Like Jim say
In Vista
Open a folder
Click on Organize
Folder and Search options
View...Check : Show Hidden files and folders
You probably are not showing hidden folders.
In Vista
Open a folder
Click on Organize
Folder and Search options
View...Check : Show Hidden files and folders
R
Renee
Thank you, I didn't realize that some of the folders would be hidden.
New question now: How do I convert my Macro file from Excel 97-2003 to Excel
2007?
New question now: How do I convert my Macro file from Excel 97-2003 to Excel
2007?
R
Ron de Bruin
Hi Renee
Click on the Office Button (round circle on the left of the Home tab)
And use Convert or SaveAs to save the workbook in the new format
Click on the Office Button (round circle on the left of the Home tab)
And use Convert or SaveAs to save the workbook in the new format
R
Renee
Wow that convert work so easily. Thank you. How do you get the personal
marco file to open but stay hidden upon openning?
marco file to open but stay hidden upon openning?
R
Ron de Bruin
What to do if your PERSONAL.XLS(B) is visible
When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.
Excel 97-2003: Window>Hide
Excel 2007 : On the View tab in the window group choose Hide
Then close Excel and say Yes to save the changes to your PERSONAL file.
When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.
Excel 97-2003: Window>Hide
Excel 2007 : On the View tab in the window group choose Hide
Then close Excel and say Yes to save the changes to your PERSONAL file.
R
Renee
Perfect. Thank you for all your help on my many question.
R
Ron de Bruin
You are welcome
D
Dave Peterson
You may want to turn off that setting now that you're done with it. Sometimes,
those hidden files/folders are nicer hidden.
those hidden files/folders are nicer hidden.
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.