Answer Questions

• Boldie Trying to get just the file name

  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:="& ...Show All

• ALFKI sending emails from MS Word with variable subject line

  Hi, I've searched these forums but have not been able to find exactly what I need. I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code (    .Subject = "New subject"   ) What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in the toolbar. The email address is always the same but the subject line shows the customer's name and his account number (so that's different all the time) Is there any way I can get the VBA code to copy the first line of the report (which has the customer's account number and name) and use that in the subject ...Show All

• markovuksanovic Using Paste in the File Save as window

  Hi all I only know a little about VB but have made a form on word that copys a word from the document saves itself to a folder prints a copy and then exits word. it all works fine except i cannot get it to paste the word from the document in the fileName when it saves. The script is below with red showing the problem. Any help on this would be much apreciated Mark Sub Process() ' ' Process jobsheet macro ' Macro recorded 09/01/2007 by Mark Smith ' ActiveDocument.Shapes("Text Box 6").Select Selection.WholeStory Selection.Copy ChangeFileOpenDirectory _ "E:\Global Internet Learning Ltd Files\Duplication Centre\Client Job Sheets\" ActiveDocument.SaveAs FileName:= , FileFormat:= _ wdFormatDocume ...Show All

• LeeC22 Application.FileSearch in Excel 2007

  There is an issue which I am facing after I installed Office 2007. I had written a small VBA which would search for a file and if found will rename the file. I used Application.FileSearch then. Now I am tying to do it again but unfortunately there is an error prompted stating that 'the object does not exist' Set fSearch = Application.FileSearch defPath = "H:\SourceSafe_1_Feb-28_Feb_2006\SecondSet" Set rg = Range("MyFiles") fSearch.LookIn = defPath I have been frantically looking for changes in the VBA object model especially for Excel but cant seem to find them. I am having this same problem as well doing a very similar thing but in Excell. The code is as follows Set fs = Application.FileSearch ...Show All

• Andrea Giovannini 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

• &#169&#59; Ţĩмό Şąļσмāĸ iexplore.exe - Application Error

  I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this Hello i would like to know how to fix this problem on my computer. If there is away please let me know so i can fix it. Tracyb I don't use the Yahoo tool bar and I get a similar message when I close Ie 6.. "The instruction at "0x02653812" referenced memory at "0x0277bb2c". The memory could not be read. (All XP updates installed.) From what I have read it is b ...Show All

• ecsinusa Verifying completion of a file's creation from VBA

  I need a way to monitor a file in a folder (created by an external application, such as Word or Acrobat), and verify that the process of writing to the file has completed (in Windows 2000 or XP). I.e., that the file is finished, and can be opened by Excel. It's easy to verify that the file exists, and what it's file length is, but the file length continues to increase as the file is written to (especially for a large file). Anyone know of a way in VBA to verify that the file is complete I assume that Windows sets some kind of bit in the file to indicate completion. Thanks... Moved to VBA forum ...Show All

• cashfan use inputbox to choose cells for plots in excel

  Hi all, The below code would I like to change so I can use the inputbox arrays 'usr_choice_x' and 'usr_choice_y' (instead of the range "A68:B89" as it is now) for the plot. How do I do that Grateful for ideas usr_choice_x = Application.InputBox(Prompt:="Select x cells ", Type:=64) usr_choice_y = Application.InputBox(Prompt:="Select y cells ", Type:=64) Charts.Add ActiveChart.ChartType = xlXYScatterSmoothNoMarkers ActiveChart.SetSourceData Source:=Sheets("MDO_061013_LHS_HP").Range( _ "A68:B89"), PlotBy:=xlColumns ActiveChart.Location Where:=xlLocationAsObject, Name:= _ "MDO_061013_LHS_HP" With ActiveChart .HasTitle = False .Axes(xlCategory, xlP ...Show All

• TheMaj0r last row

  any ideas on how I can get the last row number of a certain column. Say column B has 62 rows...how could I get that number into an integer format so I can use it for a loop. Thanks It will be a lot easier if you have a helper class that moves activecells. Anyway, here is the way you do it Cell(Rows.Count,2).select if activecell.formulaC1R1 <> "" then Selection.End(xlUp).Select Basically you select the down most cell and press end and up arrow. That's it. It is simple, but I prefer to make this a helper function, so, I don't have to write it again. Please see your other post Chas ...Show All

• RobLearningVisualBasic How can I connect to the Team Foundation server?

  I installed Microsoft Team Foundation Server for Deverlopers in machine A (server). After that, I installed team foundation exlporer in machine B When connected to machine A from B, it cause theres errors here: 1. FTF31002 http:\\192.168.10.41 - May be the team servername, port number or protocol is incorrect -Team Foundation server is offline -Password is expired or incorrect Although I have set all my settings correctly. Please help me! did u get anything for this... We have a new installation of TFS and when I try to connect to it using Team Explorer, I get the same error as you were getting. Can you pls give me some insight on this. Thanks Ravi ...Show All

• VikasAgr ADO Recordset CursorType Property

  I want to create an updateable recordset, whereby the values in a particular field in the recordset once opened are changed to something else if certain conditions are met. However, I do not want these updates to change the underlying datasource, otherwise I would be in trouble! I would therefore need to set the recordset's cursor type property prior to opening the recordset, of which there are 4 constant values: adOpenForwardOnly, adOpenKeyset, adOpenDynamic and adOpenStatic. I'm guessing the last one of these is the one I need, but can anyone confirm this is the case before I start Are there any other recordset properties I need to consider as well Cheers! Keith Cheers Derek! I'll do as ...Show All

• provato Cells

  I'm really confused as to why I activate a cell: x = ActiveCell.Row Yet when I try to select that cell: Range (Cells(x, 1)).Select It comes up with an address way out of whack! What am I doing wrong It works because it is using the default property of a cell, which is .Value. And it just so happens the content of that cell is a valid cell address. The same effect with the property explicitly set. Range (Cells(x, 1).Value).Select When the first argument of the Range method is used it needs the cells address, so this will work. x = ActiveCell.Row Range(Cells(x, 1).Address).Select Or you could shorten it to this. ActiveCell.EntireRow.Range("A1").Select Thanks for your reply. I think I f ...Show All

• WHMoweryJr Edit DataLabel in Excel charts

  Hi all, I wonder have I can add a Legend Key(a line that goes from the point in the chart to DataLabel text) to the DataLabel in the code below I would also like to now how I can change the position of the DataLabel. With ActiveChart     With .SeriesCollection(1).Points(2)         .HasDataLabel = True         .DataLabel.Text = "Saturday"     End With End With Thankful for tips. Jonas Thanks Andy! Maybe this example of leader lines will help. http://www.andypope.info/ngs/ng14.htm To change the position of the data label you can use code like this. ' using built in label positions. Positions available depend on chart ...Show All

• Scott Leclerc ERROR RUNNING MARCO

  hi can anyone help me with this problem Hi can anyone help me with this problem I have this dos script to pass down a parameter upon opening the excel @echo off start excel "\\136.121.2.1\its helpdesk\ConRisk\RSP Concentration Risk Calculation.xls" /e/8212305557 Is there any code to capture the parameter "8212305557" on the excel macro upon opening here is my code Option Base 1 Private Declare Function GetCommandLineA Lib "Kernel32" () As String Dim CmdLine As String 'command-line string Dim Args As Variant Dim ArgCount As Integer 'number of parameters Dim Pos1 As Integer, Pos2 As Integer Dim sMsg As String Dim Customercode As String CmdLine = GetCommandLineA 'get the cmd-line string Cm ...Show All

• barryt iexplore.exe - Application Error

  I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this I don't use the Yahoo tool bar and I get a similar message when I close Ie 6.. "The instruction at "0x02653812" referenced memory at "0x0277bb2c". The memory could not be read. (All XP updates installed.) I get the exact same message. Have you found any answers What have you tried to do Tom I'm getting this with IE 6. Just started as well. ...Show All