Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. philfer

    Connecting to commercial software

    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...
  2. philfer

    system primitive failed

    How?
  3. philfer

    getsaveasfilename

    How?
  4. philfer

    object models for non-MS apps

    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
  5. philfer

    object models for non-MS apps

    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...
  6. philfer

    getsaveasfilename

    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...
  7. philfer

    set scroll area in copied book

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

    getsaveasfilename

    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...
  9. philfer

    system primitive failed

    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...
  10. philfer

    set scroll area in copied book

    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...
  11. philfer

    easiest fastest way to copy entire rows

    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...

Part and Inventory Search

Back
Top