| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA References
As you may not have the lowest possible version on your own machine it is
best to save the wb without the reference and add the reference in code as posted earlier. RBS "Dave Patrick" wrote in message ... That's why you want to back it down to a version that the clients have. You don't need to write anything. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Jez" wrote: | If I dont have anything and just have the references that are in my | references, then when my clients use the report it comes up with hidden | module error because they dont have the same references as i do. | | I want to write some code so that when the workbook opens it ignores any | references that are "Missing" and choose a lower module. | | What can i write to get around this. | | Thanks, | Jez |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA References
Might be but in a situation where the lowest version on my dev machine (2.0)
is higher than anything on the client I would expect greater problems than this would exist. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "RB Smissaert" wrote: | As you may not have the lowest possible version on your own machine it is | best to save the wb without the reference | and add the reference in code as posted earlier. | | RBS |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA References
Sorry, didn't understand what you were saying there.
RBS "Dave Patrick" wrote in message ... Might be but in a situation where the lowest version on my dev machine (2.0) is higher than anything on the client I would expect greater problems than this would exist. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "RB Smissaert" wrote: | As you may not have the lowest possible version on your own machine it is | best to save the wb without the reference | and add the reference in code as posted earlier. | | RBS |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA References
No problemo
-- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "RB Smissaert" wrote: | Sorry, didn't understand what you were saying there. | | RBS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert all 3d references to normal references in a workboo | Excel Discussion (Misc queries) | |||
| How to convert all 3d references to normal references in a workboo | Excel Worksheet Functions | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| Tools | References - information about references | Excel Programming | |||
Hybrid Mode
