Search results for query: *

If I use acFormatXLS then I lose the title and it just looks liek a notmal datasheet. I want to use XLS but keep the formatting like when you use RTF Gra

Hi All I have the following code in my Datbase for emailing the access report. DoCmd.OpenReport stDocName, acPreview DoCmd.SendObject acSendReport, , acFormatRTF, _ "graham.millichap@northyorks.gov.uk", , , _ "Test Email", "test", False, False If I export to RTF the report...

I'm sorry but I'm no expeert in this, can you please show me on the code how to achieve this? Thanks Graham

Sorry for the late reply. This is what i have now and it is having trouble witht he filename, It doesnt work unless I put a specific name in but I need it to loop through all files so I can put a name in . Dim strPath 'As String Dim appExcel 'As Object Dim strFolderPath 'As String...

Hey All I am having a problem, the code I have here was working last night only it wasnt opening the Excel documents as they are passworded. Now it isnt saying "Cannot use paranthisis when using a sub"?? can anyone help me get this to loop through the folder and open passworded excel documents...

Good Afternoon As part of my job I build / maintain spreadsheets that now use VBA to complete tasks, one of these is emailing a workbook by the pressing of a button to make the user experience easier. The software used is Excel 2002/2003 and the messages are sent across the company email...

Excellent thanks for the replies. graham

Hi All I have been trying to get this simple piece of code working and it is getting on my nerves?? Can any one help. Private Sub CommandButton2_Click() Dim cl As Range 'For Each cl In [D1:D10] If Range("D1") = "Outside NYCC" Then Application.ActiveSheet.EntireRow.Select...

Good Afternoon As part of my job I build / maintain spreadsheets that now use VBA to complete tasks, one of these is emailing a workbook by the pressing of a button to make the user experience easier. The software used is Excel 2002/2003 and the messages are sent across the company email...

Good Afternoon All I have VBA code that copies several sheets froma workbook password protects then emails the document to a specified address. What I need now is the code to tell the new document to break the links with the old one. Original thread here ...

That is excellent, work like a dream, Could you tell me what I would need to add into the code so that the new copied workbook breaks the links to the old one? Ta

Any ideas where I put this code to get it to work for me? Cheers

Where do I put this?

Hi All Hope you can help : I have the following code and although it works first time it will not work after that as it cannot overwrite the file that is already in the temp folder, so I need to be able to let excel choose the filenames or check to see if there is a file in the temp folder...

That is excellent works like a dream. Thanks for that. If I wanted to send the entire workbook and not selective sheets what would I put in ActiveWorkbook.copy doesnt seem to work?

No that is what i was saying before I dont know where it saves, and I cannot really specify a folder as too many people will be using the sheet. That is why I wanted something that password protects the document when created so when it is attached to the email it is secure ( as can be) Thanks

Error 1004 cannot access c:\temp it errors when saving ActiveWorkbook.SaveAs Filename:="c:\temp\test.xls", FileFormat:= _ xlNormal, Password:="1234", WriteResPassword:="x", ReadOnlyRecommended:= _ True, CreateBackup:=False They are restricted workstations

It comes up with an error? not sure what path it saves into but these are work computers and so are very restricted? code is below. Sub Send1Sheet_ActiveWorkbook() 'Create a new Workbook from the LPS sheet and then emails _ it to the address below 'ActiveSheet.Copy...

The code is in a spreadsheet that is used by a team of 23 and it is all accessed by a button to make it easy so I need this to happen in the VBA code automattically. Columbo

Hi All I have code that copies selected sheets to a new workbook then emails that file to a specific address. I want to them password protect that workbook. but I cnnot specify the locaion it will be saved as it is attached to an email? I just need it saving with a password in the email for...