fnameandpath

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

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

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

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

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

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