Search results for query: *

Hello, I want to use an SQL Server database to connect to our commercial accounting software overnight and take a snapshot of the data. This will be used to run stored procs and save "extracts" as Excel files for people to use for various reporting the next day. Firstly, is this possible...

How?

How?

What I was asking for was whether there was a worked practical example anywhere on the web that I can follow and use to get it clear in my head. I am unable to ask the authors of the app

Does anyone know if there is anywhere where I can find a worked practical example that runs through the steps of :- 1) Identifying the object model for a non-MS app 2) Discovering the type libraries and tables for this app 3) Setting a reference for this app 4) Writing VBA code to...

Sorry, got it the wrong way around!!! I can set the path for FileDialog but not GetSaveAsFileName. But I cant set a suggested filename with FileDialog Thus I want to either :- 1) Find a way to give a suggested filename for FileDialog OR 2) Find a way to set the path for GetSaveAsFileName...

After I do ActiveSheet.Copy I do Activesheet.ScrollArea = "A1:E45" it works until I close it down and re-open it

Is there a way using the above to suggest a filename to save. I know it is possible with Application.FileDialog(msoFileDialogSaveAs) but when I use this I cannot get the path to be a default path I want to set. I can set the default path with GetSaveAsFilename but dont know how to fill the...

I am trying to launch an app using the Shell method. However I get an area which says "System Primitive Failed" When I go to the apps .exe file and click it it wont launch. However the icon on my desktop leads me to a "Windows NT Command Shell" which when I double click launches the app...

I use Activesheet.Copy to create a copy of a worksheet. However I want to set the scroll area in that new worksheet. When I code it after the ActiveSheet.Copy it works ok until I close the workbook and open it up again when the scroll area has not been saved. Is there any way to put code...

Hi, I have a worksheet in a workbook with lots of ledger codes. I want to loop down column A and when it finds a particular code saya 2010 I want to copy the entire row into another worksheet so that the new worksheet only has the details for this ledger code 2010. I am using a loop (For...