I have a powerpoint where each sheet contains the hyperlink to a photo. I would like to insert the image into each slide based on that file path. Is there a VBA program that would accomplish this?
Thank you
So I have been stomped for days on end with trying to find a way around using the .Find function in my application which just needs to find the value typed in the textbox, and either return the value and row on an exact match, or display that the…
PROGRAM Lab
IMPLICIT NONE
! Declare variables used in the program
INTEGER :: openStatus, ioStatus
INTEGER :: counter = 0
REAL :: temperature, volume
REAL :: sum_temps = 0.0, sum_vols = 0.0
REAL :: max_temp,…
I'm trying to use an if statement in a do loop which is supposed to generate prime numbers. For that I used modulo to sort out the numbers. After it found a prime number I want it to go a step further and add 1 so that the next prime number can be…
I am trying to search for a keyword in a description field (descr) and if it is there define that field as a match (what keyword it matches on is not important). I am having an issue where the do loop is going through all entries of the array and .…
hey guys i am having a problem in my application with the vbtab
can anyone know what is the problem
this is my code:
txtshowpayments.Text = "Student's ID" & vbTab & "Student's Name" & vbTab & "Total Payment" & vbCrLf
Class217FileReader…
I am creating a method called getAveragePrice and I need it to calculate the average of values in an undefined array list (which would only be defined during the testing/implementation of said method).
public double getAveragePrice() {
…
I got stuck in one task.
Now I have a variable called placement which has two categories, out of home and at home (A and B for short here).
A case can be placed at AAABAB sequentially.
Each placement has a starting date and ending date, for…
I need to conduct an analyses where we need to do apply a GBM algorithm onto a series of bootstrapped replicates. Another wrinkle is that each replicate needs to have a quantile normalized outcome.
What I am trying to eventually achieve is
1.…
Is it possible to run a loop and then have it move down 1 column and run again? Basically I liked the loop to run for the values in row 6 and once complete move down to row 7 and run again. I have tried to add a For loop into the macro but I can…
I am fairly inexperienced with VBA, and I can't figure out how to make this loop. I set up 4 separate statements and it works this way, but I want to make this one statement.
i = 1
Do Until i > combos
Range(Cells(i, 10), Cells(i + Defrepeat…
I have a dataset with date1-date99 and there are at most 5 non-missing dates per observation. I want to only keep the non-missing dates and assign them to datenew1-datenew5. Any suggestions on the best way to to do this. I thought of doing and do…
Could you please help to get my head around why Do statement in the body of the method keeps looping infinitely?
I've created a class Guesser. The input is taken from a user as an integer within the main() method and determined answer as an integer…
I have a dataset of parameter values for 30 species, and I want to run a script that conducts a simulation for each species. The parameter values are currently stored in a .txt file, where each row is a different species, and each column is a…
I am trying to run this code
data swati;
input facility_id$ loan_desc : $50. sys_name :$50.;
cards;
fac_001 term_loan RM_platform
fac_001 business_loan IQ_platform
fac_002 business_loan BUSES_termloan
fac_002 business_loan RM_platform
fac_003…
