path

Hello guys, I am trying to automatically send PDF's of invoices through Outlook, and I was able to send the PDF correctly, but once I switched up the code for a Dynamic name change, I can no long get VBA to find the PDF. Below is my code: Sub sendReminderMail()ChDir "C:\Users\rbs\Desktop"...

Hello all, I was creating a VBA code to insert a PDF to an email. I was able to do it basically, but once I changed up the file name & path to be dynamic, it could not find the PDF document via the new naming criteria. Below is my code. Sub sendReminderMail()ChDir "C:\Users\rbs\Desktop"...

Hello All, I'm new in the forum and after exploring the multiple (great) threads in the forum i have managed to create VBA code to: - list all files in folder, subfolder and more subfolders using FSO function and loop calls of the same to get all files captured from path in designated Range...

I have a workbook with multiple sheets. The first sheet is a summary, and the following sheets are used for adding new data. I have a macro to convert one data sheet and the summary sheet to a pdf. I would like the data sheet to be first, and the summary to follow, but I can't seem to get...

I have this macro that email's a specific range from an actvive sheet that works perfectly until I try to add an attachment from a file path on my computer and this is where I get the 438 error. What am I doing wrong? Any help is greatly appreciated. Sub Email_Test() MsgBox "Email will be...

Thanks in advance for anyone that can assist. I am trying to make this formula work, and I continue to receive #REF errors. =INDEX(INDIRECT("'"&SETUP!$C$59&"[PPM Dashboard.xlsb]DATA1'!$K$3:$K$32"),MATCH($C3,INDIRECT("'"&SETUP!$C$59&"[PPM Dashboard.xlsb]DATA1'!$C$3:$C$32"),0)) The path it...

Good Evening, I've missed something I guess (and I know my code could probably be a lot more efficient) because this code below is intended to take a file, save it under a new name (as specified from the address and new names in the workbook) and then delete the old one. Ideas what went...

I have a folder on my desktop with a bunch of subfolders by peoples names (i.e. Subfolder1 = DOE, JOHN; Subfolder2 = SMITH, JOHN, etc.). When I change cell "B2" in the spreadsheet and run the Macro, I would like it to save that sheet as a .pdf to the applicable person's folder that is listed...

Hello, Briefly I have a code that creates a separate non-macro version of my workbook and saves it with a different name. Works well when used as a normal Macro. However, now i'm trying to get it to execute when my workbook is saved (to keep from having to press a button to save the non-macro...

Dear experts I am new to VBA so please bear with me. I have an excel workbook with buttons to open other workbooks. Right now this is hard coded so every time I put it on a new computer I need to reconfigure the path. Also, if a user moves the other workbooks to another directory I will have...

Hello, Briefly I created a macro that saves my workbook as two versions--a macro enabled version and a non-macro enabled version. The macro works correctly. HOWEVER, it crashes my excel every time I run it. Also as a background, my code saves the second workbook as the same name but with...

Hello, Briefly I have a macro that saves my current workbook as two different files--one that is macro enabled and one that isn't. Runs well. HOWEVER, I cannot for the life of me get my second file to save based off the name of the first file. For example, if my first file is saved as...

Hi forum, I'm trying to automatically save workbooks using VBA to a Sharepoint folder- which needs to be created first. Code I have below works ONLY for saving the file. The MkDir function returns a Run-time error 76: Path not found. I'm at a loss what causes this error, because the path...

Hi all, I am new to this forum and this is my first post here since I have been searching through the web but cant find an answer:) I have an excel called NAME and the first and second column looks like the below table, essentially the name and date is used to construct a set of folders and the...

Hi All, With some help from you guys on here i have manged to build a small database which i want mutlple users to be able to use. The file itself is on a shared drive where all users have access to be able to see the file in question. The only issue is when they click on it to open it they...

Hi all.... I was hoping to add a bit more to my current macro. It will open a file (path is hardcoded) with the filename based on the value of cell D1. it all works well, but would like to add somehow that if a filename does not exist in the path with the same value as D1 that a message box...

Is there a way to make this save the copy as read only? path = "\\hinas1\MFG\LED\SSL Paperwork\U502\U502FogLBFirstArticle" nom = Left(ActiveWorkbook.Name, (InStrRev(ActiveWorkbook.Name, ".", -1, vbTextCompare) - 1)) & " " & Year(Date) & "-" & Format(Month(Date), "00") & "-" &...

Hi All, I save a file is some path, where the file is saved as Read-only recommended. But few of then are opening as write and overwriting the file. Can i have a macro, when the user saves the file, it should pop-up the msg saying they are not allowed to save the file in that path and show the...

Hi, Could you advise the code for the following please,i will then continue from there with the others i need to do. I will add this to a button to transfer cell vales to my end of month sheet. Worksheet called INCOME1 Copy cell value E32 & paste to Worksheet path shown below...

Hi Guys. So, I have a new user for the main PC (Logging in with own PC login details), and the Doc that I need all users on the PC to be able to use has the below lines of code that is currently causing a 'Run Time Error 76 - Path not found' error message for debugging. However, I have compared...