existing

Hi, im trying to use this .SaveAs Filename:=filePath & currentName & ".xlsx" to save copy in a specific folder using the current name but the problem is there are already existing files with this current name so it comes up asking to replace these files which i dont want , what i want is to go...

Hi All, I don't have any knowledge in VBA so can someone help me to generate an Excel range to an existing Powerpoint file and I want to paste it on a specific slide? I am using 2010 versions. I have checked some of the forums in here but it's not working for me. I have to copy an excel...

Hi, I am using the below code to unzip and copy a excel file. but the following code is getting copied to new excel. https://www.mrexcel.com/forum/excel-questions/984206-need-vba-download-copy-data-zip-file.html But I need to copy on existing sheet from cell "I". existing sheet: BSESTOCKS I...

Hello, I am working with the code below I found on the internet. The purpose is to automatically import a CSV file with some parameters, that's working like a charm! Sub ImportTextFile()'Import a text file using Excel's own import function. Dim vFileName On Error GoTo ErrorHandle vFileName...

I'm have trouble getting this to work properly. Would anyone be able to help? I can't seem to get it working :( Thank you! Sub Save_Workbook() 'Save current file in current location ThisWorkbook.Save 'Always automatically replace existing file with same name...

Hello, Is there any way to use a VBA macro to create new workbooks using an existing Excel template and have the new workbooks saved with each of the business days of the month/s? such as SSB Template Update.xls being saved as SSB 09.03.18.xls. Thank you, Peter

I am trying to modify an existing hyperlink from a VBA macro The existing link is in cell B1 (B1 through H1 are merged to fomB1 if that makes a difference) of worksheet("TestSheet") I want to change the existing subaddress from whatever it is to "UI!A", and the TextToDisplay from whatever it...

<tbody> Existing Data 600950 600951 600952 600953 600954 A 15 15000 300 B 200 1000 100 C 25 75 50 D 100 22 500 E 5000 80 F 750 15 600 G 100 1000 25 </tbody> Hi, Would someone help me write a VBA script to...

Hello, I track a large number of card ranges. These ranges are not sequential from one to the next and may not have the same number of digits in them. When I add a new range, I need to be sure that the new range does not have any values in it that overlaps any of the existing ranges. I would...

Hi there, I have created a macro to pdf certain tabs from a workbook. Easy enough but and I am looking to add an already existing pdf to the macro pdf once it is created. I currently have this code which is simply the code to create the pdf. Sub PDFReport()' ' PDFReport Macro ' '...

Hi all I am new to powerpivot. I tried searching the forum and in google for an answer to my question but I couldn't get an answer. I am hoping an expert in this forum can help me. So I have an existing data that I pull using SQL and then created multiple Pivot tables from this SQL data...

Hi Everyone, I have a list of sales going back to 1st jan 2017 I'm want to have a macro tell me the staus of that client according to what has happened up until that row, so for example, all cilents are listed down Column C, All Dates are listed down column G the sheet is in date order old...

https://ibb.co/cMOjRo Hi Guys, Relatively new to editing existing pivot tables. Trying to add a column of data to a chart that is linked to an existing pivot table. [Trying to add a June 2018 column per the attached images] But I am receiving the following message when I try toinsert the...

Can you please help me for how to copy data from another sheet and paste it after existing data . ( first column , Last row )

How to paste copied data after the existing data

Good Morning, I have a macro which takes an existing workbook, makes changes to said workbook and saves a copy of the workbook adding to the existing filename. The code I currently have takes the existing workbook name including the filetype and then adds the following on the end " -...

Hi all, How do I convert the below into VBA code? =IF(AB2=IFERROR(VLOOKUP(AB2,tblBRPDatabase[Primay Key],1,FALSE),"No Existing Record in the Database"),"Record Already Exists","No Existing Record in the Database") I have tried the below and it isn't working? On Error Resume Next x =...

Hey all, I've been scouring the internet for some kind of answer to this problem with no success, I'm new to VBA so more specific/complex solutions have been difficult for me to adapt(started teaching myself VBA and complex excel functions 8 months ago). My issue is: I do Sales Operations...

Hi everyone, I'm looking for a way to copy an existing file in Sharepoint to the same SP location. I know you can use the ThisWorkbook.SaveAs method to do it from within the file itself, but I need to be able to make a copy of an external file. Finding the folder path etc is not a problem, I'm...

I have office 365, and despise the power query... i use macros to modify existing SQL queries and update data in many spreadsheets. Unfortunately power query uses a more advanced SQL format which is completely different than I'm use to. And i'm struggling to find how to modify an existing...