I want to convert .int to CSV. Does that even make sense?

After spending quite a while trying to figure out the above, I’m starting to think I fundamentally misunderstand what .int is. Can .int be changed into CSV? The reason I want to do this, is so the data can be worked with in Excel (I don’t have the data yet, but I’m not even sure […]

Subtracting two ranges in Excel using VBA

Dear stackoverflow community, I found myself solutions for many problems in other programming languages, now I made myself and account here so I can ask specific question about things I struggle with. I’m making model in excel and tbh I’m pretty poor programmer looking to get better with VBA. My question is, how can I […]

Adding Images from Internet into VBA Image Control

I am having difficulty figuring out how to add an image from a link into a VBA image control. I can bring the image into VBA with the following: Sheets(“Elk”).Shapes.AddPicture “http://images.summitpost.org/original/562016.jpg”, msoFalse, msoTrue, 200, 200, 800, 700 This populates the picture onto the worksheet, but now I want to be able to place it into […]

Making Certain Text Bold In Excel VBA

I am exporting an excel table into word using VBA. The word document has one bookmark. The code is such that first it writes the TYPE as the heading and then write all the description under that TYPE. I want the headings to be bold and formatted. I have the following code but it does […]

Excel Value error on VBA line-break code

So I’ve been trying to create a program that will take a block of text and edit it to only include up to 50 characters per line, but also keeping words together (so substituting the last space in a line of text 50 characters long for a line break character) but I continue to get […]

Sorting Macro Based on Multiple Criteria AFTER an advanced filter has been applied

So I have a set of data that I cannot get the sort code to work. I used an advanced filter to only show unique records, now it is in a range form. My goal is to only show entries that have a “Y” in Column D, and only when Column J matches cell B2. […]

Getting sheet names using VB from macros enabled workbook

I’m working on getting the names of the worksheets in the sheet tab from a macros enabled workbook. Such as the Home, Builder. Image shown below: When researching through the internet, all I see is the following code, which give me all the worksheets names. objExcel = CreateObject(“Excel.Application”) objWorkBook = objExcel.Workbooks.Open(File_location.Text) For Each Me.objWorkSheets In […]

Looping through a long list in VBA and pulling data on the way down

I found it difficult to put this into a succinct question, so I’ll try my best to explain here. I have a large list in Excel that looks something like this: (The Original List) 1 Term1 Term4 Term6 2 Term1 3 Term2 Term3 Term5 4 Term1 Term2 Term3 Term5 Now, I’ve written a series of […]

Excel VBA to Powerpoint

Just wanted to know I am training on Excel VBA to Powerpoint, I am using Excel 2007. I am trying to write text inside Powerpoint from Excel VBA. So I have used the following code to write inside a textbox: ppSlide.Shapes(1).TextFrame.TextRange = “Movie Presentation” ppSlide.Shapes(1).TextFrame.TextRange = “WiseOWl” So that main question is when I write […]

AutoFilter in excel in descending order and not empty with vba

I am trying to auto filter a list in excel, but I am experiencing some problem with filtering it ascending and not empty rows. I have an excel sheet(ws1) with something like 50 columns and a few hundred rows. So I loop through all columns in ws1 and compare it with a text I have […]

MS Excel Spreadsheet is the best Office Software, Excel VBA and Excel Formulas make Spreadsheet work faster.