open report when booting up pc

[philbennison]

Hi all,

I have created a report that i would like to appear when my PC boots up, unfortunately i am in a network scenario and cannot put things in the startup folder.
I do however open outlook every morning. Can i put some code into outlook to open the report automatically

Any ideas ??


Phil

 

[Christopherusly]

Why can you not place something in the startup folder ? seems to work on here on my work network.

 

[Newman]

You could create another shortcut for yourself, and add this:
/x MyMacro
at the end of the target line.
Then, create the macro MyMacro and in it, select «OpenReport» and give the name of your report.

When you boot your PC, just click on the new shortcut and you get right to your report.

 

[philbennison]

unable to do either

Thanks for the input, however

1) because i am behind a network connection, my profile is refreshed whenever i boot up and this wipes the startup folder

2)I have already got a shortup icon on my desktop, however i was trying to automate things and wonder whether i could open the report whenever outlook opened

any other ideeas


phil

 

[Newman]

Never tried it, but that should work:

Note that I did a translation from french version. The names might be different but should have the same meanings anyway.
Create a batch file or a vbscript that opens the database and the report.
While in Outlook, press «ALT» & «F11» at the same time.
You'll get the VBA window.
On the left choose «microsoft objects» and «this session».
On the top, you'll see two lists...
Choose «Application» and «StartUp».
You'll get that code:

Private Sub Application_Startup()

End Sub

Add this in the gap:

Dim MyPath As String
MyPath = "C:\Documents and Settings\User\Desktop\MyBatchFile.bat"
Shell MyPath, vbMaximizedFocus

Of course, you'll have to right YOUR path. Not the one I gave you here.

That's all I can give you for now. If I ever get the time to create a batch file for you I will, but I don't have much spare time right now.
I hope that someone else can help you out more that I did.