Hi all,

I'm new here and first, I want to say hello to you all.

I know nothing about VB's, VBA or VB.Net whatever you call it, but I am a basic user of office applications. I use excel 2003 to prepare a simple payroll sheet and linked sheets for reports such as cash/coin and payslips etc. I managed to fit 6 payslips into one A4 page report which is done by linking the reports to the main payroll data sheet by cell referencing. How can this be done automated using VBA/ VB.Net?

__________________

---

database...? and then get the payroll data from the database and create the PDF based on it.. is that kind what you're trying to do..?

__________________

---

No, I'm using excel 2003. Not familiar with database or PDF programs.

__________________

---

lol, probably you should try to post this problem in the Visual Basic section.. Sorry, I'm unfamiliar with VB haha...

__________________

---

Well now might be the time to look into VBA, if you want to do this with excel you should use VBA, its rather simple to learn the basics, which is all i should think you need to do for this project, have a look around the net to see what you can find about VBA and then if you have any problems or need pointing in the right direction just ask here.

VBA For Microsoft Excel - This is a good looking site, you want to read about VBA, it's a bit of a mix between VB and VBA in there so just nip past the VB.

Hope it helps,
Lee.

__________________

---

if you are looking vb.net excel tutorials try the following links

yo wil get idea

VB.NET Excel 2007 Tutorials

VB.NET Tutorials , Help and source code

sams.

__________________

---

Although your information maybe useful please don't drag up topics that are this old

Thanks,
Lee.

Closed, start new thread if you need help on this.

__________________

---