I am trying to automate VC++ build via an addIn written using VB.NEt so that we can schedule it using a simple batch file. This addin performs some custom pre-requisites before the build is started. The build is invoked as devenv.com /useenv %NEWSOLFILE% /CLEAN %BUILDCONFIG% /OUT %OUTLOGFILE% > nul
with appropriate filename substitutions. I am facing problem in the following entry-point:-
[Code]...
make VBE add ins for Office using .Net?Detail:Using Visual Studio 2005 Team Edition targeting the .Net 2.0 platform with C#
View 4 Replies1) Can anyone post a link or tell me the differences between these versions of VISUAL STUDIO please? >>
Standard, Professional, Team Suite, Team Foundation Server Standard & Team Foundation Server WorkGroup Edition
2) I imagine Team Foundation Server WorkGroup Edition is the most expensive and therefore has the most functionality?
3) Are there any others I have not mentioned?
I have VS2005 Team Edition Database Professional installed on my laptop along with VS Team Edition Database Pro, not a problem so far. When I installed the VS2008 we were using SQL Server 2005 as your databases so when asked to the database for database projects I selected my SQL 2005 installation. Now we have moved some of your databases (all new projects) to SQL 2008. When I try and create a Database Schema compare I get an error on Field types (we decided to use Date data type for one field instead of DateTime). I have since installed SQL 2008 Express so that I can create the projects in the 2008 version of SQL Server.
[Code]...
I added the reference and the "Imports" line, and I get the folowing error on the line
Code:
Dim oApp As New Excel.Application
Dim oWB As Excel.Workbook = oApp.Workbooks.Add()
Dim oWS As Excel.Worksheet = CType(oWB.Worksheets(1), Excel.Worksheet)
COMException was unhandled
Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
Since I am new to VB .NET , I would like to ask some general questions about it . Here we go :
[Code]...
When debugging my app it works fine i.e. It gets the two commandline args, through a loop, and execute as expected. However, once I publish it, the app only picks up the first argument, which is the .exe file string. Code below:
Public Sub Main()
Dim args() As String = Environment.GetCommandLineArgs()
Dim n As integer = args.Length
[Code]....
Okay so what I am trying to do is create a textbox that I can use as an equivilent to the run command.So In textbox I can type CMD/batch scripts and have it sent as normal.
View 1 RepliesThis is the command line I want to use inside my VB.NET program. Look for the running process "mpc-hc.exe" and get the commandline of the running processwmic process where name='mpc-hc.exe' get CommandLineI want to retrieve the output from that command into a string. I know that it could be done natively in a VB.NET program and I have looked at how it was done. However, I cannot get the code to perform what it did in the commandline I have above.
View 1 RepliesFor unit tests I would like to mimic different commandline arguments. How do I modify the commandLine args to my program at runtime (looked around but can't find the trick)? Basically I am trying to find a way to modify the contents of the READONLY property Environment.CommandLine.
View 2 RepliesI'm using VB.net to have a GUI on top of a commandline program.
[code]...
Which works and prints out all output from the commandline program. However at some point the commandline program ask for user interaction, eg: Type a number (1/2/3/4):But the commandline program stops after this. I suspect this is because it doesn't receive a valid option.Is there a way to capture when the commandline program wants user interaction and hold the reading of the stream to be able to enable the user to input something?
I am attempting to make a VB commandline application, I did originally write this as a form application. Our server administrator wants this as a commandline application, so I have done the following code:
Imports Microsoft.Office.Interop
Module Module1
Sub Main()
[code].....
i am developing one automate application for tht i hav done some coding i dont know how to proceed further can any one guide me if possible? [code] I am using SHDocVw for IE. Now i need to know how to do. [code]
View 4 RepliesI want to exit my GUI application (vb.net 4) using a commandline parameter.I should send thive! from the commandline:
myapplication.exe quit and an already running instance of the application should exit.
Now, I have a mutex detection in place so that I can only have one instance of the application running at a time. It seems that if I send a commandline, it won't work on an already running application; it will only work on one that is launching.
I've been working on a project that converts several file formats to a PDF in VB.NET/C#. The specific files are DOC, TXT, JPG, TIFF, HTML.
Actually I already have a solution for DOC/TXT to PDF using Bullzip PDF Printer by sending the files to the PDF Printer using VB.NET. However, each time it converts a file, MS Word opens and then closes once the file is sent to the printer. It really slows down the process.
As for TIFF to PDF, I haven't found a solution for it at this time.
I require SDKs or Commandline tools and not PDF convertion applications, since I need to integrate this function in my program. I prefer free or open source SDKs but commercial ones are accepted as well.
I have an application that has file extensions associated with it. The application has been deployed using ClickOnce. I have checked the associations table to confirm the entry is there and the association is to the 'ClickOnce Application Deployment Support Library'. When the application is triggered using a file with my extension, it does not pass the filename / directory in the CommandLine Arguments, instead you get the executable path of the application.
Which is under ..LocalSettingsApp"Random Strings"MyApp.exe
I have checked the Registry entry to confirm what the extension is set to open with and the application is dfshim.dll. Is there a way to overcome this, or is this just another limitation of ClickOnce deployment?
I have commandline strings that contains application paths and might contain arguments. Some examples:
1. "C:Program FilesMicrosoft Officewinword.exe" "C:some dirdocumentname.doc"2. "C:Program FilesSome Dirapp.exe" /dosomething3. C:Program FilesSome Dirsomefile.exe4. C:somedirsomefile.exe /whatever5. C:Windows
otepad.exe6. someapp.exe
I'm looking for a simple way to split the path to the application and the optional argument.Sometimes the string contains quotes around the path (1&2) and sometimes, even when the path contains spaces, the string does not contain quotes(3). And sometimes the string does not contain spaces in the path (4&5&6), but a space is used before the argument(4). And (6) is a executable without a path. I have to use the environmentvariables the find the fullpath of the executable. This string (6) can also have arguments.Is there a standard function available to do this split?
Note:I have a regex pattern to handle (1,2,4,5,6), but is doesn't work for (3), because of the spaces in the path."[ ]+(?=(?:[^""]*""[^""]*"")*(?![^""]*""))"I cannot control the strings. Some of them come from user input and some of them come from the registry.
I am developing an application that will run with a GUI when no commandline args are passed, but can also run invisibly if started from the commandline and passed necessary arguments. I have been asked to include a /version argument that will return a version number. For simplicity this version number can be stored in a variable. Without doing something like writing the version number out to a file, what is the best way for me to return this info to the caller? My app will almost always be started from a script, so the script will have to read the version number and make decisons based on the version.
View 2 RepliesI have written an automation addin in Excel with C# (addin.dll). To use the addin, I need to 1. register it using "regasm /codebase c:...addin.dll"2. select in ExcelOptionsAddInsExcel AddinsAutomation the respective addin from the list
I would like to automatize 1) and 2), so that the user just needs to run an exe-file in order to use the addin. 1) should be no problem, but how can one automatize 2)?
Ok basically what I need to do is the following:Read FirstExcelDoc (attached)For every row in that: Retrieve data from sql server db based on info in the Orange columns of FirstExcelDoc Let's say I retrieved data elements A, B, C, D, and E from sql server. Then I need to enter those same data elements A, B, and C in another excel spreadsheet (which has formulas etc) After inputing A, B, and C in that spreadsheet, read a couple of calculated fields and compare those results to data elements D and E retrieved originally from SQL Server DB. Finally, output the results in the Blue columns of the FirstExcelDoc spreadsheet for that row.Loop through and do the same thing for row 2 of the FirstExcelDoc and keep on until you see "END TEST" in the FirstExcelDoc.
I'm looking for a method of doing this efficiently. I have read several articles over the past few days as well as those from Mike R. but just need some direction to get started on this.To start of I'm looking for whether to read the entire FirstExcelDoc spreadsheet or just read the info for first policy number(2nd row) and process it and write out the blue column info for that row and then loop through and come back and read the second policy number (3rd row) etc... Please attach a code snippet for either way of reading the data.
I'm using excel via interop in application.Sometimes users kill application that created excel instance and that results in excel instance sitting in memory without any chance of disposing it.First I tried to tackle this using ROT(running object table) looks like not all instances of excel are registered there.Than I tried to somehow mark excel process after it is started via interop.[code]This works as long as excel is visible but in my case excel window is invisible.All I need is to somehow mark process that started via automation with the parent PID, so that later I can kill it if parent does not exist.
View 19 RepliesI have successfully automated a PowerPoint Metrics presentation with VB.Net. However, since there were many complicated calculations, it took quite some time to make the 120+ slide presentation - so I recently tried to revamp the application to be multi-threaded.
[Code]...
I've got VS2008 and Office2010, but I don't have Office2007. Therefore, I have the Word14 Object Library but not the Word12 Object Library. Will the code that I create for Office2010 automation also work where clients only have Office2007 or will they have to upgrade their office suites?
View 1 RepliesI have been pulling my hair out trying to fix this.
[Code]....
We have a vb program which is run on our server by scheduled task every day. The program opens about 30 excel files, refreshes the data connections, pivot tables and then saves the document in another location.
This may run fine for a couple days but sooner or later the process starts crashing, usually with this error: RPC_E_SERVERFAULT.
My question is, Is it expected that continually opening/closing/refreshing workbooks will inevitably cause the Excel object to crash at some point.
I once heard about a software that could dynamically run dotnet instructions (C#, if I remember well) on its command line, e.g when entering 1==1, the output would be true.I don't remember the name of this soft, and sometimes one just wants to know the result of a given instruction, without having to create a new program, compiling it and run it...
I would happily take the challenge to make a soft like this on my own later, but for now on I'd just like to find this soft.Does anyone know its name, or another app which would achieve the same result? (Don't tell me PowerShell, I'm searching for something more handy.
EDIT For those who use Visual Studio and who didn't know (I just learnt about it), you can also use the Immediate Window. It even allows you to get intellisense in some cases.
we currently use our own 3rd party customer management system that is cloud-based. They offer pretty good reports; however, we need special reports and the only way to do this is to download our database though web services that the vendor offers. I have some education and experience with programming, but it has been a while. Instead of having to actively engage the webservices directly, our vendor has offered a stepping stone. They have a command line exe that interacts with the webservices and, with the use of different parameters, gets us to the point of having all the data downloaded in xml, csv, or screen printed - the only problem is that it will only do this a table at a time and there are 43 tables I need to interact with. I need to build something that can either be a console application or something that can be run automatically in the middle of the night when there is no load on the server.
Here is what I need to happen:
The command is CMSDownload.exe. It needs to login (again, there are already parameters set up to do this so I can hard code that into the script) Once logged in, the script needs to check a parameter that has been saved that signifies the last date of successful completion. (Obviously, it needs somewhere in the code to place this parameter also). As I mentioned before, each table needs to be downloaded into its own xml file individually. For instance, the following is one example of a table being downloaded in this fashion:
Generate an XML file of all of the data in the accounts table between '01/15/2009 09:13:34 AM' and 01/16/2009.CMSDownload -d somedn -u someusername -p somepassword -f c: empaccounts.xml -m xml -o all -t accounts -s 'start date' -e 'end date'
-d is a login component (credentials)
-u is a login component (username)
[Code]....
I am trying to use the Command Line Arguments during the Form_Load event to load the file a user might have selected in windows explorer.
I have set some file associations during setup, so that any ".script" files will be associated with my application. However, my application can also open other (text based) files (it's a text editor), and I would like the user to be able to use "Open With..." and select my application to open the files in my application directly.
I have to use the Command line arguments for this, which will hold the filename(s) of the selected files, correct?
So I did this:
vb.net
For Each arg As String In Environment.GetCommandLineArgs()
If IO.File.Exists(arg) Then
OpenFile(arg)
End If
Next
Now, when I open a ".script" file, my application opens and the correct file is loaded. However, in addition, the EXE file is also loaded for some reason! It has opened two files, <Applicationname>.EXE and the file I wanted to open. Because the EXE file is obviously not just a text file, it just displays some random characters, but I don't want it to open that of course...
Also, if I run the application in the debugger (visual studio), it opens the <ApplicationName>.vshost.exe file... So I thought, I can check for the extension of the argument, and only open it if it is a ".script" file. BUT I don't want that! I also want the user to be able to select any file and choose Open With... and select my application. That won't work if I check for the file extension...
Where I work we need to rewrite a bunch of tools for a software package called ArcGIS. These tools were written in VB6, by someone who is a very beginner programmer.We need to transition these to .NET in order to work with a new release of the ArcGIS software due to come out soon. I am having trouble convincing the 'powers that be' that we need to take a new approach to the development of these tools. they are all in a single VB Project, but what I want to do is to break these tools up into seperate projects in either VB or C#, compile dll's, and then use them as needed.....more of a 'modular' approach in my eyes. That way many people can develop many tools at the same time.
Can anyone point me to some weblinks or articles on how to properly develop in a team environment so I can try to convince the powers that be that we need to change the way we are doing things.
I'm having an issue where my excel.exe process doesn't close until I close my .net application. I'd like to avoid using Process.Kill() if at all possible.
Code:
Private Sub WriteRowsToXls(ByVal rows As DataRowCollection, ByVal xlsPath As String, ByVal showStatus As Boolean, Optional ByVal AddTotals As Boolean = True)
Dim xlsApp As New Microsoft.Office.Interop.Excel.Application
[CODE]............
This method references a couple of other methods I use for repeated formatting tasks, I'll include those methods below. (I added the FinalReleaseComObject into the other methods after reading Mike's thread but the issue persists)
Code:
Private Sub SetRangeValidation(ByVal rng As Range)
With rng.Validation
.Delete()
[CODE]..............
Method SetRangeAllBorders does about the same as these other methods but my post is too long to add it. The only other things not shown in these code snippets are a few string variable that are defined in the class, studentWS, studentsWSPW, paymentsWS and paymentsWSPW My App creates an instance of the class, loads some data, runs the method above, and then sets the class to nothing. I'm using .NET 3.5 automating Excel 10
