I posted this in the Macro Board and havent had any luck. heres my issue:
I have a spreadsheet located on our network called dps2006.xls. This sheet is password protected. I want to know how i can import data from a tab called cream summary. i havent had any luck doing it. i can get non password protected to work fine.
I have a spreadsheet located on our network called dps2006.xls. This sheet is password protected. I want to know how i can import data from a tab called cream summary. i havent had any luck doing it. i can get non password protected to work fine.