Help with hidding a column in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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...
 
Back
Top