At cargill their traders Daily PnL sheets were all based on Lotus 123 sheets. I found comments in the code that dated back 10 years and one where a chunk of VBA was to 'replace a 123 function that Excel doesn't have'
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
VBA and Excel
Collapse
X
-
Rule Number 1 - Assuming that you have a valid contract in place always try to get your poo onto your timesheet, provided that the timesheet is valid for your current contract and covers the period of time that you are billing for.
I preferred version 1! -
Originally posted by BoredBloke View PostOfthe the reason is down to Access being included in Office Pro rather than Office Std and so does not tend to get deployed as often. Also there tends to be fewer people kicking about who can make a database than can throw together a spreadsheet. I've worked at loads of places where they have struggled to implement database functionality into a spreadsheet but simply will not accept a database! On the plus side it gives ample opportunity to keep on generating invoices! Grin and bank it!
it is possible to do and not difficult. I also would side with the Access solution as things can become a mess in Excel very easily!
When I tried to open the database a few years later, Access claimed it couldn't read that version.
I was not impressed. At all.
Even if I hadn't come across that little gem, the new PC that arrived a little later didn't have Access.
Fortunately I still had the scripts I'd written to grab that data again, and shove it into a proper database (Oracle).Behold the warranty -- the bold print giveth and the fine print taketh away.Comment
-
A spreadsheet. Sheesh.
Wrong tools.What happens in General, stays in General.You know what they say about assumptions!Comment
-
Comment
-
Comment
-
Originally posted by Sysman View PostI used Access many years ago to keep software licence details for a fleet of systems.
When I tried to open the database a few years later, Access claimed it couldn't read that version.
I was not impressed. At all.
Even if I hadn't come across that little gem, the new PC that arrived a little later didn't have Access.
Fortunately I still had the scripts I'd written to grab that data again, and shove it into a proper database (Oracle).Rule Number 1 - Assuming that you have a valid contract in place always try to get your poo onto your timesheet, provided that the timesheet is valid for your current contract and covers the period of time that you are billing for.
I preferred version 1!Comment
-
Originally posted by Netraider View PostI have recommended SharePoint, as it is quite easy to do most of what I want using the workflows built in.Rule Number 1 - Assuming that you have a valid contract in place always try to get your poo onto your timesheet, provided that the timesheet is valid for your current contract and covers the period of time that you are billing for.
I preferred version 1!Comment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment