Search results

I wrote out the full saveas command, but still to no avail. It may be related to a missing reference but wouldn't know where to start. The 50 or so excel files I needed to add passwords to do was acheived by putting code into a stand alone excel macro. When this excel file is opened from access...

If you're using recordsets and db connections, are you closing them at the end of your macros...

this is all the code: Dim xlApp As Object, xlsheet As Object Set xlApp = CreateObject("excel.sheet.5") Set xlsheet = xlApp.Application.ActiveWorkbook.sheets("sheet1") xlApp.activesheet.Name = "Order Form" xlsheet.cells(10, 2).formula = "Your Ref" xlsheet.cells(12, 1).formula = "Code"...

I get a run time error of 1004......it doesn't recognise the constant "xlNormal"...says its empty??

argsName = "G:\OrderForms\" & argsName xlsheet.Parent.SaveAs FileName:=argsName, Password:="cheese" Currently using Access2000 to migrate data from access to excel using automation. The above code saves the excel workbook, but does not attach a password to it-despite the fact access runs...