Answer Questions

• Jake H SourceName method

  I'm using VBA to read a text file made of files paths (path & name). I'm opening them in word and trying to resave them into .txt format for notepad/wordpad. There is no easy way to be able to find the last "\" and then use that to take all the text after it. example: "C:\my docs\this file.doc" i would want the "this file" portion of the text I found what seems to be a useful method (sourcename) but have no idea how to implement it If f1 = fso.FileExists(file) Then Documents.Open filename:=line, ConfirmConversions:=False, ReadOnly _ :=False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate _ :="", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="" _ , Format:=wdOpenFor ...Show All

• pchak Problem with Connection Strings

  Hi All, I have an excel spreadsheet, which I want to use like a database table and access using ADO from another spreadsheet, but whenever I attempt to assign my connection string to the ActiveConnection property of my ADODB Recordset, I get the following error: Could not find installable ISAM. Below is the connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Le09\kpl_biskra\personal_biskra\ksmith\Reporting\Weekly\Christmas Analysis\DataFile.xls;Extended Properties=Excel 8.0;HDR=Yes; Can anyone help Many thanks! Keith How you doing, This might not be the solution but your Extended Properties should be double quotes in the connection string, like this. Provider=Mic ...Show All

• Bastiaan Molsbeck A simple list of words from a word document

  I want to create a list of words from a word document. For example a document containing a sentence " The quick brown fox " the list of words should be - The quick Brown fox I initially thought I would use the Activedocument.words.count to find the total number of words in the document. Then use a do while loop to iterate through each word and generate a list. The solution was easy but since I am a newbie to VBA I cannot figure out what method to use to generate the list so that every time the loop hits a space after the word, it replaces the space with a newline character till the end of the loop. Could someone give me some ideas / suggestions. Thanks Thanks Andy for your suggestion. ...Show All

• k3bdf Problem regarding VBA in excel - Combine 52 VBA codes for 52 weeks in a year to one VBA code

  I am very new to VBA, hope that anyone can help me on this.. I have some problem with creating a code which can Please refer to the code down there: 'the listbox will show week 1 to week 52 and let me choose one of the week. Private Sub OKButton_Click() If ListBox1.Text = "Week 26" Then Call week26 If ListBox1.Text = "Week 27" Then Call week27 ' all together 52 weeks in a year Unload Me Sheet7.Activate End Sub Sub week26() With Sheet7 .AutoFilterMode = False .Range("A1:I1").AutoFilter .Range("A1:I1").AutoFilter Field:=3, Criteria1:=">=26-Jun-06", _ Operator:=xlAnd, Criteria2:="<=2-Jul-06" End With End Sub Sub week27( ...Show All

• Badajoz95 Microsoft Platform Test for ISV Solutions

  Hi. My company is getting ready for the "Microsoft Platform Test for ISV Solutions". Can I find more detailed directions and resources to set the designated application for the test i.e. to pass "managed code" tests- I know that the application is free from 'DllImport', but I'm not sure that: This is enough. One of the components I'm using works with unmanaged code. Further more, the document provided by Microsoft (" Guidelines for products that appropriately target Microsoft platforms and technologies " version 0.93) Declares that: Note: It is acceptable for assemblies sourced from third parties that are installed with the application under test to ...Show All

• sweat Urgent HELP!!!!! VB in MS Excel

  I have a data file in Excel which contains a lot of information for different hospitals. I want to create separate Excel files which contains the information specific to one hospital - I don't want hospitals to see data from other hospitals. Ideally I would like one click that will generate the reports for me I am not sure how to go about this. I have some VB code but for business objects and it doesn't work in excel. Please help!!!! You need to modify the recorded code such that there's a variable that counts the number of entry. While Loop can be used. Email me, I'd like to help you with this. Please send me your email address at 639209590012@chikkatxt.com , I'll get your email ...Show All

• maverick_majnoo Data Access Pages - FAO Chas

  Chas, and anyone else who sneaks a peak, here's a link to a pretty good article on developing Data Access Pages in Access. http://msdn.microsoft.com/library/ url=/library/en-us/dnacc2k/html/programdap.asp It's a fairly comprehensive document that covers quite a lot. Also, on an unrelated topic.... here's a good article on how VBA is stored, compiled, and ran... http://archive.baarns.com/excel/develop/vbaperfm.asp Thanks Derek, Will have a look soon. I've just been away (Dallas, Miami and then Bogota so a bit exhausted!!) Cheers Chas ...Show All

• MichaelD&amp;#33; Excel function PRICE

  Hi Everyone, I'm having a hard time solving for the Excel function PRICE and COUPDAYBS using VBA or ASP. Do anyone know how to convert its formula to ASP or VB Because i try to reference excel in my code but there is no PRICE function available. Hope you could help me. Thanks. Hi This function looks like it uses coupon rate, payment interval and maturity data to generate a cashflow stream, which is then discounted by the yeild to give you a net present value. This is effectively a discounted cashflow calculation, the important part of the calculation is to correctly predict the coupon payments; I am not sure that I understand how basis works, which is key. Can you post example data for each ...Show All

• cisfreak2 API Used in VBA

  Hi Friends, I want to know what APIs acn be used in VBA Programming. Can U help me Thnaks See www.allapi.com You can use any APIs in VBA that you could use in VB6. If you know which one you want, search google using the API name and VBA or VB6. I'm not sure if .Net versions are compatible, but those are worth a trip to google too. (Google is one of my favorite programming tools, BTW.) Ideally, All VB6 API Functions should work with VBA also. I have tried many and it works fine You can use API Viewer in the Addins tab of VB and get to know the APIs available. You can also add more API Functions to the input file ...Show All

• zabrucewayne creating hyperlink through vba

  hi, i'm facing a bit of a situation that's been driving me nuts for about 12 hours now. in a nutshell, i have a lot of data in access, where i use vba to crunch numbers, and from the same project, i open an existing excel file (thereby now using both excel and access functionality from the same vba code), where i need to paste and format the crunched data (reports) to look pretty, and be user friendly. in the user friendly part, i dynamically need to create hyperlinks from one cell to another cell (in the same workbook, and some even within the same sheet). it seemed straightforward enough, but i have tried EVERY possible approach...using the (worksheet).hyperlinks.add function, as well as trying (worksheet).(cell).formula = "=hyperli ...Show All

• Winson Activate a workbook based on a value in a cell in another workbook

  I want to activate another active (open) workbook only if its name is the same as what I have recorded in a cell in my workbook. If it does return the same name then it is activated, otherwise a message box displays. Example: In my Reports workbook on a worksheet name “formula” in cell B33, I have the value “JulyData”. This represents the name of another workbook (i.e. JulyData.xls) Before a routine is run to import data into Reports.xls I want to verify that the name of the source workbook is actually “JulyData.xls” (as verified to B33 on my “formula” worksheet) and not “AugData.xls”. If it is “JulyData.xls” then I want the procedure to make it the active workbook and start importing data from s ...Show All

• Aelx .onAction assign value

  In my macro when the user presses a button I use the following code: Set stapelDiagramKnapp = .Controls.Add(Type:=msoControlButton) With stapelDiagramKnapp .Caption = "Stapeldiagram" .OnAction = "ChartModul1.arrayLoop" ....here I want to assign a value to a global variable (declared in a differen place) so that I can keep track of which button is pressed. Alternatively I can assign a value to an "ordinary" variable and pass that along to the other modules as an argumnet. Can someone please help me with the code for this Thanks to you all very much! Since you didn't inlcude the With line, I'm having to use my crystal ball to figure out WHAT your adding the control to. I'm ...Show All

• sunliang Passing Function As Argument

  I dunno if it's possible, but I'd like to pass a function name as an argument to a function. The idea is to use the result of the function to do some calculations, no matter what the function is. It would be like this: Function Find_Zeros( Function_Name As Function, Value_X As Double, etc) Thanks in advance. I'm okay with passing strings, as long as it works This function is to find the root of the function, if there's only one root, and if the values of the function in left and right are of different signals. It's a rude way to find roots, but it's the only method that I know that always find a solution (tangent and newton-raphson sometimes don't find any). It explodes, yes, but the ...Show All

• Seradex WebPart Problem (?) / BSM2005

  Hy. We have a Win2k3-Server (SP1) with SQL2k5, IIS6, Sharepoint Services 2. To tryout the features i've installed the BSM2005-Demo. Fortunately there where no problems during the installation, but after deploying a scorecard i get the following error: can you please let us know how you solved the problem.... Regards Hi, I have the same problem. Could you please tell me how did you resolve the issue Many thanks, Andrej never mind, solved it myself -_- hi, can you tell me please how did you solved it ... i'm having the same problem. thanks Tatiana. ...Show All

• laue Change a value for a link to another Excel file

  I do not know much about Visual Basic and maybe somebody know how to change the value 100,200,50,75 by a link to another excel document Dim A As Integer Dim B As Integer Dim C As Integer Dim D As Integer A = 100 B = 200 C = 50 D = 75 ActiveSheet.Shapes.AddShape(msoShapeRectangle, A, B, C, D). _ Select Range("B2").Select End Sub Tanks a lot Create a workbook called 'Shapedata.xls' and enter values in A1:D1, then insert this code: Dim dataWB As Workbook Set dataWB = Workbooks.Open("c:\documents\shapedata.xls") 'change to correct path A = dataWB.Worksheets("sheet1").Range("a1").Value B = dataWB.Worksheets("sheet1").Range("b1").Va ...Show All