chr34

  1. I

    Help with a VBA Formula

    Hello All, I've been working on a project and I'm stuck when it comes to converting an Excel Formula into a VBA script. I've decided to automate a bit of a program, so Yint is the beginning point, and Yfin is the ending point. The Excel Formula is...
  2. B

    VBA Error for running outlook event from excel

    So I have some code that basically does an advance search and checks for the search to be complete and then prints it to the immediate window. Its basically an example modified from microsofts example for using advancesearch function. The error I am tripping is when i set my class application...
  3. S

    Function to move/copy& edit - do stuff - to cells or any variable - and paste in another part of the workbook/sheet - Done

    Yes, I believe ive done it. Anyone got any comments/queries please say. Function MOVEME27(a As Variant, b As Variant, Optional CELLR As Variant, Optional cellq As Variant) '21/05/2018 works copied to ar4 '' 03/06/2019 23:30 was cellr as range , cellq as range - changed to variants Dim...
  4. M

    How to add identical slicers to multiple sheets with identical Tables headers on each sheet

    Hi all I'm new here, and have been unable to find a solution to my specific query online or in forums, so I hope somebody can help me. The problem is with Slicers. I work in construction, pricing up potential projects. We produce a 'Report' from our software and I have manipulated this data...
  5. F

    Vba add 1 to number inside text for column

    <tbody> Hello there, I have a worksheet where I'd like to add 1 year to the Date column and add 1 to a number inside some text in another column. The Date column, I have sorted, but the number inside text is the worry. My Col "K" has entries like '12/09/2019' & '17/10/2019'. Col "L" has...
  6. RobbieC

    Transposing a range to a .txt file

    Hi there, I have a series of sheets which I have been transposing the contents of to a text file. I have a series of subroutines which 'append' each sheet contents to make a master text file. This has all been working fine, but I have just noticed that it has been failing to append certain...
  7. D

    Application.Convertformula causes Run.time error '13'

    Hello guys! I would like to insert a formula to a cell with a macro, but it doesn't work. Here is the macro: Sub Macro1() Dim oszlop As String Dim fuggveny As String Dim fuggveny2 As String oszlop = "D" fuggveny = "=IF(ISNA(VLOOKUP(Work!" & oszlop & "2;Work!" & oszlop & ":" & oszlop &...
  8. G

    Function with Embedded String

    Hello, I am passing data between Excel and SAP. I have this: OperationPrint = session.findById("wnd[1]/usr/tblSAPLCOIHTCTRL_5000/txtRIPRT1-VORNR[1,0]").Text which works fine. However I need to loop the row number (LineNumber). This is the code I created: OPLineText = Chr(34) &...
  9. J

    Single quote disappearing

    what i have: ActiveCell.FormulaR1C1 = "=IF(ISNUMBER(MATCH(R[0]C[-1],'Hierarchy'!B:B,0))," & Chr(34) & "Exist" & Chr(34) & "," & Chr(34) & "No" & Chr(34) & ")" What i want: =IF(ISNUMBER(MATCH(G2,'Hierarchy'!B:B,0)),"Exist","No") What i'm getting...
  10. J

    autofill method of range class failed

    Sub PreAudit() Dim ptc As Range Dim ften As Range Dim dollars As Range Dim dollarsr As Range Dim ascalcr As Range Dim asvarr As Range Set ptc = Range("A1:AZ1").Find("PreTenCont").Offset(1, 0) Set ften = Range("A1:AZ1").Find("fte num").Offset(1, 0) Set dollars =...
  11. B

    Shell (Explorer) to control size, location and icon size (details)

    I'm making a little script to search multiple locations for the same file with different extensions. I'm opening 3 windows to display the search results but I'd like to have more control over the windows. Currently they all stack up on top of each other and they are showing the large icons by...
  12. R

    Excel VBA - GetSaveAsFileName

    Good Morning, Trying "in vain" to show the original file name in the "file name:" dialog box. Can anyone help? ================================ Sub RGH_SaveAs() Dim FName thisfilename = ActiveWorkbook.Name thisfilenameinquotes = Chr(34) & thisfilename & Chr(34) IniName =...
  13. I

    Bat file will not run

    I have a working Bat file which i run from an image on my userform. Today i needed to add another image & also a Bat file. I copied the original Bat file code but made an just changed the path etc to reflect the new programme. My problem is when i click on the image nothing happens in respect...
  14. A

    Search function

    Hi I have a form called Customer Enquiry which feeds into a table called Customerdata. What I am trying to do is create a search form where I have an unbound text box called criteria to enter the search criteria and a button to click to search the records. I have a further sub form called...
  15. P

    Code to change generate VBA Cell formula

    I am trying to use VBA to automatically take a cell formula and convert it to a string that can be used in VBA to place the formula in a cell. Sorry for my poor explanation. Basically I want to make a simple tool that someone could type in a formula into a cell, use VBA to convert it to a...

Some videos you may like

This Week's Hot Topics

Top