Personal Macro File 2007 Excel

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
 
J

Jim Rech

Personal.xls should be in one of your XLSTART folders. From there Excel
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.
 
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
 
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
| >
| >
| >
 
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?
 
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.
 
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
| >
 
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
 
R

Ron de Bruin

Like Jim say
You probably are not showing hidden folders.
Click to expand...

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?
 
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
 
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?
 
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.
 
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.
 
Top