View Single Post
  #2   Report Post  
Posted to microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming
Sergey Poberezovskiy Sergey Poberezovskiy is offline
external usenet poster
 
Posts: 5
Default using excel from dotnet

You should use XP PIAs:

http://support.microsoft.com/kb/328912

and reference them from your project - this way your application will run
just fine on any PC that has XP or later Office

Hope this helps

"mp" wrote:

situation:
I'm working on a new app in vbexpress 2008 using acad com interop
Also need to write extracted data to excel.

problem:
At home(laptop) i have excel 10. At the office excel 12.
(both seem to have excel5 listed in refs.)

I need to work at both locations.
can i reference both 10 and 12 in the same vbproj (i think not)

can i just reference 5 and is that just an older version with common (but
not the latest) interface?

i guess i can just have 2 vbproj files (one on laptop one at work) and just
copy the .vb class files that are being edited back and forth, not copy the
vbproj file back and forth?

I think the dotnet project is dynamic(using actual disk copy of files when
opened) - as opposed to vba which copies the disk file contents into the dvb
and then the disk files are not updated when the modules in the dvb are
edited unless you do a manual export? so i think just updating the .vb files
should work fine?

any tips?
thanks
mark


.