kashif.special2005
Active Member
- Joined
- Oct 26, 2009
- Messages
- 443
Hi,</SPAN>
I have an access tool and from that tool I am opening an excel file and doing something and saving and closing that workbook but my problem is when I am trying to save an excel workbook it is giving me an error message because I have Excel 2010 version and the user is using that automation I don’t know where he is using Excel 2003, Excel 2007 or Excel 2010, it any way to find out that user using which version of excel from Access vba.</SPAN>
after checking the version I can conditionally add that version in the reference.</SPAN>
Please help.</SPAN>
Thanks</SPAN>
Kashif</SPAN>
I have an access tool and from that tool I am opening an excel file and doing something and saving and closing that workbook but my problem is when I am trying to save an excel workbook it is giving me an error message because I have Excel 2010 version and the user is using that automation I don’t know where he is using Excel 2003, Excel 2007 or Excel 2010, it any way to find out that user using which version of excel from Access vba.</SPAN>
after checking the version I can conditionally add that version in the reference.</SPAN>
Please help.</SPAN>
Thanks</SPAN>
Kashif</SPAN>