VBA Access and VBA Excel on the web

Resolved · Low Priority · Version 2003

Mon 26 Oct 2009, 09:25 Delegate Peter said...

Peter has attended:
Excel VBA Advanced course
Access Advanced course
Access VBA course
Access Advanced course

VBA Access and VBA Excel on the web

If I want to activate VAB Access or VBA Excel from a web site, what is the best way to do this? Is it aload of HTML code or is it straightforward?

Wed 28 Oct 2009, 09:47 Trainer Stephen said...

RE: VBA Access and VBA Excel on the web

Hi Peter

Thanks for your question

Could you clarify your requirements for me please?

Do you wish to access spreadsheets and/or databases from the internet? If so what sort of data are you looking to transfer?

Thanks

Stephen

Wed 28 Oct 2009, 17:53 Delegate Peter said...

RE: VBA Access and VBA Excel on the web

Thanks Stephen

I want to be able to post VBA code and Excel spreadsheets onto my web site so that clients can run programs from the web site.

The database will probably be provided by the clients. but demonstrations wil be available from the web site.

Regards

Peter

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips