-
- error -2147417851 working with VBA and Word
by Jorge Ubeda
- 6 Replies
- Last post
by Jorge Ubeda
- Hello all
I¡¯m receiving an error -2147417851 when loading an html file to word: here is the code that generates such error:
Set rng = doc.ActiveWindow.Selection.Range rng.InsertFile zzz.htm,, False
Some directions about where locate info about error codes
thaks in advance
Jorge Ubeda
-
- Fine-tuning VBA code
by smurray444
- 0 Replies
- Last post
by smurray444
- Dear all, I hope someone is able to help me with this one. I'm using Excel 2007 to import large text files using VBA code. In the text file I'll tell you a bit more about in a moment, the the first column of numbers are longitude, the second latitude and from there on, data point values. The first problem is that when a very small number is encountered (e.g. 4.2321E-02) in the text file, upon im
-
- LBound and UBound functions
by Keithyboy1
- 7 Replies
- Last post
by Shlizar Axis
- Is there a reference library I need to enable in the VBE to get LBound and UBound functions
They don't appear to exist in the Object Browser with the current reference libraries I have enabled.
Many thanks!
-
- populate text box with combo box selection then be able to edit the text box
by Marti Robinson
- 0 Replies
- Last post
by Marti Robinson
- Here is my problem. I have a combo box that contains a list of all of the road names in my city. I have the code that places whatever my selection is in the combo box into a text box. The problem is that I need the end user to be able to edit the text box after the road name is added ( to be able to add the address digits to the beginning). Any suggestions Thanks ahead.
-
- Problem saving to spreadsheet with Macros in 1 column
by WelshWarrior
- 1 Replies
- Last post
by Bruno Yu - MSFT
- I am displaying info in a DataGridView from a spreadsheet that is then altered using buttons by the user. The spareadsheet is then saved back to the spreadsheet using another button. All this is working fine - no probs.
Problem is that there is a Macro in all of the cells in 1 column that keeps a running total by using the cell comment to store a value to stop circular reference problems. The i
-
- Multi-column List Box with data not from excel spreadsheet
by JBNV123
- 2 Replies
- Last post
by JBNV123
- Hi, I am trying to create a multi-column list box with data that is NOT from an excel spreadsheet. For example, I would want to make a 2 column list box with someone's last name next to their first name: Smith Joe Baker Jeff Jones Bob etc. I want them in two columns but i want to be able to select a single person by selecting a row, ie so that the last and first name are considered a single unit
-
- Toggle button logic problem
by une
- 2 Replies
- Last post
by une
- Here is a little puzzle I cannot solve if you have the time and inclination to look at it. I have 3 toggle buttons whose captions and values I want to be interdependent as follows; *When ToggleButton1 is clicked its caption alternates between ON and OFF and its value between True and False. *When ToggleButton2 is clicked its caption alternates between ON and OFF and its value between True and Fals
-
- this problem is also troubling me now!! :(
by Moim Hossain
- 14 Replies
- Last post
by WebDev2000
- Hello everybody,
I am getting some trouble around SharePoint Object model. I was intended to write a console or windows application that will connect two SharePoint site (One is SharePoint 2003 and the other is SharePoint 2007) and will move/copy documents from one to another. I have tried to connect to the SharePoint 2007 first and it was connecting fine. (I was running my application int
-
- Office Communicator 2005 sign-in name, auto populate after install somehow?
by markm75c
- 14 Replies
- Last post
by Mike@ALS
- Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install..
Basically every user has the same format.. first.lastname@domain for the login.
I'd prefer to find a way to have this info auto entered after the install when it first tries to open.
I'll be using communicator as a "broadcast" method.. and alot of users prob
-
- Configuration Failed
by NaveenPN
- 2 Replies
- Last post
by Mica
- Configuration Failed
One or more configuration settings failed. Completed configuration settings will not be rolled back. Resolve the problem and run this configuration wizard again. The following contains detailed information about the failure: Failed to initialize SharePoint Products and Technologies upgrade. An exception of type System.Collections.Generic.KeyNotFoundException was thrown.Addi
-
- VBA 6.5 New Version?
by GTVic
- 2 Replies
- Last post
by GTVic
- I have loaded Office 2007 and the VBA about screen states version 6.5. Is there any documentation on recent changes to the VBA environment
An older product which includes the VBA environment is not able to launch any VBA macros with Office 2007 installed. The upgrade to VBA 6.5 may be the problem and I would like to find some detailed information on new releases.
Thank you,
Greg
-
- visual Foxpro9 vs VB2005+SQL2005
by johan2000
- 0 Replies
- Last post
by johan2000
- Hi All, Can someone pointed any info about comparing VFP9 to VB2005+SQL2005 For writing an accounting program (GL, AP, AR, STOCK, etc) which one will be better for the developer Why please also briefly explain flexy Gird in VB2005 (yes there is in VFP9) thanks so much! have a nice day! Johan
-
- Merry Christmas and Happy New Year
by Derek Smyth
- 3 Replies
- Last post
by RhysDavies
- This is the forum I've maybe spend the most time in, although not so much recently but that can't be helped. To everyone who posts here often enough to know my name, and to anyone else to happens to read this... have a great Christmas and New Year... and even if you don't celebrate them I hope you enjoy the holidays.
-
- Need some opinions on these 2 books plz
by D00zer
- 0 Replies
- Last post
by D00zer
- Hi everyone,
Hope to learn a lot from these forums here! I need some advice...I have VB programming experience and the law firm I work at need some additions to MS Word. Im gonna get stuck into VBA, but have never used it before. I understand it comes standard with Office XP...so thats fine.
I am thinking of purchasing these 2 books. Are they good and will they be enough to start me
-
- TextAlign in a Listbox from Access 2000 (not Microsoft Forms 2.0)
by Jo&#22
- 2 Replies
- Last post
by João Rodrigues
- Hi all, does anybody know if the property TextAlign in a Listbox from Access 2000 (not Microsoft Forms 2.0) WORK At Rowsource i'vd tried numeric fields , text fields ... change the format property of the fields, even tried a value list instead of a SQL string in the rowsource... nothing work's to align RIGHT !!! I also tried to use the format function in the SQL string .... Can someone help
-
- The specified module could not be found??
by magicalclick
- 1 Replies
- Last post
by magicalclick
- I have this "The specified module could not be found" issue. Can anyone help me
I code my program in VBA Excel 2003, and reference the Outlook 2003 to send email. However, I got this "The specified module could not be found" error when I try to do this
set myOutlookObject = new Outlook.Application
or
set myOutlookObject = CreateObject("Outlook.Application"
-
- Norton 2007 - slow running and iE unable to connect to the net
by spanna
- 2 Replies
- Last post
by spanna
- Hi
Was wondering if there is any one that can help. I installed norton 2007 on my laptop. The laptop is now running really slow and interent explorer is is unable to connect to the net. I have rest interent options, removed cookies and temporty internet files, disabled add-on's.
Is there any ideas how to resolve this problem
Thanks
-
- Network Interface Card (NIC) Enable/Disable programatically in VB 6
by Gilbee
- 1 Replies
- Last post
by Cringing Dragon
- Hi All I have 2 NIC in my pc and one Virctual NIC I want to Programatically (visual Basic 6) enable and disable these nic, if you have any idea please share with me any clue also welcome. programm codes are most welcome. gilbee
-
- New Combo Box problem
by Techgrrl
- 2 Replies
- Last post
by Vamsi025
- Well, here I am again....
Problem this time is, here is my code:
Private Sub ComboBox1_Change()
ComboBox1.AddItem "No leaks detected" ComboBox1.AddItem "No leakage or adverse damage detected" ComboBox1.AddItem "The entire contents of the packaging were retained"
End Sub
With just these 3 entries listed to add in the cbo, It is duplicating, o
-
- How to Get Position of Scribble line's Points?
by Sstar
- 4 Replies
- Last post
by Sstar
- I have scribble line object in my Ms Word document.
Shape.Type = msoFreeform
Now I want to get position of the controls points and change it slightly. How can I get the controls points' position in the first place.
I noticed that
Shape.ShapeNodes.SetPosition ( index, x, y)
helped me to set position of each node. However, no ShapeNodes.GetPosition functio
-
- Possible to run code after Word closes?
by saep
- 5 Replies
- Last post
by saep
- Hello,
I have a macro that saves the current word document on the users c:\ and then emails it to me. I am aware of the kill function to delete a file, but I would need to close the file first in order to delete it - which can easily be done in the macro. But it appears that once Word closes the macro stops running.
Thanks for any help!
-
- duplicating VBA objects
by gilad_gy
- 4 Replies
- Last post
by gilad_gy
- Hi all,
on a form, i've got 10 textbox in a row. lets say that i've got x rows. the user need x+1 rows. how do i add the last row thanks.
-
- Dynamic Lists in Excel
by SHolst22
- 4 Replies
- Last post
by suna2006
- I created a list in Excel as described in http://www.contextures.com/xlDataVal02.html
I want to have the following structure of dependant list.
List 1
List 2: Contents dependant on List 1
List 3: Contents dependant on List 2
List 4: Contents dependant on List 3
List 5: Contents dependant on List 1
I created List 1-4 using the method described in http://www.con
-
- XP style appearance
by 9_Phill
- 3 Replies
- Last post
by Anonymous1988
- hiya this might be the wrongplace to ask this question but on the computer the other day one of my kids deleted the windows xp appearance so all we are left with now is the rubbis windows classic appearance which is very boring i was wondering if anyone knew how you can reinstall or download the windows xp style appearance
thanks phill
-
- Newbie in VBA Drag and Drop..
by den2005
- 8 Replies
- Last post
by den2005
- Hi,
Do not know if this is possible drag and drop effect of items in dropdown control inside a word application
The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done
Thanks in advanced.
den2005