I work alot with the visual basic used by MS Office at my work, and recently started taking a visual basic class. As a result of this class, I've started working with visual basic.net.What I was wondering was... can I export the forms I make in VB.Net into the Microsoft Visual Basic used by MS Office? How would I go about doing that?
View 2 RepliesHow do I import data in Excel from a CSV file using C#? Actually, what I want to achieve is similar to what we do in Excel, you go to the Data tab and then select From Text option and then use the Text to columns option and select CSV and it does the magic, and all that stuff. I want to automate it.
[Code]...
have a code with a progressbar to import data from text file. My problem is after first loop, a progressbar gets error.
Code:
Sub import_mgf()
Progressbar.Show vbModeless
Progressbar.Caption = "Process status"
[Code].....
Ok, 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]...
I want to try VB.net and i want to know if the forms in Access 2007 can be imported to VB.net?
View 2 RepliesI wrote a program for my company and it imports a .csv file i then split it by the ,. My problem that I now see at the end of the project is that 98 out of 1400 items have, in the descriptions that im seperating. This creates a problem when search for items. My question is is there a way to use more then just one char to split it? i was thinking of splitting using ",".
View 11 Replieswhen I try to import an image into the forms background the form turns white ( I want another color ) and when I move controls around the pictures of the controls stay the screen. How can i fix this?
View 3 RepliesI am using VB for developing a GUI. I need to display charts in the VB form. How do I invoke Excel 2003 using VB and import the charts created in it.
Steps:
1) Getting input from the user using VB form and processing it in VB or external application such as Matlab.
2) Over-Write the processed data in excel sheet.
3) Modify the charts based on the new data which I believe will happen automatically.
4) Display the chart in the VB form.
I got one problem. I did simple listview-saver, (with 1 line) and all working (import, export)...
But i want to add new colums. But I don't know how to export or inport them.
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
TextBox4.Text = TextBox1.Text & vbNewLine & TextBox2.Text & vbNewLine & TextBox3.Text & vbNewLine
Dim str(3) As String
Dim itm As ListViewItem
[Code]...
This code is with adding items to colums, but it saving only first item from line. Anybody know how to export and import all items from line?
Is there any possibility to access directly from a Windows form created in VB.net a protected Excel file? I mean, that the password for opening xls file to be stored in VB.net Windows form. I also have the same problem for a Microsoft Access protected file.
View 2 RepliesWe have currently upgraded our development machines to Windows 7 and Office 2007. We have a vb 2008 app that references 2003 Office components to use for mail-merging to word.We loaded up our app in the vb environment today and were instantly greeted with missing components/functions which are related to the 2003 Office components. We can update these to use the Office 2007 components/functions instead, however we are unsure whether after doing this our vb app will work with machines only with Office 2003 on. can machines with Office 2003 on work with our vb app that references Office 2007 components?
View 5 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.
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 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 RepliesSo I have this error.
[Code]...
So I'm guessing it has something to do with the fact that I don't have office loaded on my computer. Now I have another laptop, with office that I loaded this project on, and it works fine. So do I have to load office on this computer, or can I just reference something?
[Code]...
I want to write a program in vb2008 that can import a text file into a Access 2000 database, but using import specifications already in the access database.
View 2 Repliesi have this problem i would want to solve urgently...when i import a picture into my picture box in vb.net using this code
[Code]...
The img_large_watermarked.jpg image shows up on successful submission...i also want to change that too..cos as soon as i moved systems it could not detect C:Documents and SettingsstanleyMy DocumentsMy Picturesimg_large_watermarked.jpg and that caused errors.
With the following imported namespaces in my project :
Imports System.Windows.Forms
Imports System.Reflection
.. I cannot add..
[code].....
I have a program in VB.NET 2005. At some point I have to open an Access2003-Application for getting data in it. I do that by pretending my program is a human user and let it do all the work in Access as a human user would do. Filling Fields, pressing buttons etc. I use the Primary Interop Assemblies for that. So far so good. That code is in use for over half a year now. In the last week I got Office 2007 installed on my machine. Of course I tested the installed version of my program if everthing still works. Every test was succesfull. But if I do the same tests in Visual Studio it always crashes.
All I get is this Errormessage: {"Das COM-Objekt des Typs "Microsoft.Office.Interop.Access.FormClass" kann nicht in den Schnittstellentyp "Microsoft.Office.Interop.Access._Form3" umgewandelt werden. Dieser Vorgang konnte nicht durchgefhrt werden, da der QueryInterface-Aufruf an die COM-Komponente fr die Schnittstelle mit der IID "{66B22FB4-F70E-4F03-A00A-F76E9ADBBF10}" aufgrund des folgenden Fehlers nicht durchgefhrt werden konnte: Schnittstelle nicht untersttzt (Ausnahme von HRESULT: 0x80004002 (E_NOINTERFACE))."}
For all who can't read german:
"Microsoft.Office.Interop.Access.FormClass" can't be converted in to "Microsoft.Office.Interop.Access._Form3" ... Interface is not supported.
Code I use:
Dim access As Microsoft.Office.Interop.Access.Application = Nothing
.
.
.
access = New Microsoft.Office.Interop.Access.Application()
[CODE]...
The Error occurs when I try to access any property of "access.Forms("frmTest")"
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 RepliesBasically I've coded an Excel 2007 project in VB.NET 2010 that allows you to create charts with a fair amount of interactivity. I want the user to be able to save and reopen this workbook and still have that interactivity in any already-created charts, so they don't have to re-create them.
When I create the charts, I use Sheet1.Controls.AddChart(...), which returns a Microsoft.Office.Tools.Excel.Chart with which I can handle events and such. However, when I reopen the file and look through the Sheet1.Controls collection, there are no Chart objects. Accessing the charts through Sheet1.ChartObjects.Chart gives me Interop Charts, when I need the Tools Charts.
is there away in VB to get all the office key's there are used on a PC
View 2 RepliesI have to import an csv file to SQL database table which already created (empty and has the same number of named columns). It would be great if you could suggest any tutorials or give some tips.
View 1 Repliesi have a dll for a device. i want create a dll which will be able to call the device's dll and perform the operations. how can i access all functions of the device in new dll. iwant this in VB
View 2 RepliesI would like to import a VB.net dll into C++/CLI. I am having trouble referencing my dll. I have tried to find tutorials but with no luck, in particular, I usually find how to import managed libraries directly into native code through COM. I would like to import an existing VB.net dll into my C++/CLI project.
Do I require a header file or a declaration file to import and use my vb.net dll?[code]...
Is it possible to install OCR only even without MS Office Applications installed on my machine? bacause I really need OCR for my application written in vb.net 2003. On the machines with MS Office 2003, it works fine but when I installed the application on my server, I can't preview the contents on my file like .docx, .xlsx, .pptx and .pdf files.
View 10 Replies