saveas problem

  1. M

    Run-time error '1004' Method 'SaveAs' of object '_Workbook' failed

    Within an excel workbook I have created a routine that automatically logs the user and date when the workbook is initially opened. The Sub Workbook_Open() calls the routine. For most users it has worked effectively for sometime. However, myself and a few users are now getting the Run-time error...
  2. O

    VBA Before Save to open Save As dialogue box in current folder

    Hi there I have a work book that needs to be saved by default in the folder it was opened but users should be able to move it as required using Save As. At the moment I'm getting complaints that the Save As windows opens on a local folder on the users computer rather than the network folder...
  3. C

    workbook.saveas method problem

    Automating Excel from Access, I'm attempting to generate a single sheet workbook and save to a Sharepoint site. This process works fine on my machine (XL2007, XP), but on a coworkers computer (XL2003, XP), the code throws a 1004 error on the save as line. However, the really odd thing is that...
  4. W

    SaveAs error message help!

    Hi, I keep getting the below message: Method 'SaveAs' of object '_workbook' Failed Can anyone show me the error of my way? Much appreciated! ...'Save file in Correct folder Dim mytemplate2 As String ' Input box to help specify new weekly folder mytemplate2 = InputBox("Input Date file...
  5. K

    Error 1004 SaveAs Method - Works 95% of the time.

    Hello, In general, the following lines of code work: ActiveWorkbook.SaveAs Filename:=mstrBARRA_FILE_PATH & astrAccountName(intAccountCount) & "\" & _ astrAccountName(intAccountCount) & ".por", _ FileFormat:=-4158...
  6. S

    VBA stops when Save As dialog box appears?

    Hi folks, I'm having a problem trying to automate a task in Excel because my VB formula requires a manual press of the Enter button or a click on "OK" in the Save As dialog box. The relevant part of the code is as follows: Application.GetSaveAsFilename( _ initialfilename:=ActiveCell.Offset(0...
  7. J

    prevent Excel 2007 convert to xml offer

    I have created files for users that I want to retain in .xls format so that they are 97-2003 compatible, but the automatic message box offering increased security ("this document is both encrypted and password protected. The Office Open XML formats available in the 2007 release provide stronger...
  8. B

    SaveAs problem in 2007

    I have a VBA macro that says.... Application.VBE.ActiveVBProject.VBComponents.Import ("C:\..etc..") ActiveWorkBook.SaveAs Filename:=ActiveSheet.Name I'm riunning the macro in XL 2007 which I have configured to use .xls formats. I would assume this Excel 2007 formats any new workbook file...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top