The specified module could not be found??

Visual Basic for Applications (VBA)

Index ‹ Microsoft ISV

- Previous
  - 1
    - SAP Hiii Supriya, Seems you are understanding very well. I am doing a very small project in SAP in a company but I have faced with huge amount of information. SAP is really broad and no one can cover it all. Imagine you have a certificate by now and you are looking for a job. The first thing a company will ask you will be your experience. I also want to get the certificate in SAP but which one ABAP Programming, Business Intelligence, SAP Business Warehousing (BW), SAP Supply Chain Management (SCM), SAP Project Management (PM), SAP Security, etc. You see...there are a lot of areas to work on. So, you have got to think about your interests. I do not know what is your degree or education but you should start somewhere. Then day-by-day you will learn how to find your way. India is the center of IT, so you can find a lot of SAP experts in this country. Go out, talk to them, network, question them, ask them for a help, ask them HOW they are SAP experts, what they have done, how they have done it. Then do the same thing, and in near future you will be a SAP Expert. I do the same thing my friend, I am also confused because IT is really broad. When you know IT, you are happy that you can work everywhere but you are confused because you don't know where ! Just get started!...actually you did, so keep it on, in SAP Forumes you can learn a lot, explore the forumes, see the problems and solutions, ask the experts, and you will see. By the way, I recommend you to have a deep look at www.sap.com. See what business they are doing, how they do, and of course WHY ...maybe in future you can do the same thing. SAP is not the way to grow up, it is just a tool to make it happen. Companies like Accenture, uses SAP as a solution for industry or enterprises. If it fits, they implement it; and if it is not they use other software or applications like Cognos, Oracle, etc. If you have any other questions, just post it. You should always ask questions, never mind if it is stupid or not. But always search on your own to get the vision. I will do my best to answer your questions, and I really don't mind if it sounds so easy! Yours, Tantani Tag: The specified module could not be found??
  - 2
    - error -2147417851 working with VBA and Word The error is as you might expect is vague and unhelpful. The server threw an exception Tag: The specified module could not be found??
  - 3
    - Fine-tuning VBA code 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 import to Excel, the 'number' is imported into the correct cell, yet the E-02 is put into the adjacent cell, causing the number to be split up - this also causes subsequent values to be shifted one cell further along than they should be. I was wondering therefore if there's a way of keeping the E-02 attached to the end of the number. I've noticed that in the text file sometimes there is a space between the number and the E-x part (most often for the latitude and longitude values) with often no space for the data point values. Any suggestions are of course welcome on how to get round this! The second problem is a bit of an odd one. Upon import of the data, the final cell of each row and positions in the dataset where there is meant to be no value (ie. a blank cell), a question mark in a box appears (this doesn't appear in the text file). I'm wondering whether this is meant to be some kind of carriage-return marker or something akin to this. Anyway, I thought it would be easy to remove, just using find and replace to make the cell blank once more - however, as this isn't a text character, it won't let me copy and paste it into the find/replace box. So I'm a little confused how to get rid of this. Each text file is around 300MB (told you it was a large import!), so I've uploaded a smaller sample one to www.megaupload.com in case you need to have a look - it's still quite big mind you. To view it, please go to the following website: http://www.megaupload.com/ d=6NN199FN and enter in the anti-spam code in the top-right corner. The code as it stands is as follows: '"Text Files (*.txt),*.txt Option Explicit Sub LargeFileImport() Const MaxRows As Long = 1048576 'Dimension Variables Dim ResultStr As String Dim FileName As String Dim FileNum As Integer Dim Counter As Double Dim num() As Variant Dim v As Variant, i As Long, j As Long Dim s As String, sChr As String Dim rw As Long 'Ask User for File's Name FileName = Application.GetOpenFilename( _ FileFilter:="Text Files (*.txt),*.txt") 'Check for no entry If FileName = "" Then End 'Get Next Available File Handle Number FileNum = FreeFile() 'Open Text File For Input Open FileName For Input As #FileNum 'Turn Screen Updating Off 'Application.ScreenUpdating = False 'Set The Counter to 1 Counter = 1 'Loop Until the End Of File Is Reached s = "" rw = 1 Do While Seek(FileNum) <= LOF(FileNum) 'Display Importing Row Number On Status Bar ' Application.StatusBar = Debug.Print "Importing Row " & _ Counter & " of text file " & FileName 'Store One Line Of Text From File To Variable ResultStr = Input(1000, #FileNum) 'Store Variable Data Into Active Cell For i = 1 To Len(ResultStr) sChr = Mid(ResultStr, i, 1) If Asc(sChr) = 10 Then If Len(Trim(s)) > 0 Then v = Split(Application.Trim(s), " ") ReDim num(LBound(v) To UBound(v)) For j = LBound(v) To UBound(v) num(j) = v(j) Next ' Change 'rw' no. to alter import starting column Cells(rw, 1).Resize(1, _ UBound(v) - LBound(v) + 1) = num rw = rw + 1 s = "" Erase v If rw > MaxRows Then ActiveSheet.Next.Select rw = 1 End If End If Else s = s & sChr End If Next 'Increment the Counter By 1 Counter = Counter + 1 ' If Counter > 1E+307 Then ' Exit Do ' End If 'Start Again At Top Of 'Do While' Statement Loop 'Close The Open Text File Close If Len(Trim(s)) > 0 Then v = Split(Application.Trim(s), " ") ReDim num(LBound(v) To UBound(v)) For j = LBound(v) To UBound(v) num(j) = CSng(v(j)) Next ' Change 'rw' no. to alter import starting column Cells(rw, 1).Resize(1, _ UBound(v) - LBound(v) + 1) = num rw = rw + 1 s = "" Erase v If rw > 1048576 Then ActiveSheet.Next.Select rw = 1 End If End If 'Remove Message From Status Bar Application.StatusBar = False End Sub Many thanks for your time and effort, I appreciate it. Best wishes, Steve Tag: The specified module could not be found??
  - 4
    - LBound and UBound functions Andy Pope wrote: Hi, I believe those functions are in the Visual Basic for Applications library. Although not exposed via the object browser. Are you not able to use these functions I haven't tried using them yet, but since I could not find them in the object browser or help files, I assumed they resided in another .dll, which I would need to enable. Tag: The specified module could not be found??
  - 5
    - populate text box with combo box selection then be able to edit the text box 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. Tag: The specified module could not be found??
  - 6
    - Problem saving to spreadsheet with Macros in 1 column 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 info saves back into this cell from VB but the macro seems to not work properly in that only the last value saved it shown. My code is: Code Block Public Class frmViewer Dim excelCon2 As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=S:\SanctionsDb\2007-08\points.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=0""") Dim da2 As New OleDb.OleDbDataAdapter("Select * from [Points$] where ClsGrp Like '" & ClsGrp & "'", excelCon2) Dim ds2 As New DataSet Public Sub frmViewer_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim count As Integer count = 0 ' count amount of pupils in class lblForm.Text = ClsGrp da2.Fill(ds2) DataGridView1.DataSource = ds2.Tables(0) DataGridView1.Columns("StudID").ReadOnly = True DataGridView1.Columns("StudID").Width = "50" DataGridView1.Columns("StudName").ReadOnly = True DataGridView1.Columns("ClsGrp").ReadOnly = True DataGridView1.Columns("ClsGrp").Width = "45" DataGridView1.Columns("Pastoral").ReadOnly = True DataGridView1.Columns("Assessment").ReadOnly = True DataGridView1.Columns("Assessment").Width = "70" DataGridView1.Columns("House").ReadOnly = True DataGridView1.Columns("SessionTotal").ReadOnly = True DataGridView1.Columns("SessionTotal").Width = "90" DataGridView1.Columns("Target").ReadOnly = True DataGridView1.Columns("Target").Width = "70" DataGridView1.Columns("CumTotal").Width = "70" 'DataGridView1.Columns("CumTotal").ReadOnly = True DataGridView1.Columns("OnTrip").ReadOnly = True DataGridView1.Columns("OnTrip").Width = "70" DataGridView1.CurrentCell.Value = Nothing For Each row As DataGridViewRow In DataGridView1.Rows count = count + 1 Next lblTotal.Text = count 'add the count to the label Dim update As New OleDb.OleDbCommand Dim sb As New System.Text.StringBuilder("update [points$] SET ", 1024) 'assume StudID as the primary key For Each c As DataColumn In ds2.Tables(0).Columns If Array.IndexOf(New String() {"StudID", "Target", "SessionTotal", "OnTrip"}, c.ColumnName) = -1 Then sb.AppendFormat("[{0}] = ,", c.ColumnName) update.Parameters.Add(String.Format("@{0}", c.ColumnName), OleDb.OleDbType.VarWChar, 255, String.Format("{0}", c.ColumnName)) End If Next If sb.Chars(sb.Length - 1) = ","c Then sb.Remove(sb.Length - 1, 1) 'put the primary key in WHERE clause sb.Append(" WHERE StudID = ") update.Parameters.Add("@StudID", OleDb.OleDbType.VarWChar, 255, "StudID") update.CommandText = sb.ToString() update.Connection = excelCon2 da2.UpdateCommand = update excelCon2.Close() DecideColour(DataGridView1) End Sub Private Sub cmdExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExit.Click LoginForm1.Close() Me.Close() excelCon2.Close() End Sub Private Sub cmdupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdupdate.Click da2.Update(ds2.Tables(0)) Dim xlPath As String Dim myExcel As Object myExcel = CreateObject("Excel.Application") xlPath = "S:\SanctionsDb\2007-08\points.xls" myExcel.Visible = False myExcel.Workbooks.Open(xlPath) 'open file myExcel.DisplayAlerts = False myExcel.ActiveWorkbook.SaveAs(FileName:=xlPath, CreateBackup:=True) myExcel.ActiveWorkbook.Close(False) 'close file myExcel.quit() myExcel = Nothing ds2.Clear() da2.Fill(ds2) DataGridView1.Refresh() Me.Refresh() DecideColour(DataGridView1) End Sub Private Sub cmdSanctions_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSanctions.Click DataGridView1.Rows(DataGridView1.CurrentCell.RowIndex).Cells("Sanctions").Value = "2" Dim row As DataGridViewRow For Each row In DataGridView1.Rows row.Cells("CumTotal").Value = row.Cells("SessionTotal").Value Next DecideColour(DataGridView1) OnTrip(DataGridView1) End Sub Private Sub cmdAward_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAward.Click For Each row As DataGridViewRow In DataGridView1.Rows 'Debug.Write(row.Index) row.Cells("Points").Value = "2" row.Cells("CumTotal").Value = row.Cells("SessionTotal").Value Next DecideColour(DataGridView1) OnTrip(DataGridView1) End Sub Private Sub cmdClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdClear.Click Clear(DataGridView1) End Sub End Class And the Macro code (provided by Microsoft) is: Code Block The Auto_Open name forces this macro to run every time ' the workbook containing this macro is opened. Sub Auto_Open() ' Every time a cell's value is changed, ' the RunningTotal macro runs. Application.OnEntry = "RunningTotal" End Sub '---------------------------------------------------------- ' This macro runs each time the value of a cell changes. ' It adds the current value of the cell to the value of the ' cell comment. Then it stores the new total in the cell comment. Sub RunningTotal() On Error GoTo errorhandler ' Skip cells that have no comment. With Application.Caller ' Checks to see if the cell is a running total by ' checking to see if the first 4 characters of the cell ' comment are "RT= ". NOTE: there is a space after the equal ' sign. If Left(.Comment.Text, 4) = "RT= " Then ' Change the cell's value to the new value in the cell ' plus the old total stored in the cell comment. RT = .Value + Right(.Comment.Text, Len(.Comment.Text) - 4) .Value = RT ' Store the new total in the cell note. .Comment.Text Text:="RT= " & RT End If End With Exit Sub ' Skip over the errorhandler routine. errorhandler: ' End the procedure if no comment in the cell. Exit Sub End Sub '-------------------------------------------------------------- ' This macro sets up a cell to be a running total cell. Sub SetComment() With ActiveCell ' Set comment to indicate that a running total is present. ' If the ActiveCell is empty, multiplying by 1 will ' return a 0. .AddComment .Comment.Text Text:="RT= " & (ActiveCell * 1) End With End Sub[/code] If anyone could help, I would be very greatful! Thanks in advance Tag: The specified module could not be found??
  - 7
    - Multi-column List Box with data not from excel spreadsheet 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. For the purposes of this problem I dont have the data in an excel spreadsheet. Thanks! Tag: The specified module could not be found??
  - 8
    - Toggle button logic problem 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 False. *When ToggleButton3 is clicked its caption alternates between ON and OFF and its value between True and False. *If ToggleButton1 is clicked from ON to OFF (True to False) ToggleButton2 and ToggleButton3 will change to OFF (False) *If ToggleButton2 or ToggleButton3 are clicked from OFF (False) to ON (True), ToggleButton1 will change to ON (True). *If ToggleButton2 is clicked from ON to OFF (True to False) while ToggleButton3 is OFF (False), ToggleButton1 should change from ON (True) to OFF (False). *If ToggleButton2 is clicked from ON to OFF (True to False) while ToggleButton3 is ON (True), ToggleButton1 should remain ON (True). *If ToggleButton3 is clicked from ON to OFF (True to False) while ToggleButton2 is OFF (False), ToggleButton1 should change from ON (True) to OFF (False). *If ToggleButton3 is clicked from ON to OFF (True to False) while ToggleButton2 is ON (True), ToggleButton1 should remain ON (True). Here is my code that doesn't quite get there. The problem it has is that if ToggleButton1, ToggleButton2 and ToggleButton3 are ON (True) and then either ToggleButton2 or ToggleButton3 are clicked to OFF (False) ToggleButton1 changes to OFF (False), when I want it to remain ON (True) in this case; Private Sub ToggleButton1_Click() ToggleButton1.Caption = IIf(ToggleButton1.Value, "ON", "OFF") If ToggleButton1.Value = False Then ToggleButton2.Caption = IIf(ToggleButton1.Value, "ON", "OFF") ToggleButton2.Value = IIf(ToggleButton1.Value, True, False) ToggleButton3.Caption = IIf(ToggleButton1.Value, "ON", "OFF") ToggleButton3.Value = IIf(ToggleButton1.Value, True, False) End If End Sub Private Sub ToggleButton2_Click() ToggleButton2.Caption = IIf(ToggleButton2.Value, "ON", "OFF") If ToggleButton2.Value = True Then ToggleButton1.Caption = IIf(ToggleButton2.Value, "ON", "OFF") ToggleButton1.Value = IIf(ToggleButton2.Value, True, False) Else ToggleButton1.Caption = IIf(ToggleButton2.Value, "ON", "OFF") ToggleButton1.Value = IIf(ToggleButton2.Value, True, False) End If End Sub Private Sub ToggleButton3_Click() ToggleButton3.Caption = IIf(ToggleButton3.Value, "ON", "OFF") If ToggleButton3.Value = True Then ToggleButton1.Caption = IIf(ToggleButton3.Value, "ON", "OFF") ToggleButton1.Value = IIf(ToggleButton3.Value, True, False) Else ToggleButton1.Caption = IIf(ToggleButton3.Value, "ON", "OFF") ToggleButton1.Value = IIf(ToggleButton3.Value, True, False) End If End Sub Tag: The specified module could not be found??
  - 9
    - this problem is also troubling me now!! :( Hi I have also tried setting site.AllowUnsafeUpdates = true It does not help too. Please direct me where i am missing. tia sahridhayan Tag: The specified module could not be found??
  - 10
    - Office Communicator 2005 sign-in name, auto populate after install somehow? I've also set this up in the batch file at install time as well (causes communicator to run right after install and the user gets logged in automatically): (No reboot required) At time of install I run this from my install batch file (call it.. something.vbs): Dim WshShell Set WshShell=WScript.CreateObject("WScript.Shell") WshShell.RegWrite "HKCU\Software\Microsoft\Communicator\AddToFirewallExceptionList", 0, "REG_DWORD" WshShell.RegWrite "HKCU\Software\Microsoft\Communicator\RTCState", 01000000, "REG_BINARY" Then in the same batch file at the end of the install I simply execute communicator via "start communicator" and instantly the user is signed in. Tag: The specified module could not be found??
  - 11
    - Configuration Failed 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.Additional Information The given key was not present in the dictionary Plz Help 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.Additional Information The given key was not present in the dictionary Plz Help Tag: The specified module could not be found??
  - 12
    - VBA 6.5 New Version? 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 Tag: The specified module could not be found??
  - 13
    - visual Foxpro9 vs VB2005+SQL2005 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 Tag: The specified module could not be found??
  - 14
    - Merry Christmas and Happy New Year 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. Tag: The specified module could not be found??
  - 15
    - Need some opinions on these 2 books plz 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 off Mastering Microsoft VBA - ISBN: 978-0-7821-4436-9 http://www.intersoft.co.za/Index.cfm fuseaction=books.viewBook&BookID=5198566 VBA Developer's Handbook - ISBN: 978-0-7821-2978-6 http://www.intersoft.co.za/Index.cfm fuseaction=books.viewBook&BookID=4611758 All help greatly appreciated! Thanks Tag: The specified module could not be found??
  - 16
    - TextAlign in a Listbox from Access 2000 (not Microsoft Forms 2.0) 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 TIA Joao Rodrigues P.S. Like the Requery property... also does not work! Tag: The specified module could not be found??
- Next
  - 1
    - Norton 2007 - slow running and iE unable to connect to the net 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 Tag: The specified module could not be found??
  - 2
    - Network Interface Card (NIC) Enable/Disable programatically in VB 6 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 Tag: The specified module could not be found??
  - 3
    - New Combo Box problem 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, or even tripling the same entries..........what am i doing wrong In the box it looks like this: no leaks detected no leakage or adverse damage detected the entire contents of the packaging were retained no leaks detected no leakage or adverse damage detected the entire contents of the packaging were retained It does this whether i use the index or not. Help! Tag: The specified module could not be found??
  - 4
    - How to Get Position of Scribble line's Points? 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 function exists. Each ShapeNode has a Points property, but the Points property does not return me position of the node no matter what I tried. Can anybody (from Microsoft maybe) tell how to use the Office SDK to get the positions of the control Points of a scribble shape whose type is msoFreeform If this can not be done in Word, can that be done in PowerPoint and Excel instead Tag: The specified module could not be found??
  - 5
    - Possible to run code after Word closes? that is not a bad idea, but I want the original template document to remain empty, so saving the data in it is not acceptable. I guess I'll have to clear all the form elements in the document and then save it Tag: The specified module could not be found??
  - 6
    - duplicating VBA objects 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. Tag: The specified module could not be found??
  - 7
    - Dynamic Lists in Excel 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.contextures.com/xlDataVal02.html but can not work out how to have List 5 also dependant on List 1. The values in all lists will need to be entered in a excel sheet and the number of items that will appear in the list will change. How can this be done and is it best to do it in VBA. Also I want list 5 to display 2 values side by side. Level % 1 4 2 8 3 16 4 40 5 42 6 55 7 70 While 2 values will be displayed the level value will need to be stored in the cell where the selection was made. If anyone can help it would be greatly appreciated Tag: The specified module could not be found??
  - 8
    - XP style appearance 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 Tag: The specified module could not be found??
  - 9
    - Newbie in VBA Drag and Drop.. Hi, You description is clear enough but you know it's still difficult to make a decision for you without having more detailed requirements. I wouldn't like to make a suggestion based on the information you've given me, you could go and develop something that wasn't suitable based on my suggestion and then users will have another reason to moan about software. It would be better for you to write a decent post describing what the system needs to do, list all the steps the user will do in order to use the system, then write about the approach your think would be best, why you think that's the best approach, and then we could take it from there. The most important thing is list the steps, for example... 1. User opens an Excel template 2. User fills in X, Y, and Z 3. User mail merges Y and Z to a table in Word document and enters P 4. User uploads Y and P into three different tables in SQL Server database. If you do that from when the user starts the process (opens a spreadsheet) to when they finish the process (save to database) then you might see the best approach is, but post it and what you think is best and I'll give you some feedback. Be as descriptive as possible. Tag: The specified module could not be found??
  - 10
    - WSS 3.0 "This stock feature has been retired." We had this problem this morning and it was because of a control on our sharepoint site... Hope this helps Tag: The specified module could not be found??
  - 11
    - Question about VBA and Office 2007 My reason is that I prefer C# syntax and the build-in functions. VBA functions has certain strange convertion precision behavior. I know how to deal with that, but I am not sure if there is other VBA specifications that I missed. And I want to adapt the language like C#. I think I will stay with VBA for now because I can't compile .Net code in Excel, which is a big draw back for me. Until Excel has a build-in editor and compiler for C#, I will stick with VBA. Thanks for the help. Tag: The specified module could not be found??
  - 12
    - Document Object help! Hi, I am a total newbe to VB and am having some trouble with what i think is VB...or possibly VBA. I wanted to take data that a user would enter via Word template and then take that data and push parts of it into another word document. It looks like I can do it via bookmarks but since I already have an Object called ThisDocument, I am not sure how to go about adding a second document to the project. Any thoughts Tag: The specified module could not be found??
  - 13
    - WER wish list for developers 8-) Many support contracts with customers promise a reaction within 24 hours - that would be the upper limit for the processing delay which makes the Winqual portal a viable tool for customer support in crash situations. However, it is very desirable to have turnaround times even significantly lower than that (less than an hour). I realize this is asking a lot of the Watson/Winqual servers; after all, they probably have to process huge amounts of data each day. This is why I would love to see an option for ISVs to set up their own local "Watson servers" to which customers could send crash data when the WER dialog appears. For instance, an application could use a WER API configuration function to specify an alternate WER server. In our case, this could be something like watson.cocreate.com. When a crash occurs in one of our apps, WER would display its usual dialogs. Instead of presenting the simple choice between "Don't Send" and "Send", the user would be informed that he can send the crash data both to Microsoft (default), or to us, or both. From a WER API point of view, this is probably a simple feat. However, it means that we would have to set up a publicly accessibly CER/AEM-like server - which could be a little challenging, for example from a security point of view. Also, since the WER API needs to change, it would mean we wouldn't see any improvement at all before at least Vista SP1 or SP2, probably even later. But alternatively, what if we could tell the Winqual portal that crashes reported for our applications should be routed immediately to one of our servers This way, the WER API wouldn't need to change at all, and since only Microsoft would know about the whereabouts and details of our server connection, secure operation would be easier to achieve. So once we'd register our own Watson-like server with Microsoft, here's a typical sequence of events: Application crashes at customer site WER dialog is displayed, customer chooses to send crash data Watson server at Microsoft checks if there is an ISV registration for the crashing app, and whether the ISV has also registered an ISV-local Watson server If so, the crash report is immediately forwarded to the ISV's server. Process the crash reports as usual, and make them available through Winqual. In this scenario, Winqual delays of 3-4 days or even a week wouldn't be a big issue anymore for an ISV. Claus http://www.clausbrod.de/Blog Tag: The specified module could not be found??
  - 14
    - Browse hard disk with VBA Hello, I want to read a text file into Excel with VBA. This all works fine with some code I found, the only problem is that the text file I want to open should either be written in the code, or in a textbox but than I have to type the complete location (C:\MyDocuments....) what I would like to have is a browser, similar to the one from Windows on "Ctrl O", which opens when I push a button so I can browse for the file on my hard disk and select the file I want to read into Excel. Does anybody know if this could be made in VBA, and if it is possible how Barry Tag: The specified module could not be found??
  - 15
    - How to Get Position of Scribble line's Points? 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 function exists. Each ShapeNode has a Points property, but the Points property does not return me position of the node no matter what I tried. Can anybody (from Microsoft maybe) tell how to use the Office SDK to get the positions of the control Points of a scribble shape whose type is msoFreeform If this can not be done in Word, can that be done in PowerPoint and Excel instead Tag: The specified module could not be found??
  - 16
    - How do I configure sharepoint data to point different directory? I have created 20 GB vhd and install my SharePoint on it. Everything I put as data will be written on that 20 GB vhd. But if I put all my data in shared folder, it will be filled out quickly and I will be out of space. Is there anyway to store the new data other than the vhd and still be shared For example for my shared folder, I want to put the data in another drive but I want them to be shared through SharePoint. In other words, how do I configure SharePoint data to point different directory I have created mapped network drive in another directory. But I don��t know how to tell SharePoint to use that directory to store new data. I have looked everywhere and asked everyone, no luck so far. Tag: The specified module could not be found??

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

set myOutlookObject = CreateObject("Outlook.Application")

How do I fix it Thank you.

Top

Re: The specified module could not be found??

magicalclick

NVM, I reinstalled excel and outlook, and it is good now.

Top