Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. columbo1977

    Exporting Access Report with formatting

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

    Exporting Access Report with formatting

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

    VBscript Excel print problem

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

    VBscript Excel print problem

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

    VBscript Excel print problem

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

    Groupwise VBA emailing problem

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

    Copy from one sheet to another when criteria satisfied

    Excellent thanks for the replies. graham
  8. columbo1977

    Copy from one sheet to another when criteria satisfied

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

    Groupwise Mail sending problem, vba

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

    Breaking Links with previous Spreadsheets

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

    Auto save password protect Email - need to check file name

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

    Auto save password protect Email - need to check file name

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

    Auto save password protect Email - need to check file name

    Where do I put this?
  14. columbo1977

    Auto save password protect Email - need to check file name

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

    Password protect workbook

    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?
  16. columbo1977

    Password protect workbook

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

    Password protect workbook

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

    Password protect workbook

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

    Password protect workbook

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

    Password protect workbook

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

Part and Inventory Search

Back
Top