this could also be aproblem with insufficient authority to access the files on AS/400. Check with your system administartor that you are authorised to access data from the AS400 in that library with the user id you are using
date 1 in cell A1, date 2 in cell B1, then in c1, '=DAYS360(A1,A2)' THIS WILL RETURN AN EXACT NO. OF DAYS. IF B1 IS EARLIER THA A1, YOU GET A NEGATIVE NUMBER. IF EITHER DATE IS INVALID (E.G. 31/6/2002 YOU GET #VALUE)
IT'S A STANDARD FUNCTION
CHEERS
GEOFF
i use excel spreadsheet to generate a time sheet from which i invoice. it has 7 columns DATE, START TIME (HH:MM), START LUNCH BREAK (HH:MM), END LUNCH TIME, FINISH WORK, THE DATE IS CALCULATED DAILY FROM THE ONE BEFORE.
you enter the other 4 columns, and the hours & minutes worked are calced...
If I understand correctly, your running this in Access. If that's the case it may be that you haven't added the necessary Reference to excel, you need to creat a reference to the Microsoft Excel type library. I am not familiar with the method for Acces, but in Excel, whilst in the VBA project...
You can use cpysplf as mentioned above, but you need to create a PF first which is long enough to accommodate the spoolfile entry.
You need to get the jobname, jobnumber, file number etc from the splf. These are used to select the right file.
The same thing happened to me the other day. Try putting the cursor immediately before the 'If' and backspacing to the beginning of the line. I think occasionally some sort of control characters are picked up on this site when copy/pasting.
Geoff (Macbone2)
I wouldn't swear to this, but when using FTP (and there's every reason to believe the same protocols are buried in there somewhere) I would suggest that in the string
linked_server_name.catalog.schema.object_name
catalog = AS400 library
schema = database file
object_name = member
This is...
I've seen this before. i think if you format the range of cells BEFORE you run the macro, or as the early lines of code, you'll possibly find that the cell range expands to fit.
Geoff
A colleague has a Lotus 123 workbook containing around 10 linked sheets. It's an important business document which is needed for presentation to bankers etc for financing. Unfortunately there are some circular references when converted to Excel, and he doesn't now have time to go back to the...
I have VBA programs in an Excel workbook which send an email using Outlook. The email contains 2 hyperlinks,
and some instructions, all of which are generated inside the VBA program (the links are variable and are constructed on the fly). I'd like to be able to highlight certain sections of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.