Help with hidding a column in Excel

J

Jonathan

Al said:
I need to hide a column in excel from access. How can I do that?
Alaa
Click to expand...

Hi Al, one of the nice things about Excel is that you can record a macro and
then inspect the code. I recommend that this is the method that you use to
learn what you want to do in this case. Then just copy the code into your
Access routine.

You did not ask how to set a reference to Excel and then open a workbook. So
I assume you know how to do this. If you're not sure, then this site has a
good search engine to allow you to browse existing responses to this issue.

Luck
Jonathan.
 
A

Al

Thanks Jonathan, I got it working now.

Jonathan said:
Hi Al, one of the nice things about Excel is that you can record a macro and
then inspect the code. I recommend that this is the method that you use to
learn what you want to do in this case. Then just copy the code into your
Access routine.

You did not ask how to set a reference to Excel and then open a workbook. So
I assume you know how to do this. If you're not sure, then this site has a
good search engine to allow you to browse existing responses to this issue.

Luck
Jonathan.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help merging Excel into Publisher Booklet w 2 columns 0
Autonumber field in Excel that behaves the same as Access 0
Booklet in Word, Merge Directory from Excel 0
Un-Hide Col. A (Excel Starter) 5
How to center adjust text above and image in a two column document. 1
Merging from an Excel file with graphics 1
MS Project Center-Autolink column fields 0
Need Help with a VBA subroutine 0

Top