| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Migrating modules from 98 to XP
I have several VB modules that I have tried importing into an XP/Office 2003 environment, but can't get them to stay. In my old 98/Office 98 environment, the modules were always there, when I opened a new file (PERSONAL.XLS), or any other file. How do I get my modules to always be available whenever I open Excel. Final note, when I imported them, I went to the VB editor to make sure they were there, and made sure that the "Macros In" had checked "Open in all Workbooks" As always any help is appreciated MK -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Migrating modules from 98 to XP
What/where is ... "Macros In" had checked "Open in all Workbooks"
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mkingsley" wrote in message ... I have several VB modules that I have tried importing into an XP/Office 2003 environment, but can't get them to stay. In my old 98/Office 98 environment, the modules were always there, when I opened a new file (PERSONAL.XLS), or any other file. How do I get my modules to always be available whenever I open Excel. Final note, when I imported them, I went to the VB editor to make sure they were there, and made sure that the "Macros In" had checked "Open in all Workbooks" As always any help is appreciated MK -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Migrating modules from 98 to XP
Once Excel is open, and I have successfully imported the macro. I choose (in Excel) ToolsMacroMacros. And a window pops up showing all macros. this window has the pull down menu: "Macros In", to choose: Open in all workbooks This workbook Book1 I have chosen "Open in all workbooks" because I want all macros available no matter what Excel file I open. thanx Bob Phillips Wrote: What/where is ... "Macros In" had checked "Open in all Workbooks" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mkingsley" wrote in message ... I have several VB modules that I have tried importing into an XP/Office 2003 environment, but can't get them to stay. In my old 98/Office 98 environment, the modules were always there, when I opened a new file (PERSONAL.XLS), or any other file. How do I get my modules to always be available whenever I open Excel. Final note, when I imported them, I went to the VB editor to make sure they were there, and made sure that the "Macros In" had checked "Open in all Workbooks" As always any help is appreciated MK -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Migrating modules from 98 to XP
Oh I see, that only determines which macros are shown in the list, not where
they can be run from. If you run macros in another workbook, you have to qualify with that workbook name, or set a reference to it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mkingsley" wrote in message ... Once Excel is open, and I have successfully imported the macro. I choose (in Excel) ToolsMacroMacros. And a window pops up showing all macros. this window has the pull down menu: "Macros In", to choose: Open in all workbooks This workbook Book1 I have chosen "Open in all workbooks" because I want all macros available no matter what Excel file I open. thanx Bob Phillips Wrote: What/where is ... "Macros In" had checked "Open in all Workbooks" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mkingsley" wrote in message ... I have several VB modules that I have tried importing into an XP/Office 2003 environment, but can't get them to stay. In my old 98/Office 98 environment, the modules were always there, when I opened a new file (PERSONAL.XLS), or any other file. How do I get my modules to always be available whenever I open Excel. Final note, when I imported them, I went to the VB editor to make sure they were there, and made sure that the "Macros In" had checked "Open in all Workbooks" As always any help is appreciated MK -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Migrating modules from 98 to XP
Thats probably the question I should have asked. So how do you set a reference to the macros, and where are the macros actually stored?? Thanx for the help so far Mkingsley Bob Phillips Wrote: Oh I see, that only determines which macros are shown in the list, not where they can be run from. If you run macros in another workbook, you have to qualify with that workbook name, or set a reference to it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mkingsley" wrote in message ... Once Excel is open, and I have successfully imported the macro. I choose (in Excel) ToolsMacroMacros. And a window pops up showing all macros. this window has the pull down menu: "Macros In", to choose: Open in all workbooks This workbook Book1 I have chosen "Open in all workbooks" because I want all macros available no matter what Excel file I open. thanx Bob Phillips Wrote: What/where is ... "Macros In" had checked "Open in all Workbooks" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mkingsley" wrote in message ... I have several VB modules that I have tried importing into an XP/Office 2003 environment, but can't get them to stay. In my old 98/Office 98 environment, the modules were always there, when I opened a new file (PERSONAL.XLS), or any other file. How do I get my modules to always be available whenever I open Excel. Final note, when I imported them, I went to the VB editor to make sure they were there, and made sure that the "Macros In" had checked "Open in all Workbooks" As always any help is appreciated MK -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Migrating modules from 98 to XP
That depends upon where you store them. Most people will put them in their
Personal.xls workbook. In Excel, you can then reference functions like =Personal.xls!myFunc(A1) to access them in VBA, use Application.Run "Personal.xls!test_msgbox" or set a reference to the project via ToolsReferences in the VBIDE. You might need to rename the project (in Properties) to access it in the list. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mkingsley" wrote in message ... Thats probably the question I should have asked. So how do you set a reference to the macros, and where are the macros actually stored?? Thanx for the help so far Mkingsley Bob Phillips Wrote: Oh I see, that only determines which macros are shown in the list, not where they can be run from. If you run macros in another workbook, you have to qualify with that workbook name, or set a reference to it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mkingsley" wrote in message ... Once Excel is open, and I have successfully imported the macro. I choose (in Excel) ToolsMacroMacros. And a window pops up showing all macros. this window has the pull down menu: "Macros In", to choose: Open in all workbooks This workbook Book1 I have chosen "Open in all workbooks" because I want all macros available no matter what Excel file I open. thanx Bob Phillips Wrote: What/where is ... "Macros In" had checked "Open in all Workbooks" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mkingsley" wrote in message ... I have several VB modules that I have tried importing into an XP/Office 2003 environment, but can't get them to stay. In my old 98/Office 98 environment, the modules were always there, when I opened a new file (PERSONAL.XLS), or any other file. How do I get my modules to always be available whenever I open Excel. Final note, when I imported them, I went to the VB editor to make sure they were there, and made sure that the "Macros In" had checked "Open in all Workbooks" As always any help is appreciated MK -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 -- mkingsley ------------------------------------------------------------------------ mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291 View this thread: http://www.excelforum.com/showthread...hreadid=554961 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Public, Private, Event modules, Forms modules,,, | Excel Programming | |||
| Basic question - modules and class modules - what's the difference? | Excel Programming | |||
| When to code in sheet or userform modules and when to use modules | Excel Programming | |||
| migrating program to wp | Excel Programming | |||
![mkingsley[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
