save file

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

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

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

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

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

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

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

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.

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?

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

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

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

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.

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

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

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

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

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

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

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