I am trying to create a userform in MS Word. I have a text box, a set of 3 option buttons and a command button in it. I want that on clicking the command button, the text in the text box and the option button selected by the user should automatically get displayed on header or footer of the word document (active document).
View 1 RepliesI have a Macro that prints Sales Vouchers, is it possible to attach the userform to an Email or write it to a file for later attaching to an email or even send the UserForm to Word again the aim is to transmit the voucher electronically rather than paper. My code at the moment is very simple: UserForm2.PrintForm which prints the form. I tried printing to a file but couldn't get it to work. I am guessing that printing to a file is for Text only and not bit by bit.
View 5 RepliesThe following code allows words to be added to a listbox. Add the word to a text file and create a folder with the word as its name. The second part undoes the actions.If I try to delete the word immediately after adding it one of two things happen.
1.An error is reported stating the path cannot be found. Although the listbox index value is correct according to the code the error is pointing at that index +1.
2.The code continues to the point of requesting conformation to delete the folder, still pointing at the index value +1. I the action is confirmed the wrong folder is deleted.
However if I stop debugging, then run the code again all works correctly.Is it likely to persist when the application is compiled?
Imports System.IO
Public Class Form1
Dim pathlist As String = "M:Visual Studio 2008ProjectsEnvironment and Conservation GlossaryEnvironment and Conservation GlossaryGlossary List.txt"
[code]....
I am trying to end all running macros, but also keep my userform up and it will not work. If you know anything that will work or if there is another way to reactivate a userform
'mycode
End
Userform1.show
end sub
I am trying to return to a module from a userform and I cannot figure out how to do it. My program is set up so that the module will call userforms at various times to collect/display information but then I want to return to the module after each userform has done its job, and I want to return to the next line of code in the module.[code]
View 2 RepliesI have the following form:I want to join the boxes so that it looks like this: would rather create the lines on the userform manually but I do not think there is a way to do it. I've tried the following code but I cannot see the line:
Private Sub DrawLine(ByVal X_From As Integer, ByVal Y_From As Integer, ByVal X_To As Integer, ByVal Y_To As Integer, _
ByVal Line_Width As Integer, ByVal Line_Colour As System.Drawing.Color)
[code]....
I don't know where this fits so moderators go easy. I've been trying to enter a text box on this site using a form made with Visual Studio 2010. See here for the site. I have the following
[Code]...
I've been using VBA quite a bit in the past to build userforms in Access, that used user-supplied data to custom-build sql statements on the fly, query data from a linked table, read that data into variables, perform calculations and spit out results onto the userform. Now I'm wanting to do some similar things in vb.net 2008.
I would use some code like this:
Set MyRecordset = New adodb.Recordset
MyRecordset.Open "SELECT * FROM Table1", CurrentProject.Connection, adOpenDynamic, adLockOptimistic
MyRecordset.Filter = "ID = '" & Me.cmbAgentName.Value & "'"
With MyRecordset
[Code] .....
Whenever I try this, I get an error message along the lines of "Conversion from type 'Field' to type 'String' is not valid."
so yesterday this code was working for my userforms and today its not. Its a simple clear command for textboxes and comboboxes. what is from here?
Dim ctl As Control
ForEach ctl In Controls
IfTypeOf ctl Is TextBox Then ctl.Text = ""
IfTypeOf ctl Is ComboBox Then ctl.Text = ""
Next ctl
How to use a vba userform to input a number to the excel file and get another number from that excel file back to the userform?!! (such as input value to A1 and collect C1 back to userform). Beside is that possible to open another excel file via ComboBox and input the number (C1) to that particular excel file...
View 4 RepliesWhat I'm trying to create is a drawing program and I need to create a document like in word. So everytime you start a new document you can create one and switch between them.I think that I have to create a MDI form and the new child forms are the new documents. But what to create to draw on.Or can I do it with a tabcontrol and the tabpages are the new documents.But again what to create to draw on.
View 10 RepliesI have some data in the database and i need to create a pdf document dynamically for
creating a report based on the information in the database in a presentable format for the one who checks it
How can i create a toolbar in MS WORD as such :This is picture :
View 11 RepliesI am using vb.net to create a Word table. Everything works fine, except that it is very slow. It takes about 0.34 seconds to create each cell in the table. I am using an HP machine with i7 processor and 12 GB of RAM. At 0.34 seconds per cell, times 7 columns, times 189 rows ~ 7.5 minutes to create a small table! I must be doing something wrong, but I have no idea what it could be. The table looks looks fine.
My code looks something like this:
oWord = DirectCast(CreateObject("Word.Application"), Word.Application)
oWord.Visible = False
oDoc = oWord.Documents.Add(ClsGUIGlobal.TIMBERSCHEDULEWORDTEMPLATEPATH)
[code].....
We want to create a letter in GIF format with below attributes of GIf file.
Non-Interlaced GIF (CompuServe) 89a
2 colors (1-bit)
Horizontal Resolution 96 dpi
[code].....
i need to create word document with 3 lines like this include 1 picture
Name1 Name2 Name3
here Picture Department
position1 position2 position3
the picture in 100*100 size i need to show in the word document 50*50
I am in the process of writing a win forms desktop app in VB.net that employs user data in the form of rich text, stored internally as an object and then serialised to an XML file for persistent storage purposes.
To create the user data (the application's "document" it might be called), I have written a seperate app that tries to be a word processor and then saves the text in my XML format that can then be opened and used in the main app.
Is there a way I can use Word to do this? Perhaps by writing an add-in or template? Just to clarify, the format of the rich text would just be a table, I then need to save this in my XML format, or save the text as my object then serialize it to file.
I am able to create simple image with text, but I want to apply MS Word Art font to my text.here is my code to create image with Text.
Font MyFont = new Font(FontFamily, Font,FontStyle.Bold, GraphicsUnit.Point);
MyGraphics = Graphics.FromImage(bmpImage);
MyGraphics.Clear(Color.FromName(Convert.ToString(Request.QueryString["bgColor"])));
MyGraphics.TextRenderingHint = TextRenderingHint.AntiAlias;
MyGraphics.DrawString(sImageText, MyFont,
[Code]...
Im trying to start a report that will generate a new word document and fill it with all the relevant bits and pieces im trying to figure out the relevant reference to add to the project but nothing springs to mind when im browsing through the references folderiv seen this and tried it and unfortunatly it doesnt work it says doesnt contain any public members or cannot be found
View 1 RepliesIs possible to create a Printer drop down box like ms word, actually i need the icon of the installed printers on that system, because i have already got the printer collection from "System.Drawing.Printing.PrinterSettings.InstalledPrinters"
View 1 RepliesI am creating an application using VB 2005. I am using richtextbox control to get some text and do some text formating like bold, italics and font like stuff.
Now i want to save the richtext (formated) text to a word file with specific page margins, header and footer texts. And also to save the file with a supplied password.
I have tried the simplest method of rtf
[Code]...
I have spent hours to get my requirements to work. AS this is my first of this kind, i cannot firureout how to add header , footer, set margins and save file to specific location WITH password., Simply Need to know basic vb2005/vba options.
I'm getting started with VB 2008 and was wondering which control I can use to create a Toolbar within a windows form title bar, as MS Word 2007 does?
View 5 RepliesI am trying to make my program print out a requistion slip but I don't want to make a report using VB b/c sometimes the printer is not connected and it is better to have a Microsoft Word document and save it as such. So how do I create a Word application from VB? I basically am going to set out a format, make a small table etc. and then whatever the user types in the textbox, it will appear in the slip. (I am using Word 2003)
View 1 RepliesQuestion:Is it possible to make a userform transparent but have non-transparent controls?I notice changing the opacity of the userform will change the opacity of controls embedded on it.
View 9 RepliesIn my VB.Net app, I want to read in a load of addresses from a database and then use word to create address labels on an Avery template L7163 which is then printed to the printer.
However, I have two issues:
1. Before word prints, I'm asked to select the printer etc. not exactly the nice automated application I was looking for.
2. Even though I get a nice printed out doc I was looking for, I also get a nasty looking error at the end which "loops" until I close my app -2147417848: The object invoked has disconnected from its clients. (Exception from HRESULT: 0x800010108(RPC_E_DISCONNECTED))
Here is my code:
CODE:
I adapted the code for the actual mail merge by recording a Macro in Word As I manually ran one so I thought it would be ok.
Ex. my word doc is "123456789@abcde" i want my range is "abcde".
View 4 RepliesProblem: Your task is to take input from the user in string and give the following options to the user in a menu.
1- Find a String
2- Create sub-string
3- Erase a portion of a sting
4- Replace a word in the string
5- Count number of words and characters in the string without spaces.
6- Capitalize first character of each new sentence and convert the rest
of the characters to lower case.
7- Sort all the words in alphabetical order. (Use Bubble sort algorithm to perform sorting).
To perform all the above mentioned tasks you can only use pointers. Create a function to perform every task.
I'm trying to create a table in Word using data from a table in Access. There are four fields in the access table that I need. 3 fields are text which I can populate the Word without any issues. However the fourth field is a memo with >255 characters.I'm struggling to come up with the proper code to allow me to populate the Word field with the memo data that has more than 255 characters. The code I have so far is listed below. But when it hits the memo field, it crashes on the line I marked with **. I know it's not text, but I've tried many different field types, but nothing has worked so far.[code]...
View 1 RepliesWhat I would like to do is create a command button that launches an email from outlook attaching the current word document to a set email address. I'm not fussed if the word document is saved or not as it is only the email receipent that needs it, likewise I don't mind if the code instructs the email to send of just opens it ready to be sent.I have read through loads of forums and tried loads of codes but cannot get any to work.
View 3 RepliesBasically in visual basic 6 I could access word tables in existing templates with the code owordactivedoc.tables(1).select() where owordactivedoc refers to the active word document and tables(1) refers to the first table in the template.Trying the same code in VB 2003 just leads to errors. Secondly how do I access bookmarks or alternatively word variables.Furthermore how do one deploy web.services. For example the current program I am building is for another computer. Simply copying the web service to Inetpubwwwroot dont work because it is not picked up by the Internet Information Services program. I have to create the web service in vb2003 on the other computer change msconfig manually. Copy and paste the existing service vb file in the created folder replacing the empty vb file.
View 3 Replies