Search results

Solved it!!! .Application.ActiveWorkbook.SaveAs "C:\" & Format(Now(), "mm-dd-yyyy") & "RptTest6.xlsx", FileFormat:=51 .Application.ActiveWorkbook.Close .Quit thank you all for your suggestions

I save the file as .Application.ActiveWorkbook.SaveAs "C:\" & Format(Now(), "mm-dd-yyyy") & "RptTest6.xlsx" .Application.ActiveWorkbook.Close .Quit Now I am getting below error while opening the file: "Excel cannot open the file "RptTest6.xlsx" because the file format or file...

ok I make excel file visible and the code creates the validation list but as the code save the file and quit the file, there is no validation at all. I am not sure what's going on. whats wrong am I doing in saving it? .Application.ActiveWorkbook.Save .Application.ActiveWorkbook.Close...

Thank you very much for your reply. Yes, i debug each line one by one and there is no issue but i don't know how to make excel visible. This function is called by the access after dumping the report to the excel. I spent quite a time on this but no luck.

Hello, I export the access report to excel via access VBA(outputo method) and then I am opening the file from access to add the data validation list in the excel file. Below is the code -Code runs fine and it shows no error but when I check the file, nothing happening. I want to have data...

Not a good Programmer :) But still tried to make it more readable Private Sub Form_Open(Cancel As Integer) // Check if today's date is thursday If Weekday(Date) = 5 Then { Dim rs As DAO.Recordset Dim strSQL As String Set db = CurrentDb() // Select email address...

No Response!!! Please somebody response to it. Thanks

Thanks Paul For your Quick reply! I have another problem too :) I have written VBA(Listed below) to send an attachment to an email. Problem is email does not send out. It sits in email as a draft. I am using lotus notes for the email. Appreciate your help!!! VBA Private Sub Form_Open(Cancel As...

Hello All, My requirements is to send the alert messages with the approaching due date on every Monday of the week. I am able to send alert messages on Monday. My Problem is: How to send alert messages on Tuesday if Monday is Vacation. Is there a way to do it in access? I don't have much...