Error in VBA code

11-13-2014, 08:24 PM

macropod

Windows 7 64bit Error in VBA code

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,369

I assume you have a function 'FileFolderExists' somewhere, since that's not a native VBA function.

Try:

Code:

Private Sub TestFileExistence()
If Dir("\\cf3.pepsico.pvt\psra\Output\BI 4\Exec Dollars - Current Period.pdf", vbNormal) <> "" Then
  If Weekday(Date) = 2 Then
    Range("A1").Value = "X"
  Else
    Range("A1").Value = "!"
  End If
Else
  Range("A1").Value = "!"
End If
End Sub

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
error code 30029-4	zignaasa	Office	0	05-24-2014 10:07 PM
Error Code 5453 Word has finished searching the document	Charles Kenyon	Word VBA	2	05-17-2012 11:18 AM
Code Error - Hiding comments and revisions	silvrwoman	Word VBA	6	03-24-2012 10:15 PM
Microsoft Code Error 1907	JHauglid	Office	1	02-27-2012 12:15 AM
Error code 0x800CCC80	Kevin	Outlook	1	03-18-2011 07:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:51 AM.