saving

Hi, Firstly, my knowledge of coding is basic at best....i've looked on various pages to find a solution and concluded the below. However, whilst everything works perfectly, unfortunately i cannot seem to get the file to save to the correct folder. I keeps saving to my documents!! Sub...

I have separate text files that need separate editing at the same time always. I would like to find a way to have Excel open each file in a downward column so that I can edit each line side by side. Example would be, I need to go to line 40 in row one, change some text, tab to row 40 on next...

Hi, can u please also confirm what to do?

Hi, I've got a countsif <>0 formula that isn't working. I'm counting across a big number of columns, and it's every 3rd column. I've got...

Hi all, I am have issues saving a workbook in a different location as a backup to the original however when using the code below I am finding that some of the detail is being lost. Can anybody help with the code as I can see there are various settings that can be chosen. ActiveWorkbook.SaveAs...

Hello, I have been working for the last few days on a macro only for me to come into work this morning and be presented with the message 'Excel has found unreadable content in this file, do you want to recover it' on opening. If I click yes then all of the VBA work I have done has been...

Hi, appreciate any help with this: every time i open i get this: The workbook and all macros work fine, but after saving and closing, when i reopen i get same error I dont have a sheet4 any way to remove this error permanently? thanks

I have a workbook that is used by multiple people and I would like for them to be able to save the ActiveSheet as a PDF to their own desktop. Specifically, I do not need what is in the first 8 Rows and therefore the PDF should include only what is in Rows 9 on down. The line of code I am...

Hi Everyone, I have a macro that checks if a document should be closed or not, it works great, but I get the Do you want to Save document request after it runs as you would expect, however theres never a time this document needs saving so could this macro just close the document for me without...

This is a new behavior I can't explain. I have no macros (that I am aware of), no add-ons, and am using workbooks that I've had for months. I often test changes to data or formulas to see what might happen then close the file without saving so no permanent changes are made. Now, when I...

Hi All, I'm using Excel 2007 for the first time in a while since switching jobs, I hide columns and try and copy what I can see but it's copying the whole line into the new spreadsheet. Annoyingly it doesn't do it on my colleagues spreadsheets only mine?! I've tried saving as different formats...

Hello all, I have several excel files that are macro enabled with some code in them. However, I would like to save some code free copies for back up. I thought this would be as simple as saving it to a .xlsx file but that apparently doesn't completely wipe out the vba project. Is there an...

Hi all, I have the following code that I would like to adapt to change from saving one worksheet to saving two as a pdf. The worksheet names are "NCR" and "RCA" and the code is as follows: Sub SaveAsPDFExcel() Dim fName As String Dim sLoc As String 'location sLoc =...

Hi, I need two macros that would do the following task. 1). I want to save 2 of my worksheets as a single PDF file, with a flexibility of saving file at a user defined location. (SaveFileDialog). 2). Also saving these 2 worksheets separately in a Workbook. thanks :)

I have an add-in I created but I want the user to periodically update it by simply saving over it. The problem is, it appear Excel can't be open to save over the add-in (it will prompt for a different name). Any ideas how to accomplish? Thanks

Hello. I need a help to prevent other people saving on the master file. The approach is the following: 1) Clicking on the button "Save", I need the pop-up "You're saving with the same name" and stop the operation; 2) Clicking on the button "Save as" without changing the name, then pop-up...

I have developed a dll in Fortran, and calls it from Excel. Normally this works very good. If the dll crashes during execution (for example due to division by zero or some other problem) also Excel crashes down, without saving. I have tried to add On Error Goto... before the call to the dll...

hi, i have 3 xl files named current, previous and macro. current is a report that is run every other day and uses vlookups to the previous file (previous is the current file in a completed state). macro is an empty file except for a macro to run all vlookups on the current file. when all the...

Here's a challenging question for you. A fair bit of internet searching reveals no other questions/problems like this. I'm running Excel/Office 365, have an up to date version. Win10, OneDrive. A few days ago, some (not all) of my many Excel spreadsheets started SAVING THEMSELVES as soon as I...

Please god someone tell me this is possible somehow. I'm making a deck of Trading card Game cards and - hey! - in excel versions gone by you could create an image, and save it as a jpg. So I've got a spreadsheet for autopoulating about 500 of these with relevant information. All works great -...