export excel macros  
Author Message
Job





PostPosted: Mon Aug 30 10:55:21 CDT 2004 Top

Excel Misc >> export excel macros

I am gettting a new computer from my IT staff this week. Is there a way to
backup all my personal macros. I have done a search for personal.xls and
have not come up with anything. Can anyone provide answers.

Brad Wilson


Excel8  
 
 
Frank





PostPosted: Mon Aug 30 10:55:21 CDT 2004 Top

Excel Misc >> export excel macros Hi
search for your personal.xls in your xlstart folder

--
Regards
Frank Kabel
Frankfurt, Germany



> I am gettting a new computer from my IT staff this week. Is there a
> way to backup all my personal macros. I have done a search for
> personal.xls and have not come up with anything. Can anyone provide
> answers.
>
> Brad Wilson

 
 
Brad





PostPosted: Mon Aug 30 11:33:02 CDT 2004 Top

Excel Misc >> export excel macros I did and I can't find it.


> Hi
> search for your personal.xls in your xlstart folder
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
>

>> I am gettting a new computer from my IT staff this week. Is there a
>> way to backup all my personal macros. I have done a search for
>> personal.xls and have not come up with anything. Can anyone provide
>> answers.
>>
>> Brad Wilson



 
 
Gord





PostPosted: Mon Aug 30 14:41:59 CDT 2004 Top

Excel Misc >> export excel macros Brad

When you open up a session of Excel is your Personal.xls opened hidden and
your macros are available?

If so, you have one somewhere.

Go to Windows Explorer and Tools>Folder Options>View and make sure "show all
files" is checked.

If not, perhaps your macros are in some other file not named Personal.xls.

Which file(s) open when Excel starts?

Hit ALT + F11 to get to the Visual Basic Editor screen.

Hit CRTL + r to open the Project Explorer.

What do you see listed there?

Gord Dibben Excel MVP




>I did and I can't find it.


>> Hi
>> search for your personal.xls in your xlstart folder
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>>
>>

>>> I am gettting a new computer from my IT staff this week. Is there a
>>> way to backup all my personal macros. I have done a search for
>>> personal.xls and have not come up with anything. Can anyone provide
>>> answers.
>>>
>>> Brad Wilson

>

 
 
Dave





PostPosted: Mon Aug 30 17:07:10 CDT 2004 Top

Excel Misc >> export excel macros Another option:

Open excel
hit alt-f11 to goto the VBE
hit ctrl-r to see the project explorer
verify that personal.xls was opened.

hit ctrl-g to see the immediate window.
type this and hit enter:

?workbooks("Personal.xls").fullname
or for just the path:
?workbooks("Personal.xls").path




>
> If your personal.xls is open, but hidden go to Window, Unhide, Personal.xls.
> Once it is unhidden click Save As. Don't save, but look at the path Excel
> pulls up in the dialog box. It's possible that you're company specifies a
> path for you on the network rather than your workstation. This should point
> you to it.
>

>
> > Brad
> >
> > When you open up a session of Excel is your Personal.xls opened hidden and
> > your macros are available?
> >
> > If so, you have one somewhere.
> >
> > Go to Windows Explorer and Tools>Folder Options>View and make sure "show all
> > files" is checked.
> >
> > If not, perhaps your macros are in some other file not named Personal.xls.
> >
> > Which file(s) open when Excel starts?
> >
> > Hit ALT + F11 to get to the Visual Basic Editor screen.
> >
> > Hit CRTL + r to open the Project Explorer.
> >
> > What do you see listed there?
> >
> > Gord Dibben Excel MVP
> >


> >
> > >I did and I can't find it.


> > >> Hi
> > >> search for your personal.xls in your xlstart folder
> > >>
> > >> --
> > >> Regards
> > >> Frank Kabel
> > >> Frankfurt, Germany
> > >>
> > >>

> > >>> I am gettting a new computer from my IT staff this week. Is there a
> > >>> way to backup all my personal macros. I have done a search for
> > >>> personal.xls and have not come up with anything. Can anyone provide
> > >>> answers.
> > >>>
> > >>> Brad Wilson

> > >
> >
> >

--

Dave Peterson