in
All Tags » VBA » save (RSS)

Browse by Tags

  • Getting the save common dialog VBA

    I need to allow a user to select a location for a file to be saved. I have VS.net 2002 installed but have to work in VBA on this project. I need to have a custom filter for the file name because it isn't a common office document. Anyway how can I get some common dialogs. Can I use something like...
    Posted to Miscellaneous (Forum) by microsoft on 05-15-2010

  • Access 2007 VBA code to save data entered into a form

    Hi I have a simple Access form with a button that creates a new record. There is however no btton to save the entries made to the table. What VBA code would I use to commit the data to the table and what measures would I need to stop the data from automatically being saved to the table without clicking...
    Posted to Access (Forum) by microsoft on 05-04-2010

  • VBA script to save individual sheet as new workbook file

    I have a script the saves my workbook to a specific directory, names it and pops up a dialog box confirming the saved file and file name. I want to have another script that does the exact same thing except I need it save the new file with only one sheet from the workbook. Juist for example, let's...
    Posted to Visual Basic.NET (Forum) by microsoft on 03-14-2010

  • VBA Code to Save an Excel File as a Tab Delimited Text File

    We have an Excel file 4 columns of data. When we try and save it as a Text File tab delimited, it saves it either as comma delimited or if it is tab delimited it saves some of the values with " around the value I need code for my Active Workbook to save Sheet1 as a Tab Delimited MD-DOS Text File...
    Posted to Excel (Forum) by microsoft on 12-22-2009

  • Basic Save As Prompt

    I know this should be simple, but I can't find just the right answer in the forums: How do I prompt for the save as dialogue from VBA? I am saving a worksheet to another workbook and then want to save and close that workbook all through VBA: Worksheets("PrintCal").Select ActiveSheet.Copy...
    Posted to Excel (Forum) by microsoft on 08-14-2009

  • Access Forms. Save As using VBA

    Hi, I currently have a program which saves a form. Is there anyway to save the form as and not just save? Thanks
    Posted to Access (Forum) by microsoft on 08-05-2009

  • VB 6, VBA  - Saving word document as .pdf

    Hi Is there a way in Word VBA to save a document as a .pdf file
    Posted to Word (Forum) by microsoft on 08-02-2009

  • Excel VBA : Save AS...

    Using a macro in Excel, I would like to have the same dialog window as I see when using File/Save As with the mouse pointer in Excel. How to do this in VBA?
    Posted to Microsoft Office (Forum) by microsoft on 07-13-2009

  • Disable Save/Save As...  ? (VBA)

    Hi everyone, Is there a way to disable the Save & Save As... commands in Word/Excel/etc on a per document basis (macro/VBA)? We have a problem with people who open a shared file to edit, then leave it open so no one else can edit it. Right now, most people go ahead save their own version locally...
    Posted to Microsoft Office (Forum) by microsoft on 06-29-2009

  • EXCEL VBA problem with worksheet save

    I have written the following vba macro to save a particular worksheet as a separate workbook. Private Sub ExportRptCommandButton_Click() Dim fName As String, FileNm As String 'GET THE NEW FILENAME FROM THE CURRENT SHEET FileNm = ActiveSheet.Range("H1").Value & ActiveSheet.Range("I1"...
    Posted to Excel (Forum) by microsoft on 06-29-2009
Page 1 of 2 (14 items) 1 2 Next >