save

Hi I copy a range from one workbook, then creating a new book to save this data in. I’m trying to save this newly created workbook to a directory and name the workbook as a value of a range in that newly created workbook. That is range(“G1”) which is a date in Excel numeric (43735). My code for...

Good Afternoon Mates! I want to make an excel sheet which will not allow the user to take print until the the latest changes are saved. Actually I have created a file which requires "password to modify". Without entering the password, one can access the file with "Read Only" mode. But, in read...

I was trying to create a macro that when I open a workbook that is macro-enabled I could simply run some code that will change it to an xls or xlsx and save it as the current file name. I need it to save it to its current location. Thanks as always

Hi am not able the add some contains if i save as the active workbook . I want to save as the excel file based on tab name with add additional contains in mid if my active tab name is ML51HJ0 MTD Aug(tab name not fixed it will change) my query is save as the file name ML51HJ0_AcntAnalysis...

From what I have now as below, I need to take the data generated, save to a new sheet and then rename that sheet to tomorrows or the next working days date (taking into account weekends/public holidays). Is this actually achievable, or at best to excude weekends. In additon can I alo insert...

I've gone and donked up my XLSB file somehow. i can access the workbook itself but i can not save it, nor can i access the VBA editor to fix whatever vba code is causing this in the first place. should i just delete it? I don't want to delete it. I don't have a current backup of it i do not...

Where can I go to find out why excel takes so long to save a large file, continually bogs down while performing macros etc. I use several different large spreadsheets with lots of calculations going on, they run and save quite well on my PC but bogs down on my assistants PC. Here is one error...

Hello All, I have a spreadsheet with some code for auto-population of cells, this requires the spreadsheet to be saved as "macro enabled". The problem I have is that the code cannot run in "Shared" mode. So I would like to add in some further code to automatically save then close the...

I realise I am a little out of date Excel-wise as I have spent the last year and a half on Excel 2010 and found the Save Workspace feature incredibly useful (this after **** near 20 years of never having touched it before). As far as I can see it has been removed in later versions (I'm now...

Hi all, If possible I need a VBA that does the following:- Saves the current workbook then, Save as/copies the workbook into txt format. I have the following code but, it appears to be bypassing the first step (just saving the sheet) before moving onto the second step...

Hi all, I've confused myself once again and can't figure this one out. I'm trying to figure out the macro to save file as a PDF in the Set Printing Area and attach the PDF file to new email template in outlook so that way the user can write who it's got to be emailed to. And if it's possible...

I have a routine which prompts the user to choose a folder to save an embedded Word document as PDF; FilePath = Application.GetSaveAsFilename(InitialFileName:=File121, FileFilter:="PDF Files (*.pdf), *.pdf", Title:="Select Folder to save") It works fine, except if the user clicks cancel in...

Hey all, i've done searches on this forum without finding much luck as to why my macro isn't working. I'm trying to have a macro assigned to an object that once hit will save the pre-filled file name (as shown in the example below). Here is my coding so far: Sub SaveFile () Dim FN As String...

Sub CopyActiveSheet()Dim ws As Worksheet Dim wb As Workbook Dim Pth As String Pth = ActiveWorkbook.Path & "\" Set ws = ActiveSheet ws.Copy With ActiveWorkbook ws.Cells.Copy .Sheets(1).Range("A1") ActiveWorkbook.SaveAs Filename:= _ "K:\Work\Admin\Schedule\September\14.xlsx"...

Hi all, Good day! I would like to ask for your assistance on this project that I am working. I have a UserForm that goes like this: I have a code in place in the 'Save Form' button that transfer the data from the UserForm to the Worksheet in the same file. The data is entered from Cell B9 to...

I have code to save as a pdf but it defaults to the directory that the spreadsheet is located in. I want it to ask where it wants to save the file. Could someone help me with updating this vba code please? Sub save_pdf() Dim currentSheet As Worksheet, fname As String fname =...

I need a procedure to save a document as pdf. The default file name needs to be the value that is entered in cell G7 + value entered in H5 as one word. Could someone help me with this please?

Hi all, I've got a few spreadsheets where I've added buttons to make it easier for people to save files to a specified location. All seemed to be going well, however... Last week I enabled file extensions on my PC, as I needed to swap some files from .txt to .csv (it was some file splitting I...

I have a workbook that looksup values and does reports and has some graphs in it. The graphs used to automatically update when I change the record number of each file. Now it doesn't. It only works if I chnage the record then save the file then re-open it. Help please!! :confused: