save

Hi I'm designing a database which has an Excel front-end and uses Access for data store. Each save from Excel to Access is a normalised table showing data for: A (one) Client which has 0 or more Jobs and where each Job has 0 or more Transactions If I need to reload previous saved states for a...

Morning all. I have written my first little bit of code totally on me todd and got it to work :) kind of. Basically I have an excel file called template whcih I copied to a new folder. Opened said file and ran my code which enters date into cell B2 then saves the files as e.g. Week Ending 25...

Hi Exports, I am trying to save excel worksheet to PDF however encountering runtime error 1004 with the msg with reads as "Document not saved. The document may be open, or an error may have been encountered while saving. when clicked on deburg, below in bold is highlited in yellow. Kindly...

Could anyone let me know how to write a few lines to save a selected range to blah.scr on desktop. The range is A1:A12 on worksheet "DATA_1". I have other worksheets on this file but my files are exported into that sheet. Also is there a way to overwrite the file each time anyone press the...

Someone wants the meeting dates they have held to be recorded and to be retrievable. This kind of makes me think a proper database is required, but maybe someone has a reasonable format where this can work. The workbook has already been setup to save the dates for a particular job number, but...

Hello, Still new to excel and needing a little help. I have a workbook that i need to have the user save weekly into their archive folder located within the same folder the workbook is held, however the file path changes depending on the user. I know i had it close as i can get it to save into...

Morning All, I have tabs “Info”, “Dash”, “Projects”, Dates” and “DatesInfo”. I would like to copy them to a new workbook with the same formatting but values only to remove the formulas. I would like to save the file name as ‘Performance Dashboard - DD/MM/YYYY’ with today’s date in the same...

Hello, I -had- part of my program working until I realized that the length of the filename wasn't always constant and I need help fixing that. In the following section of code it used to look for a sheet names *CEQ* and extract the two numbers before CEQ and the two numbers after CEQ. I then...

Hi all, Below is a trimmed down version of the code that I'm attempting to use, the code executes fine when attempting to save using Ctrl s up to the point of hitting the save button on the file dialog pop up. At this point the pop up closes and nothing happens, no file is saved. Using save as...

Why does Excel prompt to save changes when closing a file if no changes have been made? In fact, it doesn't do so consistently with all files, but I do have one file that even if I open it and them immediately close it without doing a thing, it still prompts me that changes have been made...

Hi guys! long time no post! I was asked to do something at work that I havn't done in a while, but luckily I saved the VBA script, its a script that matched different workbook sheet store numbers and exports them to their corresponding network folders, luckily most of the script still works...

Hi, I have a CSV and have formatted the date as DD/MM/YYYY but when I save the file and come to reopen, the formatting has gone, any idea why please?

So File1 is a macro-enabled file. <br> It is named "S Form MMDDYY".<br> It is saved on a network drive in this path: "Reg/Reg Reporting YYYY/MM-YY/In House/Form S"<br> 1. Copy Paste Values of three tabs into a new file. The tabs have static names - "Tab1" "Tab2" "Tab3" 2. Save File into a...

Hello i need a macro that will Save the current active sheet as a workbook Any help would be greatly appreciated Requirements: Save active sheet as a workbook Values only Save to specific location E.G. "C:\Users\Username\Desktop" Save the file name as "text" & " " Active sheet name

I have an excel sheet that used to save the Excel worksheet as an html and autoRepublish everytime the Excel workbook opens. However, I have removed the old files and created new autorepublishes. However, I keep getting the following error since the Excel workbook is trying to save over htm...

Hi, I use a Workbook in work which I need to Filter a lot of the data in, I have been using Macros to do this very efficiently but the file has been updated and now has the sheet protected which prevents the Macros from running.(Run time error 1004 - You cannot use this command on a protected...

I have a file that I am using as a template for divisions to retrieve productivity report. So when user opens (Read only), he then logs in and their particular division(s) data will open. Since it is read only. I t prevents people from saving over the file so all can use as a template and I...

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