filename

This code is supposed to save the file as PDF to my pc and after that mail the XLSM and PDF file as attachments in an automated mail... but my pdf's dont get saved properly because my code is wrong and I just dont know how to fix it, does anyone know how I can fix it? Sub saveandsend() Dim...

Hi guys, I’m fairly new to VBA, and would appreciate your help with the problem I have. (will look forward to learning lots through the forum going forth!) I have 12 xls files and 16 xlsx files that that get updated in the same folder every week. (same pathways to make Macro to work). Now...

I have created a macro to copy from one cell to another in another workbook. Although works perfectly fine on windows, it doesnt work on Mac I am not a pro, can anybody help to get it work on Mac please Here is the Macro : Sub Make_New_File() ' ' Make_New_File() Macro...

Hello All, I apologize about the title of this post, it may not be the most fortunate. I have searched through the web, but i can't seem to figure out result of my problem. What i'm trying to do is next: Use vlookup in one file and pull data from the other file. Sounds simple enough, but for...

I need to load a file using power query, I can do this if the name of the file does not change but how do I do it if it contains a date. Example. Filename 20190131 Many thabks , Mike

I have recorded a macro and now it is giving me a runtime error 1004 "There's a problem with this formula" in connection with ExecuteExcel4Macro. I have tried with double quotes without success ExecuteExcel4Macro "(2,1,"""";;;@"""")" Can anyone point to an error in the code? Sub...

I get no errors when running this code, however the data in the text file does not appear in Sheet1, which is the only sheet in the workbook? I also want to refresh the csv file in case the data has changed. Sub Button1_Click() Dim ws As Worksheet, destRng As Range, fileName As String...

Dear Expert i have 3 file A.xls, B.xls and C.xls in E drive, now all file have more than 100000 row, i just want to combine all three file in one file. for this i am using below code but it not working and show me error at Filename = Dir(FolderPath & "*.xls*") Sub ConslidateWorkbooks()...

I am getting the error Compile error: Syntax error on this line of code: Set wbSource = Workbooks.Open Filename the wbSource variable is declared. What else might be going on? Sub GetOpenFName() Dim FileName As Variant Dim Filt As String, Title As String Dim FilterIndex As...

Can someone help to simplify following VB code If I use something unnecessarily like "Select" etc.

I am using following vb code to save file with cell range; I need to amend it that if file already save with this name, it should save the file with extension for example, if file name ABC.xlsb already there, it saves as ABC (1)

Hello, I canot extract the filename without ".xlsm" because of the dots in the name. The filename is: "Test 01.01.2019" Here are my tries: FileName = Left(ThisWorkbook.Name, Len(ThisWorkbook.Name) - 5) FileName= Len(ThisWorkbook.Name, InStrRev(ThisWorkbook.Name, ".") - 1) The...

I have been working through VBA code that copies the first worksheet in a folder to another workbook. The code copies the data correctly but upon saving I get certain cells with errors (#Ref) this is due some of the copied cells having formula. I would like the copied data to retain the...

Guys, I have this Loop which retreives a certain Range of data from each file. This is the source: https://imgur.com/RqJL8Pt Now i paste this this data in a masterfile by using below code. Sub GetDataHalA() 'DECLARE AND SET VARIABLES Dim wbk As Workbook Dim Filename As String Dim Path As...

I have been working through VBA code that copies the first sheet in a workbook from a folder to another workbook("Master"). The code copies the data correctly but upon saving I get certain cells with errors (#Ref) this is due some of the copied cells having formula. I would like the copied to...

Hi, I have a list of paths that I need to extract infomation from - <colgroup><col width="625"></colgroup><tbody> u:\Folder1\Folder 2\Folder 3\Info1\Info2\filename_info1_info2.xlsx </tbody> What I need to extract is Info1, Info2 and just the "filename" into individual cells. I've...

Apologies if this is a duplicate I have one workbook getting data from another- FileB (destination) imports data from FileA (source). Both files are in the same folder. This works fine EXCEPT when I make a copy of FileA using Save As to a different folder with a new Filename. Save As to...

Dear Sir I am using following code to save as file as cell value name, its working fine, I just need to be on same original file again after this code The original file should not be closed

If sheet "filename" found, Save sheet "filename" with ID in A2 in C:\Users\SR\Downloads\CSV as CSV file. If the same name appears in folder save file with name(number) but do overwrite it. Also, define the range in columns and rows (say a1:x5000) so that the saved data can be adjusted.