saveas problem

Hi! I need help with some of my coding. I cant seem to get the saveAS function to work inside a do while loop. It works fine outside the loop. When its inside the loop it keeps saving the same file and wont exit the saveAS and go to the next step. Sub test() Dim ws As Worksheet Set ws =...

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...

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...

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...

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...

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

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...

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...

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...