saveas

Hi, Looking for a macro to be able to save only one worksheet of the workbook. For example, msgbox asks user to saveas H:\Jobs\ and then saves sheet 5 as an excel workbook itself. and if possible, it uses the value of cell b2 as the name of file."H:\Jobs\B2 value I tried but I have a mess...

I know I can change the SaveAs path using application.GetSaveAsFilename initialfilename:="%userprofile%\Downloads" but this results in the user being presented with the SaveAs dialog. I want to change the SaveaS directory they are shown if/when they issue their own SaveAs (or Save) request...

I have a timer on a macro to save the file every 15 minutes. If i open another excel while this one is open it triggers the other excel to save. and if i open an excel while this is running and then close it the file will reopen at the 15 minute mark and try to save. Any ideas on how to prevent...

Is there a way to have the path = a cell in the workbook something like =range("setup-lamp types!I1") the above doesn't work, so is there another way? Sub Save1() Dim nom As String Dim path As String path = "\\hinas1\mfg\S8WData\Christine Myhaver" nom = ThisWorkbook.Name

I am working on a timesheet that, when submitted, will send an email telling payroll it's been submitted and will include notes from the workbook as well as save a csv copy of a part of the timesheet and put it on a network drive for auto-import. The first part is working fine, this part is...

Below is a portion of a macro that saves the current workbook, prompts the user to SaveAs, and then (not shown) it clears the workbook to start a fresh period/quarter. On our LAN, when it prompts to SaveAs, it defaults to My Computer, is which is a terrible navigation to get to the right...

I'm trying to Save the current file, then Save As to a new filename (for the new quarter/period) prior to clearing the data from the previous quarter/period. I want the user to be prompted for the SaveAs filename and path, but I'd like a default filename to populate in the prompt window using...

I have a macro that clears a database for the quarter, to start fresh with the next quarter. Each quarter adds a few things, so it's not feasible to just start with a blank from the original file. I'm trying to add something to the macro that will save the current file (the outgoing quarter)...

Hi, I'm quite new in vba and I was hoping someone could help me. I have the following code, that saves a copy of a sheet "Loading Form" using as a name a value in cell C7: Sub SaveITWithNewName() Dim NewFN As Variant If Range("C36").Value <= 0.8 Then MsgBox "Truck not full" Else...

I had searched the net for SAVEAS and nothing come close to what I needed. I have a workbook (a template) "RAD Analysis.xlsm" and in the sheet "RAD" cell A2 = 8/3/2018 and I want to force a SAVEAS filename as: "RAD Analysis for the month of August-2018.xlsm" - how do I write the vba for this -...

I am hoping that someone can tell me what I am missing - I have this macro and everything works just fine except that it doesn't actually SAVE anything - just goes through the motions... Here is what I have - Sub getFolder() Dim filepath As String Dim newFldrDia As FileDialog Dim filename1...

In vba I'm trying to save a copied portion of an xlsm worksheet C1:C466 as a test.ebm file. For reference, an .ebm file [when opened in notepad] appears as normal text, no special characters or issue however, my problem is forcing vba to save, naming with the .ebm file extension. [In Windows...

I have a workbook which is 'read-only' attrib. I needed a saveas dialog box to appear everytime save, saveas, close or the [x] at the upper left of the worksheet is clicked. but instead of "copy of filename", I want it to be a filename I will recommend. I could not find solution in the net [I...

Hello, I'm sorry I'm very new to this, but I am having a problem saving as with VBA. I recorded a macro, and have amended a bit from other posts. This is what I have so far. I am trying to save a .txt file as a .csv with the current file name. But I get a runtime error that it cannot access...

Hi All, Just curious can savecopyas function set to values only? and how can i go about it. Or the only way is using saveas function?

Hi In Excel, you can use the function ThisWorkbook.SaveAs In an Access database, how would I do this? Appreciate any guidance Many thanks

Hello I am looking for a way I can open a SaveAs dialog using VBA, then if the user hits cancel it will show a msgbox with "You need to save the document before you can continue." on a vbOKCancel + vbCritical popup. If the user then selects cancel it will close the workbook but if they select...

I received great help from Fluffy yesterday. I've been working all morning and just can't figure this out, its a mess. I am a beginner and putting in time to learn but running out of time. It doesn't help that I am not the sharpest tool in the shed. I appreciate any and all help. I want to...

Hi everyone, I've found a few different threads on the elements of this but I haven't been able to cobble them together, hoping you may be able to help. I'm looking to run a command which will open the save as dialogue on screen Defaultly fill the file name with 'INV_TRC_[cel c1]_[current...

Hi, I'm getting an error when calling a SaveAs sub at the end of another macro. The save as is not executing, but I've had success using a similar code before. Is there anything obvious wrong with how the code is written? I've made sure that the network files path names are correct in the code...