relative path

Hello. I am trying to run a code that after reading the value of cell "A:2" must display a picture in the active worksheet. This is my code: Public Sub insertpicture() If Intersect(Target, Range("A2")) Is Nothing Then Exit Sub End If Dim myPict As Picture With Range("A20:J20") 'Set myPict =...

I am trying to figure out how to copy a range of data from a open file WITHOUT naming a file path. The file path varies, and is a temp file downloaded from our system. I would only like to apply this macro only when a file called pricedownload.csv is open My work team each downloads a pricing...

I have a WinForm, which I'm calling via VBA's Shell command: Sub Button1_Click() Shell "C:\\TemplateFuncitons.exe " + ActiveWorkbook.FullName, 1 End Sub I made this module an Excel Add-in and added it as a button in the quick access toolbar. Now, the idea is for the WinForm.exe and the...

Hello, so I had to manually insert hundreds and hundreds of hyperlinks that link to PDF files on a network server. When I finally finished linking all on my list and going back through, I discovered that when I clicked on many of the hyperlinks, it popped up a message saying "Cannot open the...

This is a frequent problem for me. When I save a macro-enabled workbook that contains function procedures into a new file name, when the workbook attempts to use the function procedures, it is looking for the function procedures in the old workbook name, not the new one. Borrowing some...