| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying code
New to VBA so ...
I have copied some of the great code from CPearson.com. If I open a new workbook and add the code to a new module. it works for that workbook (only). What I want to do is add it to personal.xls so it works in all workbooks. I can't get this to happen. I add a new module to personal.xls, copy the code and it doesn't work. Other macros that I have in Personal.xls work fine in all books. Any ideas? Thanks. WAL50 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying code
What is "doesn't work"?
Error message? Incorrect results? Nothing? If you copied a Function from Chip's site and placed it in your Personal.xls you have to preface the Function like so or you will get the #NAME? error in the cell. =Personal.xls!Function() If not a Function, but a Sub then tell us which one from Chip's site. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 13:56:02 -0700, wal50 wrote: New to VBA so ... I have copied some of the great code from CPearson.com. If I open a new workbook and add the code to a new module. it works for that workbook (only). What I want to do is add it to personal.xls so it works in all workbooks. I can't get this to happen. I add a new module to personal.xls, copy the code and it doesn't work. Other macros that I have in Personal.xls work fine in all books. Any ideas? Thanks. WAL50 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying code
"doesn't work" is a frequently used term meaning "this should be working but
I have no idea why it doesn't". Anyway, you resolved my problem (#Name). Thanks. WAL50 "Gord Dibben" wrote: What is "doesn't work"? Error message? Incorrect results? Nothing? If you copied a Function from Chip's site and placed it in your Personal.xls you have to preface the Function like so or you will get the #NAME? error in the cell. =Personal.xls!Function() If not a Function, but a Sub then tell us which one from Chip's site. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 13:56:02 -0700, wal50 wrote: New to VBA so ... I have copied some of the great code from CPearson.com. If I open a new workbook and add the code to a new module. it works for that workbook (only). What I want to do is add it to personal.xls so it works in all workbooks. I can't get this to happen. I add a new module to personal.xls, copy the code and it doesn't work. Other macros that I have in Personal.xls work fine in all books. Any ideas? Thanks. WAL50 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying code
On Fri, 08 Sep 2006 14:15:02 +0100, wal50
wrote: "doesn't work" is a frequently used term meaning "this should be working but I have no idea why it doesn't". That's the obvious part Anyway, you resolved my problem (#Name). Thats what was wanted in the first place Thanks. WAL50 Glad it works Steve "Gord Dibben" wrote: What is "doesn't work"? Error message? Incorrect results? Nothing? If you copied a Function from Chip's site and placed it in your Personal.xls you have to preface the Function like so or you will get the #NAME? error in the cell. =Personal.xls!Function() If not a Function, but a Sub then tell us which one from Chip's site. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 13:56:02 -0700, wal50 wrote: New to VBA so ... I have copied some of the great code from CPearson.com. If I open a new workbook and add the code to a new module. it works for that workbook (only). What I want to do is add it to personal.xls so it works in all workbooks. I can't get this to happen. I add a new module to personal.xls, copy the code and it doesn't work. Other macros that I have in Personal.xls work fine in all books. Any ideas? Thanks. WAL50 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying code
In addition, the frequently used term "doesn't work" is a non-descriptive term
which is of absolutely no use to anyone attempting to troubleshoot a problem. I guessed and this time was lucky. Gord On Fri, 8 Sep 2006 06:15:02 -0700, wal50 wrote: "doesn't work" is a frequently used term meaning "this should be working but I have no idea why it doesn't". Anyway, you resolved my problem (#Name). Thanks. WAL50 "Gord Dibben" wrote: What is "doesn't work"? Error message? Incorrect results? Nothing? If you copied a Function from Chip's site and placed it in your Personal.xls you have to preface the Function like so or you will get the #NAME? error in the cell. =Personal.xls!Function() If not a Function, but a Sub then tell us which one from Chip's site. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 13:56:02 -0700, wal50 wrote: New to VBA so ... I have copied some of the great code from CPearson.com. If I open a new workbook and add the code to a new module. it works for that workbook (only). What I want to do is add it to personal.xls so it works in all workbooks. I can't get this to happen. I add a new module to personal.xls, copy the code and it doesn't work. Other macros that I have in Personal.xls work fine in all books. Any ideas? Thanks. WAL50 Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inactive User - Code Oddity (actually bizarre) | Excel Discussion (Misc queries) | |||
| Can someone help me put psuedo code into actual excel macro?? | Excel Discussion (Misc queries) | |||
| Complicated If Then / V Lookup / Match Statement... | Excel Worksheet Functions | |||
| Need 2 add second then third code with first code in the Tab View | Excel Worksheet Functions | |||
| Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Linear Mode
