Take a look here http://www.thecodecage.com/forumz/ge...post1054990646
Take a look here http://www.thecodecage.com/forumz/ge...post1054990646
Kind regards,
Simon Lloyd
Thanks very much Simon, but, can i bother you to PDF the page and attach it here for me please? The internet policies here are pretty strict, and i cannot access that website.
Your help is appreciated.
There aren't any restrictions accessing that site, i work at a large corporate with a very strict firewall and can access it and all content, its a forum run on exactly the same software as this.
Kind regards,
Simon Lloyd
Well, I obviously don't work at the same place as you then!All URLs are on the blacklist unless they are whitelisted, if you can see what i mean (and it takes quite a while to get a site whitelisted). But anyway, maybe i can get it some other way.
I wonder who got my site whitelisted?(Tell them they should be adding Simon's too.)
Here's another version of the CD code too...
Simon's version is nicer though.Code:Private Declare Sub SendStringA Lib "winmm.dll" (ByVal lpstrCommand As String, _ ByVal lpstrReturnString As Any, ByVal uReturnLength As Long, _ ByVal hwndCallback As Long) Sub OpenCDTray() SendStringA "Set CDAudio Door Open", 0&, 0, 0 End Sub Sub CloseCDTray() SendStringA "Set CDAudio Door Closed", 0&, 0, 0 End Sub![]()
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book Master Your Data for Excel and Power BI, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
What version of Excel and of Windows are you running?
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book Master Your Data for Excel and Power BI, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Win 7 Pro 6.1.7601 64-Bit
Office 2010
Right, but is your Office 32 or 64 bit. I'm guessing 32bit, but just want to be sure.
I have to run out, but I'll look at this one later tonight my time.![]()
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book Master Your Data for Excel and Power BI, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Bookmarks