filename

Hi, I have this below code which works perfectly fine. I need help to achieve 3 more tasks. 1. The number of attachments should not count if the file extension is png 2. The files with extension png should be shown or exported 3. Is there a way that the attachment(s) itself can be...

Hello, I -had- part of my program working until I realized that the length of the filename wasn't always constant and I need help fixing that. In the following section of code it used to look for a sheet names *CEQ* and extract the two numbers before CEQ and the two numbers after CEQ. I then...

Hi all, I was in need of a macro that embedded multiple files and I eventually got it. However, I need to resize the icons and get their names (file name / source name), as none of the names are shown but only blank icons. Although I thought I had captured this pieace in the code below...

Hi there I have several workbooks in one folder that I need to open and copy a number of cells (G2:O2) from the same sheet name ('Output Create') for all of the workbooks into a 'Master' spreadsheet. Within this Master spreadsheet Column A contains a name of a place, which partially matches the...

This is what I want to do. Can someone help with code please. Not sure of the correct MAC syntax for the path, used to Drive letters in Windows 10 Select RangeA2 to I44 Use the filename that’s in Cell H10 Save as PDF to Path DATA1\DATA\DROPBOX\\BUSINESS\PDFINVOICE (Filename as in Cell H10)...

Hi. I can open a file remotely but am trying to create an error handling routine where, if the file is closed, open and update the links. If the file is already open it gives a FileInUse error and gives you the option to open it as read only I have been messing around with some code and ended...

I have a small script that logs when a user opens an excel file. Currently the username and date/time are populated in the txt file. I would like to add filename to the txt file, but not sure how. Thanks Private Sub Workbook_Open() On Error GoTo errhandler: Open "D:\Reports-Service\Old...

Hello Experts! I am using the following to successfully create an email and attach a pdf to it. All works great, except the email signature does not show. I believe the signature is being replaced with the body text. outlookmailitem.body="Hello,"..... I am very new to macros (less than...

Hi need some help, i try to search around the forum but seen not able to find one i want. Step 1 (list filename of Folder & SubFolder), there will be a POP-UP and ask user to select the path Step 2 (rename filename base on col C) & Status update on Col D Isit gd ideal to display ext...

Hello, I hope i can get some help from people whom i regard as super smart. The code below (that i have managed to get from others) finds the username and computer name so that other users would be able to use the same code on their computers. I had hoped that the code would also open the...

I'm trying to reference a filename and path that I've created with a formula. I can't get it to work either in a formula or with a Macro.

Hello every body, i hope that some of you guys are able to help me out. i have to get multiple excelfile into one file, but i want to make an inputbox, so that the user are able to choose between different folders. The code looks like this so far: Sub Samling() Dim FolderPath As String Dim...

I have my code mostly complete - except for a few minor edits that have me stumped! I need all sheets copied to the new workbook except Sheet2 (ODBC_TABLE). If possible, I'd also like no headings and password protected. Any help would be appreciated. Thanks Sub New_Syscofile() Dim Output As...

Good Day, I would like some help on appending a duplicate file name during a looped save. Name Name (2) This is my current code: Sub WM_Save_File() Dim Path As String Dim fileName As String 'Move Original File Name Range("d1").Select Selection.Cut...

Hi Everyone, Below i have a code which copies based on cell values(Highlighted) but instead of cell values, can we copy through cell name (Cell names which would be only in "Column C") FolderName = Worksheets("copy").Cells(2, "K").Value & "\" If FolderName <> "\" Then FileName =...

Hello, Can this be possible to add the filename and date when importing excel file. I have a table of import file and i need to add the filename and date to the table for the records purposes. Is also possible to select the file. Any help is much appreciated. Thanks

I've managed to save an active worksheet as a pdf using the following: Sub save_as_pdf() Dim Path As String Dim filename As String Path = Range("B35") filename = Range("B36") ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, filename:=Path & filename & ".pdf", Quality:=xlQualityStandard...

I'm getting a compile/syntax error when i try to run this macro. Can you see what i've done wrong please? Sub filename_cellvalue() Dim Path As String Dim filename As String filename = Range("B31") ActiveWorkbook.SaveAs Filename:=filename, FileFormat:=xlOpenXMLWorkbookMacroEnabled End Sub The...

So basically im trying to make this formula do two things 1) Make it to where the file doesnt have to be opened in order to pull data (file has to be closed in order to do certain edits with my job) 2) Make it to where the file name can be dynamic because its being changed every 30 minutes or...

My question is, how do I find which consecutive rows are grouped then store those rows and use them for other columns. I'm trying to create a macro that allows me to take data from an excel sheet and place it in bookmarks of a word document. Below is the code I already have Sub DocGenerator()...