chr10

Hello all, I was creating a VBA code to insert a PDF to an email. I was able to do it basically, but once I changed up the file name & path to be dynamic, it could not find the PDF document via the new naming criteria. Below is my code. Sub sendReminderMail()ChDir "C:\Users\rbs\Desktop"...

I have established an API question via Power Query and I am just mimic it through VBA. The JSON document that is returned has multiple drill downs that I need; however, I had to create a new connection each time to change the let statements. I think this is where my query is going really slow...

Hi please can you help me, I have the cold below where I want the "comments" to be in bold, how do I do this please? I have tried the <B> in front of the comments but this didn't work. "Comments: " & Me.TextBox9.Value & Chr(10) & _

Hi there, I had a macro that worked before but fails now because the Query Editor says that it's using Internet Explorer Compatibility Mode. I would prefer not having it download as a query table. In the old versions of excel, it was not as complicated as it is now. Any help would be super...

I have tried to make this as simple as possible to track this down, but Excel's macro recording just doesn't seem to be recording the right thing... I just can't figure out WHAT it's recording wrong. Simple macro steps: create new workbook, Data:From Text, select .txt file, when Query preview...

Hello, I have a code in which i use ActiveWorkbook.Queries.Add to import a CSV file. But while importing i need to filter only those rows containing value given by user. Below is the code. I have Highlighted and Bold the portion where i give the filter criteria as [Object ID] = 140. But what i...

Hello All, How do I import every/all fields in my query? I need the equivalent of SELECT FROM * . Below is what I got: Sub CSVFiles() Dim MyFile As FileDialog Set MyFile = Application.FileDialog(msoFileDialogFilePicker) Dim StrFileName As String, strPath As String StrFileName =...

Hi Everyone, The code below has an "Application.Wait" command in it. But what I need is the macro to get triggered then stop for 1 minute before sending the email but have everything else continue to run (I have other macros formulas etc.) Will Do Events help me here? if so how do i add it...

Hello I am trying to add a comment that contains a fair amount of text via a VB macro, but I cannot get the excel to accept the code. The code I have is:- Cells((RO + 1), L).Comment.text text:= SIDE_STEP_MAX_COMMENT_MILES & "." & SIDE_STEP_MAX_COMMENT_YARDS & Chr(10) &...

Dear Excel Community, Currently I have the following formulas for formatting text in each cell within a certain column. Selection.Replace What:=Chr(10) & Chr(10), Replacement:=Chr(10), LookAt:=xlPart Selection.Replace What:=Chr(10), Replacement:=" " However I wish to combine this process...

hi all looking to edit single cells with rows(alt+enter) in them eg a single cell with this in Name1:ABC Name2:ABCD Name3:ABCDE Name4:ABCDEF change to/add lines Name1:ABC Name2:ABCD Name2a:xxx Name3:ABCDE Name4:ABCDEF Name4a:xxx I recorded a macro, ActiveCell.FormulaR1C1 = _...

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 i have the below code where i want to add a range to the email address located in sheet (email links) i have done for example the A2:A20 but this doesnt seem to work it only find the email address in A2 and not in A3, A4, A5 etc, please can you help me wioth this? thanks for your help it is...

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...

Hello, I can't figure out what is going on with this. The Error I get is, "Run-time error '438': Object Doesn't Support This Property or method." and then it highlights the following. ".ListObject.DisplayName" I have highlighted it red in the code. two values to enter into the input box is...

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...

Hi, I have the code below that adds line breaks/feeds to concatenated text in a word wrapped cell so each bit of text in the concatenation is on its own line in the cell. The problem is that not all cells will have text in them - my code still adds the Chr(10) line breaks so I end up with a...

Hi, i have the code below i was wondering if you can help me with it please, i have entered textbox18, textbox19, and textbox20 anfd this brings back the date into the email but it is in american format how can i change this please in the code? Also after each textbox i have entered a vbtab, but...

Hi, i have the code below where i have a userform which can be filled out then click on an email button to send to recipitents, but i keep getting errors and will not send, i have 9 different boxes where i want to copy the data from for example textbox1, textbox2, textbox3 and so forth. Pleasd...

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...