sloc

I was recently upgraded to Windows 10. When I run my macro in Excel (2016 MSO 64-bit) that is supposed to create an outlook email and attach files from a specific folder, only some of the emails generate now. If both of the Excel files noted in the code don't exist in the folder, Outlook no...

Good morning all, I have come across 'Run-time error '1004': - Method 'SaveAs' of object '_Workbook' failed. The code is below. Any help would be greatly appreciated. Many thanks, Sub SaveAsPDFExcel() Dim fName As String Dim sLoc As String 'location sLoc =...

Hi all, I am getting a debug error with the red text below. I am unsure why there is an issue with this, any ideas? Many thanks, Sub SaveAsClosed() Dim fName As String Dim sLoc As String 'location sLoc = "I:\FST\Quality\Non-Conformance\Non-Conformance Reports\Open\Closed\" '...

I need to save sheet as pdf. Have tried numerous codes from examples and continue to fail. Getting Runtime Error 1004; Document not saved. The document may be open, or an error may have been encountered when saving. Sub SaveAsPDFExcel() Dim fName As String Dim sLoc As String 'location...

Hi, I have 2 pieces of code I would like to put into one so that 2 of the worksheets save in one folder, whilst the other saves in a different folder. Problem is, I would like to run this from one button and it doesn't work running both of these from the same button. Code as follows: Sub...

Hi all, I have the following code that I would like to adapt to change from saving one worksheet to saving two as a pdf. The worksheet names are "NCR" and "RCA" and the code is as follows: Sub SaveAsPDFExcel() Dim fName As String Dim sLoc As String 'location sLoc =...