Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VBA References Problem

I have encountered a problem with referencing. Is it
possible to save references within a excel spreadsheet. So
when you send a spreadsheet to a number of people on
different excel version they I do not encounter
referencing problems.
For example they have Excel8.olb rather than Excel9.olb

Many thanks

Marcus
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default VBA References Problem

The problem is that the references are being saved. You should develop
your workbook in the oldest version and distribute that. Then there would
not be a conflict. Newer versions are smart enough to know about older
versions, but obviously not vice versa.

--
Regards,
Tom Ogilvy

"Marcus" /uk wrote in message
...
I have encountered a problem with referencing. Is it
possible to save references within a excel spreadsheet. So
when you send a spreadsheet to a number of people on
different excel version they I do not encounter
referencing problems.
For example they have Excel8.olb rather than Excel9.olb

Many thank

Marcus



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert all 3d references to normal references in a workboo Dima Excel Worksheet Functions 6 August 8th 08 12:38 PM
Help with converting a block of cells with Absolute and mixed references to relative references Vulcan Excel Worksheet Functions 3 December 13th 07 11:43 PM
Problem with references while opening Excel from IE using UNC path vrkorada Links and Linking in Excel 0 July 6th 07 02:53 PM
How to rename references from range names to cell references Abbas Excel Discussion (Misc queries) 1 May 24th 06 06:18 PM
Problem with VBE Menu -- Tools References JON-JON Excel Programming 1 September 11th 03 07:20 AM


All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"