Search results for query: *

OK, I have a macro that opens up a spreadsheet and copies data into a new spreadsheet. A problem I have encountered is when users run the macro but the data source spreadsheet is still open. The macro will only read what was on the last saved version of that spreadsheet. How do I check if the...

Ken, This has solved my problem. Thanks for taking the trouble to reply. Aidan

Ken - thanks for responding. I don't really understand how to go about this though. Where do I define "My folder with space" as "My~1"? I'm sorry to sound so stupid. Aidan

Hi, I have searched the forums and have got a partial answer to the following - but not fully. First I wanted to run a batch file from a shell command, where there were spaces in the file path. I done this by doing the following: dim x dim shell_cmd shell_cmd = _ chr(34) & "c:\folder...

When trying to import a spreadsheet into access I get one import error. The offending record imports apart from one field whicj I am advised is due to "Type Conversion Failure". This is advised in the import errors table that is generated. The value which doesn't import is...

Thanks Rob.

Hi, I am trying to determine if a worksheet is protected. The worksheet in question is in a multi worksheet workbook. It is also the active worksheet. I tried looking at the "activesheet" properties - but cannot find a definitive list. I stumbled across one called...

I have a report which has the column titles in the page header. I also have a report footer which takes up approx 1/2 page. If the data on the last page is more that 1/2 a page long, the next page will (quite rightly) contain the report footer. Except that the last page will also include the...