Search results for query: *

I want to append todays date as part of the name of the existing file. I thought the folloiwng code would work. objFile.name = "opxinhdr.txt" & Date()

thus far, I didn't have to do.

so How to attach today's date at the end of the file? thanks nath

Invalid procedure call or argument. this is the error message

I get compiler error: objFile.name = "opxinhdr.txt" & Date()

thanks much nath

thanks much. I figured out. nath

Set objFSO = CreateObject("Scripting.FileSystemObject") If the file I am looking for doesn't exist, then the next line is causing an error. Set objFile = objFSO.GetFile("C:\code\OpicsEod\file.txt") thanks much appreciated. nath

so there is no .Rename method? thanks nath

I saw only Copy, Delete methods (file scripting object). thanks nath

I get this error when I run the project file in vb6.0 environment. any reasons why this could be happening?

in .net standard output is console. we can write to console. what is the standard output in VBA? specifically MS Access? I need to write error messages to standard output. thanks nath

in .net standard output is console. we can write to console. what is the standard output in VBA? specifically MS Access? I need to write error messages to standard output. thanks nath

I want to send an email(outlook object) from VBA code. In the body of that email, I would like to have an Excel work sheet. NOt as an attachement. but the body itself should have the excel file. how can I do that programmatically do that? Sub SendEmail() Dim OutApp As Outlook.Application...