VBA Open file and convert to PDF

[Cagey93]

Hello, a real novice here so excuse the probably simple question but I cannot locate an answer.

I have a master workbook which contains lots of file paths to other workbooks. These locations change every month so to get around it I have a sheet which automatically updates the file paths each month.

However I am struggling to get VBA to read that file path which is specified in the cell.

This is a smaller example but I have specified B10 and B11 as the path to open as they will always change but what code do I need to do which say Open "filepath1"

Sub Convert()


Dim filepath1 As String
Dim filepath2 As String


filepath1 = Range("B10").Value
filepath2 = Range("B11").Value

Workbooks.Open (filepath1)


End Sub

 

[BlueAure]

Hi Cagey93,

This code works for me. What do the values of those cells look like? It should be a simple file path to the worksheet you want to open. Example:

C:\Users\[USER_HERE]\Downloads\excel\New Microsoft Excel Worksheet.xlsx

No quotes or anything in the cell.

 

[Cagey93]

Hello,

the file path is as follows which I have triple checked is correct [TABLE="width: 616"]
<tbody>[TR]
[TD="width: 616"]"\\companyname\Treasury\D&I\MACRO TEST\Excel 1\April\TESTERApril.xlsx"

obviously the company name is an actual name but I cant post that on here. [/TD]
[/TR]
</tbody>[/TABLE]

 

[BlueAure]

Are the quotes included in the cell? If they are, remove them.

 

[Cagey93]

No they aren't sorry I just put that to highlight the that from the rest of the reply. I have tested the file path is correct by copying it into an explorer window and it loads it no problem.

 

[Fluff]

Does B10 contain the full path & filename?

 

[Cagey93]

Solved it silliest mistake I had moved it to another cell and didn't update the cell it was looking at, been staring at it so long but missed the obvious one.