fname

Hi all, I have the following code and all is working ok, apart from it is no longer adding my set signature in Outlook . If possible could you have a look and amend as required. Sub ScorecardPdfEmail() Dim OutApp As Object, OutMail As Object Dim fname As String, sendto As String...

I'm having issues with this code not saving my file. I get an error 1004. it worked before. does any one see any issues with this code? Option Explicit Sub SaveAsPDF() Dim strDir As String strDir = CreateObject("WScript.Shell").specialfolders("Desktop") & "\Daily Reports\" If...

Hi Exports, I am trying to save excel worksheet to PDF however encountering runtime error 1004 with the msg with reads as "Document not saved. The document may be open, or an error may have been encountered while saving. when clicked on deburg, below in bold is highlited in yellow. Kindly...

Hi, I have the below code that will convert my active sheet to a .pdf file to be emailed. However, I am looking for code that will attach the active xlsx or xlsm sheet to an email. [Code] Sub CreateEmail() Dim olMail As Object Dim ws As Worksheet Dim fName As String Dim olApp As Object...

Hello All, I am hoping someone can help me with a problem I have been surfing the forums trying to find a solution to for a few hours now. I have an Excel macro file which will be stored in our company's SharePoint which will be used to track contracts being created and also serve a process...

Help with macro please. The Sub below works fine with Excel using Windows 10 however I am migrating to Excel in MAC. When I run the macro I get an Error while Printing message. If I go to DEBUG and change the path to “DATA1\DATA\DROPBOX\BUSINESS\PDF_INVOICE" I still get an error but this time...

Hi need some help please I have the following VBA for a report which copy's over Specific data from one workbook to another workbook in therange & tab I need it to, however I would like it to automatically know thefile path & report I want the data copied from, this code currently askswhich...

Can anyone help please? It looks right to me but when the macro finishes, it pastes my formula in AC1:AC3. There are breaks in the data however, by pressing Ctrl and End it takes me to cell AC520. Sub ConsolidateTimeSheets() Dim Wbk As Workbook Dim ws As Worksheet, wsData As Worksheet...

I have code to save as a pdf but it defaults to the directory that the spreadsheet is located in. I want it to ask where it wants to save the file. Could someone help me with updating this vba code please? Sub save_pdf() Dim currentSheet As Worksheet, fname As String fname =...

Hello VBA Guru's, I have this code which I use to search a directory for a word doc and if it exist in the spreadsheet then it copies that file to a new directory and marks on the spreadsheet as moved, Recently we changed from Word docs to PDF files and I cant work out how to make it do the...

Hello all, I have this code that searches a directory for word docs and if they exist in the spreadsheet it then copies them to a new folder but recently we have changed from using word docs and now use PDF format but I cant seem to find away to make this script work for PDF files, Does anyone...

Folks, I wrote some VBA code to save files with a certain naming convention. However, the overwrite warning is not showing up and I would like it to. Below is my code. Thanks! 'save as dialog Dim fname As String fname = "Wafer " & WID & ".Ellpis." & ReadType & "." &...

Hi guys I want to save a single worksheet from a .xlsm workbook to a new .xls workbook, overwriting any version already saved without alerts. I think what I've got is OK but I'd appreciate any words of wisdom from you. Sub SaveAs(grpID As String) Dim fName As String Dim...

I have the code below that opens up a file based on based ona number entered into a textbox in a userform (named frmLOAD). It works as is but I really need for the user to be able totype what they need to open in the textbox and a directory box pop upprefilled with what was keyed in the textbox...

I have macro that a couple of folks on this board wrote for me from a previous request. It works great, but after users started using it I found that some sort of check needs to be put into place. The way it is written it goes and looks in the users Downloads folder on their computer for two...

I'm trying to attack a problem from a different angle. I posted last week about wanting to open two .xls files in my Downloads folder that begin with "report" but have a ever changing numerical sequence after. For example, report1564504574214 or report1564504538987. Then I depending on what was...

Hi Everyone, I am trying to copy particular cell values from all the excel files in a particular folder Here Master sheet is the main sheet in which i need to copy the values from other excel files Here is my requirements, 1.I need to search for all the Excel files in a particular folder...

Hi, I am still fairly new at coding. I have this macro (not mine, I didn't write it) that works perfectly but I don't want it to copy. I want it to cut and paste the files instead of copying. That way, they no longer exist in the folder from where I moved them from. I have tried to figure it...

I'm an idiot or something. I took, what I thought were pretty straight forward directions on here, but it's not working out for me. MISC S1 has a month in it. I get an error no matter what I do with the "Set ws = Sheets(MySheet)" line. I just want that "JUL" to change depending on the cell in...

Hi All, I'm currently trying to copy certain worksheet in my workbook and then save it as new excel file in download folder. Sub RectangleRoundedCorners1_Click() Dim FName As String Dim FPath As String FPath = "C:" FName = "ResultsLessThan" & Format(Date...