existing

  1. M

    Macro to save selection into an existing workbook but into a new sheet inside

    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...
  2. P

    Copy Excel Range to Existing Powerpoint File and Specific Slide

    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...
  3. B

    unzip file and copy to existing worksheet from Cell ("I").

    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...
  4. S

    How to import a CSV into an existing worksheet? (Macros)

    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...
  5. M

    SaveAs With Path Macro Help

    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...
  6. P

    create new workbooks using an existing Excel template

    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
  7. D

    Modifying a Hyperlink SubAddress

    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...
  8. B

    VBA needed to reformat data

    <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...
  9. 2Ruff4U

    New Number Range is Unique from Existing Ranges

    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...
  10. C

    Combining existing PDF to macro created pdf

    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 ' '...
  11. L

    Change existing Pivot table data source to pull from Powerpivot data

    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...
  12. T

    Macro to Tell me if a customer is new old or existing?

    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...
  13. T

    Adding a column of data to an existing chart / pivot table

    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...
  14. M

    paste copied data in last row in macro

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

    How to paste copied data don't delete existing data

    How to paste copied data after the existing data
  16. M

    Vba - remove filetype (.xlsm) when using 'activeworkbook.saveas'

    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 " -...
  17. A

    Excel 2016: Excel VBA - Convert Worksheet Formula into VBA Code

    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 =...
  18. C

    Extract Table from Outlook Email and copy it into existing excel doc

    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...
  19. M

    VBA - copy an existing worksheet in Sharepoint to the same location

    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...
  20. T

    Get & Transform - I want the old SQL query wizard

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top