Search results

Found this code on StackOverflow. Can this be modified to print the PDF that opens up? Option Explicit DeclareFunction apiShellExecute Lib"shell32.dll"Alias"ShellExecuteA"( _ByVal hwnd AsLong, _ByVal lpOperation AsString, _ByVal lpFile AsString, _ByVal lpParameters AsString, _ByVal lpDirectory...

so, hard drive crashed. Lost everything. But with the attachments and the code that y'all have entered, I can pretty easily recreate the wheel. Don't be alarmed by the loud screaming, that was me as soon as the drive crashed! Anyway, I was constantly getting the run-time error, downloaded the...

OK, for the most part this is working now. It pulls up the appropriate PDF just like it should, still getting the annoying run-time error. Now to figure out removing the error and printing the thing...

Sorry, used your previous code: Private Sub CommandButton1_Click() Dim addr As String Dim objIE addr = "https://smithandnephew.sharepoint.com/sites/AWM_01/Us-Logistics/Documents/Shipping%20Information/Hazmat%20SDS/2009232%20UniSolve%20Bottles.Remove%20Adhesive%20Remover%20(Europe).pdf" Set...

We're getting there! I played around with the code and adapted it to the commandbutton1. I directed the addr = to the specific pdf (cut/pasted the hyperlink from sheet1). It sent the browser directly to the actual pdf. So we're getting closer. Now, how to tell it to direct to whatever part...

So question, this code points to an online pdf, is there a way to make it point to the pdf that is hyperlinked instead of specifying each individual link? I could, most likely do it this way with a lot of "if" statements but I think that would get pretty muddy...

Absolutely https://analysistabs.com/excel-vba/hyperlinks-examples/

I did some more searching and found something. Problem is, I'm not this adept at VBA, so the code doesn't really make a lot of sense (plus I believe it's only looking at local files instead of hyperlinked on the web). What do you two think? —–Copy this code and place in a new module Public...

Stevie Where would I place the code that you just showed? The link that it's supposed to follow should be whatever hyperlink is attached to the part number referenced in the combobox (ComboBox finds the part number on sheet 1, that part number is hyperlinked to a specific online PDF). Would...

I've attached another copy of the sample workbook. The new link is for product "1". It goes directly to a publicly available PDF that opens in much the same manner as my original.

Closest one so far! That takes me to the page that contains the PDF. Those links open up in Explorer. The actual link is to a PDF displayed within explorer. When I click on the link in the actual spreadsheet, it immediately opens the PDF (not just the page that has the link to the PDF). When...

I've found a TON of great posts on here so I thought I'd see if anyone here can figure this one out... I have a userform created that has a dropdown box. This is a list of products that are defined on sheet 1 as "SKU". Sheet 1's sku numbers are hyperlinks to an online PDF form. When the user...