I'm trying to create a save button on my infopath form that when clicked, it automatically saves the infopath form to a directory. I'm running into some issues, I thought it would be simple but is quickly becoming confusing. [code] I've tried searching all over but couldn't find an answer that pertained to xml documents such as an infopath form.
View 4 RepliesI have already done the creation of button and the dragging of button at runtime already.But now i need to know how do i save the last dragged button on the form and also detect the name of the last clicked button.so lets say i now drag a button to coordinates 25,254. so when i exit the form and the next time i launch it, the button will still be at 25,254. and this one will go on for the number of button i created like 100. so when i launch the form the 100 button will be at the exact position where i last saved them.the second part is lets say i created button1 and button2 on the form in runtime. so when i clicked the first button, it should display button1. and if i clicked on button 2, it should say button2. same goes for like 100buttons.
[code]...
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 have a Dot Net App thet reads text files, reformats and creates an XL (XML) file.It then opens the XML in XL and Saves it as a '.XLS' file.All works fine when running under Visual Studio in Debug but when the application is deployed it fails the line that does the Save As.I am wondering if it is a permissions problem but not sure where else to look.
The Error is:"System.Runtime.InteropServices.COMException (0x800A03EC): The file could not be accessed. ......"
Here is the code:
Code:
Function SaveAsXL(ByVal stFileXML As String, ByVal stFileXL As String) As Boolean
Dim fSuccess As Boolean = True
Dim stErr As String = ""
[code].....
How to create a button with a MenuStrip option like one in MS-Office "Save As" dialog as below picture?
View 3 RepliesI have used Visual Studio 2008 (VB) to create a custom tab and button group with custom buttons. When any of those buttons are clicked, I simply want to run a macro (add-in) that will already be loaded when Excel is launched. The main examples I've seen create an Excel object in the VB code and then call the macro, but that seems like unnecessary overhead, since the custom buttons are are already loaded into Excel.
[Code]....
how to code for the save button in vb.net datagrid view by using insert into sql and update sql statements (it should be able to insert & update the data grid and save the changes) when the save button is clicked .
View 2 RepliesI have a customer who wants to send emails to his customer and suppliers with confirmation of order, purchase orders etc. instead of printing them and mailing them (postal strikes in the UK, and threats of more).
I have the following code which works on a Vista machine:
Code:
'Created Outlook Application object
Dim OLApp As New Outlook.Application
'Creating outlook Namespace object
[Code].....
It 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 RepliesGiven vba's fairly lamentable image manipulation abilities, I'm considering going down the VB.NET form route. My hope would be to allow some degree of interactive manipulation and then either pass the image back to vba or save it and load it in vba.I'm happy to investigate the latter part of it at length under my own steam - however, I'm not versed enough in VB.NET forms to know if calling them from (in this case) Access VBA is a practical or doable - and whether it's possible to pass data back and forth.
View 9 RepliesOk, what I would like to be able to do seems simple enough. I would like to be able to create an Excel document with a series of columns that contain data to import into Visual Basic 2008
[Code]...
The problem with the following code is that the object oWB is visible and initialized in Form2, but when I show SaveDialog1, the object gives a NullReferenceException. I already know, because I checked in the debugger, that oWB has a valid reference when I leave Form2 and also when I come back from Form2. So I am sure the problem is that the reference simply is not visible in SaveDialog1 for some reason. So please don't tell me that the initialization of oWB returned a Nothing reference because I know it did not.
I get a NullReferenceException on the following line:
Form2.oWB.Save()
I researched this for a whole day and came up with a Microsoft article that explains that it is necessary to run each form of a .NET COM application on its own thread. It gave some code to accomplish this. I incorporated this code into my program. But I still have the NullReferenceException.
Simplified version of Code with most processing deleted below:
Public Class Form2
'Define Microsoft Excel Objects
Dim oXL As Excel.Application
[Code].....
I've created a shared add-in for Office that adds a button to Office application.
If I am using the button to show a message, it works good:
Code:
Sub settingsPressed(ByVal control As Office.IRibbonControl)
MessageBox.Show("Hello")
End Sub
But I am not able to use it for opening Windows form:
Code:
Sub settingsPressed(ByVal control As Office.IRibbonControl)
frmSettings.Show()
End Sub
The .Show() command is not available and is not proposed by intellisense.
Of course I've added a reference to System.Windows.Forms
i made an application in VB2010 where the application should be always on top above one specific window. Anyway i set the property of the main form to "topmost = true". The application is also writing some data to excel which is not a problem but the excel workbook is behind the main form which is on top. Is there any way to put the excel window on top above the main form?
View 1 RepliesNeed to show visio diagram on .net FORM, and need to be able to click on the shapes. Thats it. no creation, no stencils, no editing. Basicly just catch the click event from axDrawingControl.I'm having a "very" hard time to dig trough the visio DOM, disabling all of the functions, tool bars, menus..I basically will ever need a view-only diagram. So, to all the interop gurus out there, point me in the right direction please..I have the SDK, its (crap) not very useful in my case. Seems like a lot of resources wasted and lots of hustle for view only.
View 3 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 am busy with a Windows Forms application.The purpose of the application is to convert Excel documents to HTML format so that they can be published to a website.I have most of the code finished and the application is looking really good.I have although encountered a problem. On the Form I have created an Export, File and Edit button.With the edit button I would like the user to be able to select whether they would like to save the 1st,2nd,3rd sheet and so forth.
I would like to create a window/Form within the edit button that would say something like "select excel sheet" along with a save button where the required sheet number could be saved or selected as a standard save procedure everytime.I know that I need to do this with the settings.settings control. I have tried numerous ideas up until now but it continues to baffle me.
I 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 have a combo box that I want to refresh the data of after the save button is clicked. I know that in web developer you can just say datasource.databind but I do not see that in vb.net.
View 12 RepliesIn my Project I have a Dialog Box (MonkeyList), a Database(MonkeyList.sdf), and DataGridView1. DataGridView1 is on the MonkeyList DialogBox. I want to save changes to the table when OK_Button is clicked.
View 11 Repliesi 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.
experience on how to create an engine using C# (VB.NET is okay too) that is generic enough to handle most cases of MS Word text fields I need to fill with data I'm getting from a database? In short, I'm about to embark on this little Office automation excursion and I'm hoping a little bit of feedback here.
View 2 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?