fnameandpath

  1. B

    Input Photo Macro

    Hello! I am looking to create a macro that will input a photo intoa spreadsheet in a certain location. Ifound the below from a different user online: Sub GetPic1() Dim fNameAndPath As Variant Dim img As Picture fNameAndPath =Application.GetOpenFilename(Title:="Select Picture To Be...
  2. A

    VB Code to resize an image

    New<article>This code I am using but the issue is width of picture, it is not fixing in A34:C34 and stretching it all the way to Column P Please please help Sub GetPic() Dim fNameAndPath As Variant Dim img As Picture fNameAndPath = Application.GetOpenFilename(Title:="Select Picture To Be...
  3. S

    I Think I Need a "Static" But I'm Not Sure

    I'm trying to render the fNameAndPath in the code below into a cell on the worksheet the text was imported onto. I "think" one option is to set the fNameAndPath as a static variable so it can be reused. But . . the code below isn't failing, but neither is it putting the fNameAndPath in the...
  4. J

    VBA - File picker , XLSX & CSV

    Hi, I am having an issue with the below piece of code for myfile picker , it is working fine for excel files but the csv files are notvisable when the file picker is open. Is there any way of being able select either a csv or xlsxfile through a file picker? Any help is greatly...
  5. T

    find max value using column name || userforms VBA

    Hi guys, Need some help in finding max value in a column with column name. like search max value in a column with the column name I provide. conditions: column May or May not be present in sheet. there are 3 or 4 columns with same column name and I need to check all...
  6. Z

    Moving back to open file

    Hi All, I found some code to select a file to open. This works really well. I'm trying to build a macro that will switch to this file later on. Windows (fNameAndPath).Activate But I keep getting an error, I've tried to add " but no joy. Can someone help please? Original code: Sub GetFile()...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top