Hi Brian,
Thanks very much for your ideas. I really appreciate your help. I have tried what you suggested with success! Duane Birnbaum, the author of the book replied to me along similar lines.
What I did was copied and pasted the code to a new workbook using the move/copy command in Excel...
Thanks once again for your help Brian.
The answers to your questions are:
1. Office 2000 Pro
2. I am using Excel 2000 (9.0.4402 SR-1) and opening the VB Editor either via the toolbar in design mode or Alt+F11.
3. The main ones checked are the same as yours except that they are version 9.0...
Thanks very much for your response Brian. I have tried this and no go. It appears to be looking for the references in C:\Program Files\Microsoft Visual Studio\Vintdev98 and C:\Program Files\Microsoft Visual Studio\VB98\VB6.OLB which I suspect would be there if I installed Visual Studio which I...
I am studying Excel VBA Programming from the book "Microsoft Excel VBA Programming for the Absolute Beginner" - the book is good but some of the projects included will not run as there are missing references such as "LCase" and "Format" with the message "Can't...
I am studying Excel VBA Programming from the book "Microsoft Excel VBA Programming for the Absolute Beginner" - the book is good but some of the projects included will not run as there are missing references such as "LCase" and "Format" with the message "Can't...
I am studying Excel VBA Programming from the book "Microsoft Excel VBA Programming for the Absolute Beginner" - the book is good but some of the projects included will not run as there are missing references such as "LCase" and "Format" with the message "Can't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.