The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Joining the Forum

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Joining the Forum

Resolved · Low Priority · Version 2003

ReplyFri 31 Oct 2008, 15:41Delegate Andrew said...

Joining the Forum

How quickly will questions be answered?

For upcoming training course dates see: Pricing & availability

ReplySun 2 Nov 2008, 21:40Trainer Laura said...

RE: Joining the Forum

Hi Andrew

Welcome to the forum.

We aim to get questions answered as soon as possible, 24 hours being our goal. Higher priority questions get answered first.

Regards

Laura GB

ReplyTue 4 Nov 2008, 16:15Delegate Andrew said...

RE: Joining the Forum

Laura

I have another query.

I have a lot of data which i receive in PDF format. I know you can convert this into a table in word and then copy across that table in excel......

But, i would like to be able to write some code to be able to do this. Is it possible?

I would like to run the macro which allows the user to choose the PDF file to open, open a word document to facilitate the making of a table, copy data from PDF file and then paste the information into excel, then closing down word without saving it.

Happy to discuss further if i have not explained it well enough above

Many Thanks

Andrew

Excel articles

· Creating Charts with Excel
· Where Are The Form Controls In Different Versions Of Excel
· Share And Share Alike - Use Excel To Collaborate As A Winning Team!
· Discover The PMT, IPMT And PPMT Functions In Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice

Please browse our web site to find out more about
vba-excel-training and other Microsoft training courses.

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)

View all Excel hints and tips

How do i password protect a database?