I have a subroutine that passes several variables to the called subroutine.I want one of the variables to be updated by the called subroutine and then check for the change in the calling subroutine. My code works fine except that the variable I am checking
calling Sub routine
Code:
Public Sub ProjectName_Exit(Cancel As Integer)
[code].....
I have been pulling my hair out trying to fix this.
[Code]....
I have a vb.net app that retreives data from a MS SQL 2005 database. I have it creating an Excel 2003 workbook. In a cell of a Worksheet, I want to "Call" or make active my vb.net App via a key combination (Alt->V) and have the workbook/worksheet pass the Row number / Column to the vb.net app that will get the data and post back to this Cell. This combination (vb.net and Excel) is my report builder app. So I want to go back and forth between vb.net and Excel, passing the needed data from each. How can this be done?
View 19 RepliesI have a slight problem , using vb 2008 i have written some code that checks the current datetime on the computer. This gives me the answer in the format mon, tues etc. what i now want to do is to use that to call a spreadsheet dependent on the day of the week. here is my code so far
Code:
Dim TIME As DateTime = DateTime.Now
Dim FORMAT As String = " ddd "
TextBox1.Text = TIME.ToString(FORMAT)
[Code]....
Now i have tried the private sub eg SATS() on a separate button and it works perfectly . so it appears to be that the sub is not been called. I think it is probably a syntax where the datetime answer is not been recognised, in that textbox1.text = "sat" is not the same as datetime = sat .
I have written a macro that is pulling information from a "CapComm" file to a template file. This macro filters (based on a variable in the template file) different sheets in CapComm and pastes them in the appropriate places in the template file. I have no problems with that part of the code.
However, each time the macro is run the file is saved as a different filename. In the code there are several movements from one workbook to the other. Macros have been set up to select the appropriate CapComm file. But.... the template file itself will have a different name each time it is run.
For now, we are using the template file, running the macro and saving it as whatever the filename is to be. Then we open the template file again and repeat the process each time. I want to be able to get the templates current name and set that as a variable so we can use the template file, save it as whatever, use it again, save as whatever, etc instead of having to open the blank template each time.
I have tried declaring a variable and using both thisworkbook and activeworkbook, but when the macro moves to the CapComm file, this becomes the activeworkbook/thisworkbook and i end up with errors. Is there any way to get the name of the file at the start of the macro and keep this as until the macro ends or is run again?
I have written a macro that is pulling information from a "CapComm" file to a template file.This macro filters (based on a variable in the template file) different sheets in CapComm and pastes them in the appropriate places in the template file.I have no problems with that part of the code.However, each time the macro is run the file is saved as a different filename.In the code there are several movements from one workbook to the other.Macros have been set up to select the appropriate CapComm file.But.... the template file itself will have a different name each time it is run.For now, we are using the template file, running the macro and saving it as whatever the filename is to be.Then we open the template file again and repeat the process each time.
I want to be able to get the templates current name and set that as a variable so we can use the template file, save it as whatever, use it again, save as whatever, etc instead of having to open the blank template each time.I have tried declaring a variable and using both thisworkbook and activeworkbook, but when the macro moves to the CapComm file, this becomes the activeworkbook/thisworkbook and i end up with errors.Is there any way to get the name of the file at the start of the macro and keep this as until the macro ends or is run again?
If I use a single variable of type Excel.Worksheet to reference Worksheet1, and then change it to Worksheet2, Worksheet3 and so on, is it adequate to simply do "Marshal.FinalReleaseComObject(worksheetVariable)" once at the end? Or would I be left with some references still in memory? In other words, do I need to do a "Marshal.FinalReleaseComObject" before each re-assignment?
View 3 RepliesIt appears that when one creates an instance of Excel, using CreateObject, (Late binding), the suggested Excel closing function (with GC.collect etc) does not work. I have tried several suggestions, and the only one that works is process.kill method. Do you see any problem in using this? BTW: the reason we are using late binding is that we cannot use Office PIAs....not sure which version of Office would be installed on the client site. We work with O2003, but the client might still be at 2000 or 2002.
View 7 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 RepliesWe 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 was wondering if someone could give me the final explanation on what i might be doing wrong here.I spent a lot of time reading around the net and the forum about how to add Threading capabilities to a VB project.
Nos, i've got .NET 4 installed, and i've added the system.tsr and mscorlib.dll files as reference in, say, Excel 2007 (see screenshot).However, when i try to make a thread with anything as basic as "Dim Thread1 As System.Threading.Thread", i get a user-defined type not found error.Indeed, when i use the object browser to see what's in the System file, theres nothing remotely linked to any Threading, and in the mscorlib file, nothing under "Threading" either, just a few Thread related functions, but nothing defining a data type
I've developed shared addin for Microsoft Word. I distribute this addin with my application and using Inno setup for installation. The Inno setup installs my application and then runs "myAddin.msi" file in order to install addin.
how to uninstall this addin programatically?
Right now, in order to uninstall addin, the user has to to it manually through control panel.
how do i use the webbrowser to display the word or excel docs. just like the pdf viewer... i tried the webrowser1.navigate but it didnot work, if it does its opening a new window, im using office 2010..
View 4 RepliesHow do I use the webbrowser to display the word or excel docs. just like the pdf viewer. I tried the webrowser1.navigate but it didnot work, if it does its opening a new window, I am using office 2010.
View 1 RepliesI've made Add-in for Word 2007 in VS2005.It worked well with Word 2007 and now it works well with Word 2010 32 bit.However it doesn't work with Word 2010 64 bit. The installation is successful, but the ribbon button doesn't show up.
Do you have any experience with add-ins for Office 64 bit?
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
I wrote a simple Automation Addin using VB.NET and .NET 4 and want to distribute it's dll to a
computer with xp sp2 and Office 2007 (Excel 2007) without I install .net on that computer, is it
possible?
This might seem a ridiculous question but I just want to make 100% sure before I start committing any funds to software purchases. Can I use VB2008to develop automation routines to control Office2010 applications or must I absolutely use VB2010 to do so?I ask this because I installed an Office 2010 pro on my station which already has VB2008 and I do not have any Word14 reference in the COM section of the list of references...
View 1 RepliesI have used VB.NET and Microsoft Offices Interop to create an application that will run on a server and will print files for different users.My problem is that I need to find a way to impersonate different users so that when MS Word opens and prints, the resulting print job is recorded under that user. I found this link that lets you run .net code as a different user - unfortunately it doesn't work with this code. The username recorded is still the user that is logged on the server.Code Removed by moderator. Any ideas how I can make the Office app I'm automating run under a different user to the .net program that is calling it?
View 2 RepliesI would like to create Shared add-in that works with Word, Excel, Outlook and Power Point. I've found nice article that provides step by step instruction for creating shared add-in for Word: [URL] I've followed instructions and it worked. However, I am looking for a way to create one add-in that works with Word, Excel, Outlook and Power Point, not only Word. I didn't find any reference on the WEB.
View 7 RepliesI have a class in vb.net defined as public class A
class A is created on Load and gets called once per program loop
The constructor for class A includes the argument (byref Value as long)
I have a global variable called varB that is passed to class A on creation.
now why when varB is altered during the program loop, the change is not reflected within the class?
Just wondering if it's possible to store a reference to an object in a variable.
I will elaborate:
[Code]...
Trying to Automate the VBA code from C#, the existing VBA code is a legacy code which has hundreds of nested calls within.Automate these VBA routines from C# and during the Automation there could be some COM objects which needs to transacted between VBA and C#.COM Objects currently have a Interoperability wrappers to C# and they are being developed in VB and C++?
View 2 RepliesI would like a label to always show the current value of a boolean. This will change a lot of times and would like the label to ALWAYS reflect this.
Is there some kind of way to have the label set to the boolean byref (so its always the same). Currently I'm assigning the label.text = boolean onLoad, so if the boolean changes after that its not reflected.
How would I create a variable and assign it to another variable and when I change one variable it will be changing the other also?
View 3 RepliesI've been researching a problem and am so overloaded I'm really lost now. I have to produce an insane amount of reports at work, different day, times.. You get the point. What I'd like to do is create an application where I can:
The windows application would be running all the time .At specific days and times, the application would sent an MS Excell file in Outlook as an attachment
All automatically. If I can get this working, I plan on adding a GUI to the application allowing many reports, at times and days I can set on the screen.
I'm not even sure if this is even possiable.If my application is too hard for a 5th grader to run, I've made too complicated"