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