chr13

I'm wanting to import a CSV file into an excel workbook, and previously had just recorded this operation and tweaked the code generated from the recorder. Now with the PowerQuery / Get Data features in excel it wants to create a query connection which seems like overkill for my needs. Is it...

Hi there, I recorded a macro to download a Query Table from the Web that gives me revenue estimates. The code below works for the company ticker "NVDA" which is declared below. However, when I change the ticker to "ADBE", the code breaks because the column header (which specifies a date)...

Hi All, I'm fairly new to VBA and trying to combine 2 VBA codes to create the perfect solution, but i'm not having much luck! I need to run a macro to email sheets from a large workbook to multiple recipients using a list in "Contacts" that has the sheet names in column b and the email...

Hello, I'm having an issue with passing a variable as a link into a web pull. When I hardcode the link, it makes the necessary pull and returns the data. The problem is, as soon as I put the link into a variable, it rejects the same pull. Even if the variable is the same as the hard coded text...

I am using code to generate code. The generated code is stored within a string, but i can't execute the string. I have been searching for hours but still find nothing. The goal is to update the filters within a pivot table to only show certain months between a start and finishing date, without...

Hi all. People have been super helpful so far helping me with this project I'm working on, but I have one more issue. I have 5 worksheets and the first one is a dashboard calculator of sorts called "Calc". I have a checkbox that when toggled changes the tab name on four other worksheets in...

Hi, I use an excel add in to import multiple .sas7bdat files into a workbook every week, sometimes more than once per week. I receive the files by email and if I could just dump them on my desktop and run a macro to import them to exactly where I need it would save me so much time. I decided to...

Any help would be appreciated, Macro2 works fine but it is a static report, Macro1 does not work properly trying to make it a dynamic report (mystr = 20180222; i.e. date) Any ideas on how to make Macro1 work properly? Sub Macro1() Dim mystr As String For x = 1 To 1...

Merry Christmas to all at Mr Excel, Hope you're working as hard as I am over the festive/holiday season :laugh: Trying to write a few ODBC queries into an old IBM AS/400 / iSeries server. It's all gone well using fixed values, but now I'm trying to add in some variables, it's getting a bit...

Hi, my name is Andrew and I am new to this forum, hope I do everything correctly, I have a macro that extracts data from Access. before the data lands in the excel worksheet, I want to filter the data by a variable that is defined in a cell reference. I have tried to use a dim option but I...

hi, I have the following code:- Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Set Target = Range("d3") If Target = "" Then Exit Sub On Error GoTo Badname ActiveSheet.Name = "Mytimes_WC_" & Format(Range("d3").Value, "dd-mm-yyyy") Exit Sub Badname...

Hi all I have the following problem. <b>I have this code in an Excel macro:</b> For Each cell In [KMLData!A3.A2500] pmValid = cell.Offset(0, 4) pmName = cell.Offset(0, 4) pmLongitude = cell.Offset(0, 10) pmLatitude = cell.Offset(0, 11)...

I need to import data from notepad but I need the source notepad file to be selected by the open file prompt. I tried using the macro recorder but I can't get it to adjust to the variable. And does anyone know the character [10] and [13] means? The commented out part of the code is the original...