using excel from dotnet
in [VB.NET]
|
Prev: Move controls in dialog area
Next: The SetACL problem
From: mp on 8 Feb 2010 21:04 ok, abandoned that one tried the other one and it looks more hopefull it extracted a large number of interop dlls installation instructions in Readme.htm say to use vis studio tools| vis stu ..net command prompt i don't have vis stu, just express am i hosed? is .net command prompt different from regular windows command prompt? thanks mark "mp" <nospam(a)thanks.com> wrote in message news:e7lHJjSqKHA.4284(a)TK2MSFTNGP04.phx.gbl... > Tried to install o2007pia.msi (double clicked) > i get the following error dialog: > > Error 1316. Setup cannot read from the file (path to msi)\PiaRedist.msi. > Check your connection to the network, or Cd-rom drive. For other potential > solutions to this problem, see Setup.chm > > there is no Setup.chm or PiaRedist.msi in the downloaded exe > > anyone know about this one? > thnaks > mark > > "mp" <nospam(a)thanks.com> wrote in message > news:%23RhheZSqKHA.3824(a)TK2MSFTNGP06.phx.gbl... >>I will try the PrimaryInteropAssembly.exe >> Is there a best use practice for where to install them? Windows\System32 >> ? >> I presume if they are compiled into a net dll they don't need installed >> on user machines, just the developer machine? >> >> thanks >> mark >> >> "Sergey Poberezovskiy" <SergeyPoberezovskiy(a)discussions.microsoft.com> >> wrote in message >> news:67D698CB-E5BF-45F0-95BF-75BA7D12346D(a)microsoft.com... >>> 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 >>>> >>>> >>>> . >>>> >> >> > >
From: Sergey Poberezovskiy on 8 Feb 2010 22:56 mp, search for gacutil file on your PC, then update the path to this utility and run register.bat from the extracted folder "mp" wrote: > ok, abandoned that one > tried the other one and it looks more hopefull > it extracted a large number of interop dlls > installation instructions in Readme.htm say to use vis studio tools| vis stu > ..net command prompt > i don't have vis stu, just express > am i hosed? > is .net command prompt different from regular windows command prompt? > > thanks > mark > > "mp" <nospam(a)thanks.com> wrote in message > news:e7lHJjSqKHA.4284(a)TK2MSFTNGP04.phx.gbl... > > Tried to install o2007pia.msi (double clicked) > > i get the following error dialog: > > > > Error 1316. Setup cannot read from the file (path to msi)\PiaRedist.msi. > > Check your connection to the network, or Cd-rom drive. For other potential > > solutions to this problem, see Setup.chm > > > > there is no Setup.chm or PiaRedist.msi in the downloaded exe > > > > anyone know about this one? > > thnaks > > mark > > > > "mp" <nospam(a)thanks.com> wrote in message > > news:%23RhheZSqKHA.3824(a)TK2MSFTNGP06.phx.gbl... > >>I will try the PrimaryInteropAssembly.exe > >> Is there a best use practice for where to install them? Windows\System32 > >> ? > >> I presume if they are compiled into a net dll they don't need installed > >> on user machines, just the developer machine? > >> > >> thanks > >> mark > >> > >> "Sergey Poberezovskiy" <SergeyPoberezovskiy(a)discussions.microsoft.com> > >> wrote in message > >> news:67D698CB-E5BF-45F0-95BF-75BA7D12346D(a)microsoft.com... > >>> 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 > >>>> > >>>> > >>>> . > >>>> > >> > >> > > > > > > > . >
From: mp on 9 Feb 2010 19:32 I was thinking to maybe just install the excel interop (3 or 4 files) rather than register.bat which installs all as far as i could tell from the readme. "Sergey Poberezovskiy" <SergeyPoberezovskiy(a)discussions.microsoft.com> wrote in message news:394857C1-C70F-4B0E-8D93-3E6790405D7B(a)microsoft.com... > mp, > > search for gacutil file on your PC, then update the path to this utility > and > run register.bat from the extracted folder > > "mp" wrote: > >> ok, abandoned that one >> tried the other one and it looks more hopefull >> it extracted a large number of interop dlls >> installation instructions in Readme.htm say to use vis studio tools| vis >> stu >> ..net command prompt >> i don't have vis stu, just express >> am i hosed? >> is .net command prompt different from regular windows command prompt? >> >> thanks >> mark >> >> "mp" <nospam(a)thanks.com> wrote in message >> news:e7lHJjSqKHA.4284(a)TK2MSFTNGP04.phx.gbl... >> > Tried to install o2007pia.msi (double clicked) >> > i get the following error dialog: >> > >> > Error 1316. Setup cannot read from the file (path to >> > msi)\PiaRedist.msi. >> > Check your connection to the network, or Cd-rom drive. For other >> > potential >> > solutions to this problem, see Setup.chm >> > >> > there is no Setup.chm or PiaRedist.msi in the downloaded exe >> > >> > anyone know about this one? >> > thnaks >> > mark >> > >> > "mp" <nospam(a)thanks.com> wrote in message >> > news:%23RhheZSqKHA.3824(a)TK2MSFTNGP06.phx.gbl... >> >>I will try the PrimaryInteropAssembly.exe >> >> Is there a best use practice for where to install them? >> >> Windows\System32 >> >> ? >> >> I presume if they are compiled into a net dll they don't need >> >> installed >> >> on user machines, just the developer machine? >> >> >> >> thanks >> >> mark >> >> >> >> "Sergey Poberezovskiy" <SergeyPoberezovskiy(a)discussions.microsoft.com> >> >> wrote in message >> >> news:67D698CB-E5BF-45F0-95BF-75BA7D12346D(a)microsoft.com... >> >>> 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 >> >>>> >> >>>> >> >>>> . >> >>>> >> >> >> >> >> > >> > >> >> >> . >>
From: mp on 10 Feb 2010 19:34 hmmm, thought I replied the other day but i don't see it. I was thinking of just installing the ones for excel, rather than all of them, which i think the register bat is for. need to study the install instructions some more, but it looks like you're saying i can run gacutil just from a regular command window? "Sergey Poberezovskiy" <SergeyPoberezovskiy(a)discussions.microsoft.com> wrote in message news:394857C1-C70F-4B0E-8D93-3E6790405D7B(a)microsoft.com... > mp, > > search for gacutil file on your PC, then update the path to this utility do you mean change the environment Path to include that folder? i think so > run register.bat from the extracted folder so then i cd to the extracted folder and since i added the gacutil path to env i can run from this folder i think i get it > snip
From: mp on 10 Feb 2010 20:16
ok, i'm not much of a dos guy so not sure what i did wrong I went into command prompt to add the path to gacutil to the path env var. at command prompt i entered Path %Path% C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin according to the help that should have appended the 'PathToGacUtil' to the existing path at the time it returned the whole list with it appended, but the next time i ran Path, it wasn't there at the end of the list ??? when i cd to the extracted folder and enter gacutil -i Microsoft.Office.Interop.Excel.dll i get gacutil not recognized...etc then i check Path and the folder(to gacutil) is not there anymore "Sergey Poberezovskiy" <SergeyPoberezovskiy(a)discussions.microsoft.com> wrote in message news:394857C1-C70F-4B0E-8D93-3E6790405D7B(a)microsoft.com... > mp, > > search for gacutil file on your PC, then update the path to this utility > and > run register.bat from the extracted folder > |