save file

  1. Jyggalag

    Error in vba code (macro) that saves my file in folder?

    Hi all, I have this macro: Once I press the macro "Save file to folder", I get the error above, and debugging it leads me to this: I want to save my file as a PDF file in the path above. Any idea why it does not work and how I can fix it? Kind regards, Jyggalag
  2. I

    How to use VBA to save a file to desktop regardless of user?

    Hello. I am trying to add this to a longer VBA code I have. I need two separate codes. Both of them I need Excel to save the active workbook with the file name (one being Pickorder1 and one being Pickorder2) along with today’s date. So save it to the Desktop regardless of user as this will be...
  3. D

    Run-time error "53": File not found

    Hello everybody, I am currently having a problem with one of my files. I have made an order form where people can order goods from. They download my excel sheet and click on a submit macro which sends out the excel sheet in a PDF file through email. This works perfectly fine when I do it...
  4. K

    URL Download to File

    Hi All, I need some help regarding downloading a picture and then save it in a folder. Right now i have the following: Private Declare PtrSafe Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As...
  5. S

    Save file through Internet Explorer

    Hi guys, I am trying my hardest to figure out how I can save a pdf file on a website automatically. I have got to the point where I am prompted to Open/Save/Cancel the file. I want to be able to save the file automatically into a folder whose path is specified by a cell. Thanks for any help...
  6. J

    12-48 hours to save a workbook. Please help me understand what's happening.

    Excel 2013 Pro, 64-bit on windows 7 running on a quad core i5 with 8Gb ram. All files are local. The file is averaging about 150 Mb and links to six others which in total average about 100Mb. It has five Powerview worksheets which each reference the one Table range. This Table is 38k rows by...
  7. R

    Saving a Workbook - Excel 2013

    Hi, I have a Macro Enabled Workbook (Workbook A) that I use GetOpenFilename to open another Workbook (Workbook B). After changing data in Workbook B from Workbook A, I wish to do a Save As on Workbook B from Workbook A. Is this possible? In Workbook A I have the following code: Private Sub...
  8. E

    Extract rows from multiple files and rename each file

    Hi. I have several excel workbook files in a folder. I want to go through each file and extract only those rows that contain a certain number in A1, then rename and save each new workbook with the extracted data to a folder.
  9. S

    Loop filter then save new file

    Is there a simple way to loop through and filter the values in col1, then save it to a file named by the filtered value? Would be good if it could keep all the formatting aswell. I bet I need a macro for this huh?
  10. S

    Attaching Excel through VBA

    Hi, I am trying to add a spreadsheet to an email and came across a code on another thread on here that works really well. The only problem is that it sends the original saved version of my spreadsheet. My user will be opening my spreadsheet from an intranet page and the vba will need to...
  11. J

    Save File To Folder

    Help would be appreciated. I would like a script which would save my file named Xtemplate to a folder named C:\Temp\ExcelTemplates\ The only thing is I would like it if the script could add a new number to the file name if the file already exists in the destination folder. I.e. Xtemplate...
  12. S

    Save .xlsm using PC name if file does not exist

    Hello All, This will be my 1st posting and I would greatly appreciate some advise on the best way to handle what I am attempting to accomplish. Basically, I would like to open an excel workbook file (.xlsm) and rename the file using the PC name ("Book1" & PC_Name). Obviously, I do not want...
  13. D

    Disable the Ctrl-S

    I have disabled the Save and SaveAs features but I need to know how to disable the control-S key to prevent from entirely saving the workbook. I used the ---> Application.Onkey "^S", "" but it doesn't work. Does anyone have other suggestions? Thanks.
  14. F

    autosave if workbok left idle or after set amount of time

    I seen a macro that if the workbook set idle or was left open for a set amount of time it would save the workbook. I really need that macro or if someone can give me one I would really appreciate it. Thanks in advance
  15. G

    Saving a File

    I would think that this would be easy to do, but I cannot figure it out. I have searched the boards as well, but I couldn't find the answer. Basically what I am doing is a macro that copies info out of one workbook into a new workbook and doing some manipulation of that data. The problems comes...
  16. H

    Macro to save to a certain location

    Hi I need to add a save button to a worksheet that will save the first page as a txt file with a username that comes from data within certain cells. Using the following for an example; C7 Joe Bloggs E3 22-02-09 G4 Dr Noone Save location B:\Test_Results\Machine_Results\Dr Noone\Joe...
  17. S

    Code to automatically save workbook automatically???

    I am wondering if anybody has a code that I can paste into my worksheet that will automatically save the workbook every once in awhile??? Or maybe every time there is a change to it or something??? Any ideas??? Thanks!!!
  18. M

    Backup Any excel on my Laptop

    I am a beginner in Excel, I have few XL which I want to make archives after I close those XL. I have seen on this forum many macros but all of them are specific to any file. But if is it possible to have global macro on a PC and which can archive all XL file which can be new one or old to...
  19. F

    Unable to Save Blank Form with Mandatory Fields

    I have a macro to prevent users from saving a file leaving mandatory fields blank. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Cellcontents =...
  20. P

    VBA to Open new file, Prompt, and then save

    At work we have about 10 different excel programs that we use regularly, and we're trying to create a control panel program to make things easier for the less technically inclined. The control panel program (currently named "Control Systems.xls" needs to be a shared workbook that has the...

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