Archives February 2017

SAP B1 ERP and MRP is rising star in American and Canadian accounting software market, especially since the release of SAP BO 2007A for US in May of 2008.  SAP Business One has complete set of modules to serve small to mid-size firm: Financials, Manufacturing, MRP, CRM, Services, Purchasing, Picking and Packing, Sales, and others.  Plus consider modern interface with intuitive export to Excel, drag-and-relate, users self study and self discovery possibilities.  In this small publication we would like to give you SB1 case studies and typical implementation scenarios paragraphs:

1.       Discrete manufacturing or light assembly.  If your company is small and doesn’t need full-scale production software, typically expensive in both software licensing and implementation services, SBO is excellent candidate to consider.  If you are making to order, then SB1 has disassembly Production Order, where you can disassemble cancelled order and place all the parts back on the shelves or their bins

2.       Service Warranty Contracts.  Warranties are typical business scenario for small manufacturing, dealership and distribution companies and it is probably true statement, that this reasonable market niche is underserved.  In SAP Business One you can associate serialized item (with serial number) with Service Contract, and then you can repair the item on as needed base under warranty with free technician support, spare parts, or decide to bill for portion of warranty services.  You can also associate technical support knowledge base with your items and contracts

3.       Warehouse Management.  Picking and Packing functionality allows you to automate paperwork associated with assembly, finished goods and parts storage and release to be shipped to your customers or returned back to your suppliers.  There are also barcode add-ons to automate barcoding scanners in real time or batch mode with barcode servers

4.       SAP Business One Reporting.  Please, consider such industry standard reports design tool as Crystal Reports to be deployed.

Source by Andrew Karasev

CAD stands for Computer Aided Design, has been serving and engineering industry for years to create graphical product layouts, designs and drawings with the help of computers having related CAD software. Not only it reduces the product development expenses and time but also it provides optimum accuracy and error free designs. Due to this reason CAD designs and drafting services are very beneficial for all engineering sectors like civil, architectural, mechanical, electrical, structural and aeronautical.

CAD is extremely functional for engineers, designers and architects. With the help of CAD software these professionals create flexible designs, models and diagrams on mouse clicks, which will take months to do manually. These designs can also be easily modified and no need to create a new one. The overall benefits that are derived from CAD drawing make the very concept and usage of paper drawings somewhat outdated and unnecessary. Furthermore learning how to use CAD will save you from most of the stress of other methods of conceptualization.

Design requirement and measurement are the basics to create CAD drawings. “AutoCAD” a popular software is used to store or edit drawing digitally. It is possible to convert scanned, faxed or any other manual plans to AutoCAD files, even conversion from raster graphics to vector graphics also possible. Drawings generated by AutoCAD are more accurate and perfect than hand drawings. Electronic drawings save time and storing problem.

Manual tracing is very important to get accurate outputs. For general and hi-tech engineering needs, AutoCAD files can be created in 2D and 3D. It is important to follow CAD layering standards while drafting 2D models. 2D drafting service includes: 2D drawing corrections, 2D models from 3D etc. 3D modeling service is used to develop a mathematical wire frame representation of any CAD project.

Architectural drafting services involve converting rough hand drawings into a complete set of architectural plans. This service is beneficial for architects, real estate developers, interior designers, civil engineers, consultants, etc. Mechanical CAD service is beneficial to mechanical design engineers and many such professionals to create assembly drawings for all kinds of mechanical assemblies. Structural drafting services include drawings of structural elements predominant in the construction industry including steel, concrete or wood. Electrical CAD service is beneficial to electrical engineering designers, electrical product manufacturers, original equipment manufacturers and electrical contractors.

An advanced computer technology will make engineering design as photorealistic. Animated models, AutoCAD models and solid models can be created in 3D. Stereoscopic 3D models can also be customized. It is possible to generate texturing of 3D models in all sectors. By 3D rendering services, once can make 3D models look like photographs and can be inserted into catalogues to save time and money.

It is also possible to create piping drawing in CAD. Every conceivable fluid is handled in pipes during its production, processing, transportation and use. It involves both orthographic and isometric plumbing and piping drawings. It is possible to convert scanned piping drawings into fully editable, multilayered CAD drawings.

CAD design and drafting services are the best in generating ideal designs in electronic form for better visualization and more accuracy. One can easily get the idea, how the end product will look at the end of production within minimum time period, without maintenance tension of all those paper work, that’s why CAD is very beneficial for various designs and drawings.

Source by Dillip Kumar Barik

Cloud Storage is certainly increasing wildly in popularity for mid to large sized businesses.  Offering a storage service delivered over a large network, be it the Internet or an internal network, the capacity and performance of the solution combined with the ease of managing it certainly gives it a broad appeal.  Owners will find that there are options for both rented public storage as well as private storage that keeps data behind firewalls while offering the benefits that cloud technology offers.  These storage clouds can range from as few as three nodes up to hundreds of nodes and still provide easy scaling and management.

One benefit of cloud storage is that it provides a sort of pay for use service.  Hardware, software, and services are typically billed only according to what is used or on a subscription basis.  The shared cost and infrastructure of this storage method is generally very highly regarded, as it lowers management costs significantly, and the ability to terminate contract at any time virtually eliminates the risk of significant financial losses.

The biggest drawback to ParaScale Cloud Storage software as well as cloud computing in general is security of personal and high level data.  While this is certainly true for public clouds, private and hybrid clouds offer an alternative that allows companies to reap the benefits of cloud computing while still providing a high level of security and protection for networks and data.

ParaScale cloud storage offers remarkable capabilities in today’s IT industry, allowing those who purchase the software and install it on even a standard server to create multiple nodes and act as a storage provider.  These clouds can include many popular applications and sites, but provide the capability to offer them in a manner that is cost effective and utilizes only standard hardware.

At its core, ParaScale is working to target large enterprises that can turn a large number of servers into a single cloud.  The service works to pool multiple file servers, creating a faster, more integrated form of computing that saves costs on every end.  By creating a system of automated storage provisioning, space is always available for seamless addition of new servers and storage nodes.  The software itself is remarkably affordable, offering yet another benefit to those seeking to step into the cloud storage market.  For people who were turned off by the bursting of the last major Internet bubble, cloud storage offers many more options as well as numerous abilities to keep up with the needs of today’s companies.

Source by Leon Belenky

    Bypass bypass DRM video from license protected video music files and Convert DRM Protected Music Video files WMA WMV M4P M4V M4A

    Most of the protected video and music downloaded online like Windows Media Player iTunes, Rhapsody, Napster, Bearshare , Spiral Frog are all DRM files.

    What is DRM? Why do we bypass DRM from WMA, M4P, WMV, M4V, M4A, etc?

   DRM (Digital Rights Management) – The anti consumer copy protection that prevents you from using music or movies in a way that suits you.
   For example, if a DRM WMA or DRM WMV you downloaded from WMP(windows media player) that has windows DRM, you can only play it back on a compatible device, so if every piece of music had windows DRM on it you would need to buy the same track on CD to listen in your CD player or car, as an iTunes download to play on your iPod, as a ms store download to play on your Zune etc, but since you paid for it once you shouldn’t be forced to pay for it again and again, remove windows DRM and you can play it on your phone, iPod, Zune, PSP, CD player, pc, and anything else that you can listen to music on.

A few methods listed below:
1. Burn and rip
  Actually, there is a common free method to bypass DRM WMA, M4P with 2 steps:
    Step 1 Burn DRM WMA, M4P to CD. (need a CD burner, like DVD Copy)
    Step 2 Rip the DRM WMA, M4P from CD to your computer as MP3 format , then the DRM should be removed from the WMA files. ( need a CD ripper, like Daniusoft DVD Ripper)

    But it’s not very convenient that may wear out your CR-ROM, and It also needs a blank CD, a CD burner and a CD ripper to help you.

    This is only possible when the software that plays these DRM-restricted audio files allows CD-burning. Some software products simplify and automate this burn-rip process by allowing the user to burn music to a CD-RW disc or to a Virtual CD-R drive, then automatically ripping and encoding the music, and automatically repeating this process until all selected music has been converted, rather than forcing the user to do this one CD (72-80 minutes’ worth of music) at a time.
    Software such as: Share DRM Music and NoteBuner can bypass DRM in this way.

 
2. Re-record
    One of the most common and simple technology is recording the DRM WMA and DRM WMV then use an ordinary converter to convert the recorded and unprotected files. Because this technology is easy to realized and easy to support more DRM formats besides DRM WMA and DRM WMV it is welcomed by most of the DRM converters . Software such as SoundTaxi and Tunebite use what is re-record DRM music tech to bypass DRM.

    Use this software to record the signals being sent through the audio or video cards, or to plug analog recording devices into the analog outputs of the media player. These techniques utilize the so-called “analog hole”. SoundTaxi can do that in this way. It is very fast to convert your DRM protected music and video.

    But there are some disadvantages for those programs.
    1. The conversion speed won’t get much improvement due to the long recording process.
    2. Much audio and video quality could be lost during the recording process.

  
3. Hook
    Hook is another new and more complicated technology which can be used to remove Windows DRM. Comparing with Re-recording software, these sorts of programs have much higher conversion speed, but it’s hard to make it support some DRM formats with new and lofty encryption techniques.
     Daniusoft was one of its supporters. After giving a test for some free trials you will find it’s very easy to remove DRM from WMV WMA and other protected music video files with Daniusoft Media Converter Pro, it can remove DRM protection legally and convert other video & music even HD video in high quality. It’s the best bypass drm video methods listed.

    Here are key functions of Daniusoft Media Converter Pro

    1.DRM remover
    Legally remove DRM WMV/WMA/M4P/M4V/ASF… using record technically process which records play and saves the recordings in unprotected digital formats

    2.Video Converter
    Convert all popular video: MP4, MPG, MPEG, 3GP, RM, RMVB, DAT, MOV, FLV, AVI, Xvid, VOB, MKV

    3. HD video Converter
    Support convert high-definition video: M2TS, TP, TRP, TS, AVI

    4. Audio Converter
    Convert any audio files between MP3, WAV, M4A, WMA, OGG, AAC, APE…

    You can free download the DRM Remover to have a try:

Simple steps for conversion:
1. Add DRM WMV , DRM WMA, iTunes M4P and other protected files.
2. Choose the output format you need
3. Pressthe “Start” button.

And the other method you can make a try :  Many software programs have been developed that intercept the data stream as it is decrypted out of the DRM-restricted file, and then use this data to construct a DRM-free file.
These programs require a decryption key. Programs that do this for DVDs, HD DVDs, and Blu-ray Discs include universal decryption keys in the software itself. Programs that do this for TiVo ToGo recordings, iTunes audio, and PlaysForSure songs, however, rely on the user’s own key ?that is, they can only process content that the user has legally acquired under his or her own account.

Chapter Keys:

bypassing drm wmv ,drm bypass wmv,bypass media drm,bypass drm wmv,bypass drm wma,bypass drm video,bypass drm on dvds , Bypass DRM Video

Source by dvdvideo

    Bypass bypass DRM video from license protected video music files and Convert DRM Protected Music Video files WMA WMV M4P M4V M4A

    Most of the protected video and music downloaded online like Windows Media Player iTunes, Rhapsody, Napster, Bearshare , Spiral Frog are all DRM files.

    What is DRM? Why do we bypass DRM from WMA, M4P, WMV, M4V, M4A, etc?

   DRM (Digital Rights Management) – The anti consumer copy protection that prevents you from using music or movies in a way that suits you.
   For example, if a DRM WMA or DRM WMV you downloaded from WMP(windows media player) that has windows DRM, you can only play it back on a compatible device, so if every piece of music had windows DRM on it you would need to buy the same track on CD to listen in your CD player or car, as an iTunes download to play on your iPod, as a ms store download to play on your Zune etc, but since you paid for it once you shouldn’t be forced to pay for it again and again, remove windows DRM and you can play it on your phone, iPod, Zune, PSP, CD player, pc, and anything else that you can listen to music on.

A few methods listed below:
1. Burn and rip
  Actually, there is a common free method to bypass DRM WMA, M4P with 2 steps:
    Step 1 Burn DRM WMA, M4P to CD. (need a CD burner, like DVD Copy)
    Step 2 Rip the DRM WMA, M4P from CD to your computer as MP3 format , then the DRM should be removed from the WMA files. ( need a CD ripper, like Daniusoft DVD Ripper)

    But it’s not very convenient that may wear out your CR-ROM, and It also needs a blank CD, a CD burner and a CD ripper to help you.

    This is only possible when the software that plays these DRM-restricted audio files allows CD-burning. Some software products simplify and automate this burn-rip process by allowing the user to burn music to a CD-RW disc or to a Virtual CD-R drive, then automatically ripping and encoding the music, and automatically repeating this process until all selected music has been converted, rather than forcing the user to do this one CD (72-80 minutes’ worth of music) at a time.
    Software such as: Share DRM Music and NoteBuner can bypass DRM in this way.

 
2. Re-record
    One of the most common and simple technology is recording the DRM WMA and DRM WMV then use an ordinary converter to convert the recorded and unprotected files. Because this technology is easy to realized and easy to support more DRM formats besides DRM WMA and DRM WMV it is welcomed by most of the DRM converters . Software such as SoundTaxi and Tunebite use what is re-record DRM music tech to bypass DRM.

    Use this software to record the signals being sent through the audio or video cards, or to plug analog recording devices into the analog outputs of the media player. These techniques utilize the so-called “analog hole”. SoundTaxi can do that in this way. It is very fast to convert your DRM protected music and video.

    But there are some disadvantages for those programs.
    1. The conversion speed won’t get much improvement due to the long recording process.
    2. Much audio and video quality could be lost during the recording process.

  
3. Hook
    Hook is another new and more complicated technology which can be used to remove Windows DRM. Comparing with Re-recording software, these sorts of programs have much higher conversion speed, but it’s hard to make it support some DRM formats with new and lofty encryption techniques.
     Daniusoft was one of its supporters. After giving a test for some free trials you will find it’s very easy to remove DRM from WMV WMA and other protected music video files with Daniusoft Media Converter Pro, it can remove DRM protection legally and convert other video & music even HD video in high quality. It’s the best bypass drm video methods listed.

    Here are key functions of Daniusoft Media Converter Pro

    1.DRM remover
    Legally remove DRM WMV/WMA/M4P/M4V/ASF… using record technically process which records play and saves the recordings in unprotected digital formats

    2.Video Converter
    Convert all popular video: MP4, MPG, MPEG, 3GP, RM, RMVB, DAT, MOV, FLV, AVI, Xvid, VOB, MKV

    3. HD video Converter
    Support convert high-definition video: M2TS, TP, TRP, TS, AVI

    4. Audio Converter
    Convert any audio files between MP3, WAV, M4A, WMA, OGG, AAC, APE…

    You can free download the DRM Remover to have a try:

Simple steps for conversion:
1. Add DRM WMV , DRM WMA, iTunes M4P and other protected files.
2. Choose the output format you need
3. Pressthe “Start” button.

And the other method you can make a try :  Many software programs have been developed that intercept the data stream as it is decrypted out of the DRM-restricted file, and then use this data to construct a DRM-free file.
These programs require a decryption key. Programs that do this for DVDs, HD DVDs, and Blu-ray Discs include universal decryption keys in the software itself. Programs that do this for TiVo ToGo recordings, iTunes audio, and PlaysForSure songs, however, rely on the user’s own key ?that is, they can only process content that the user has legally acquired under his or her own account.

Chapter Keys:

bypassing drm wmv ,drm bypass wmv,bypass media drm,bypass drm wmv,bypass drm wma,bypass drm video,bypass drm on dvds , Bypass DRM Video

Source by dvdvideo

Outlook 2010 can manage all your email accounts. This gives you a single interface for working with all your messages. There are two aspects to making this happen. The first is knowing how to configure Outlook for Gmail or whichever service you are using. Unfortunately, I don’t have enough space here to cover how that works. The link at the end of this article will take you to a site that does have all the information.

The second aspect is knowing how to work with the different accounts once you have them set up. This article covers those basics.

When you Receive Messages

You can receive messages from various different types of accounts. Outlook 2010 automatically checks each email account for you, based on the settings in your Send/Receive groups. Messages end up in different spots depending on the type of account. Typically, messages from Gmail and Hotmail accounts will end up in their own mail folders, while messages from other types of accounts end up in the Inbox.

So how do you know which messages are associated with which accounts? The messages that end up in their own set of folders are easy. For other types of accounts, if you can’t tell just by looking, you can look at the To: field of the message. The email address the sender addressed it to appears on that line.

When You Send Messages

When sending messages, you control which account Outlook 2010 uses. Outlook always has a default account for sending messages, but you can tell Outlook to use a different account like this:

• When you create a new message, Outlook 2010 assumes that you want to send the message from the email account you are working in right now. This is a change from earlier versions, which assumed you wanted to send from the default account.
• When you’re replying to a message you received, Outlook uses the same account as the message by default. But you can always tell Outlook to send the reply using a different account.
• When you forward a message, Outlook handles it the same way as a reply.

So how exactly do you tell Outlook 2010 to use a different account? You do it when you are working in the message window. Look for the “From” button next to the “Send” button (this only appears if you have more than one account set up). Click From and select the account you want to use.

Set the Default Account

If you want to change Outlook’s default account, here’s what you have to do:

1. In the Ribbon, click the File tab.
2. In the menu that appears, click Info to display the “Account Information” screen.
3. Click the Account Settings button and select Account Settings… in the menu that appears. This opens the “Account Settings” dialog box to the “E-mail” tabbed page.
4. In the box that contains the list of email accounts, select the account you want to use as the default account (the current default account has a checkmark in a blue circle next to it).
5. If the account you selected is not already the default account, the “Set as Default” option (located above the box containing the email accounts) should now be clickable. Click Set as Default to change the default account.
6. Click Close to return to the Outlook window.

You now have the basic information you need to work with multiple email accounts in Outlook 2010. All you need now is solid instructions for connecting accounts to Outlook.

Source by Bill Mann

Is your computer running extremely slow? If you are having a slow computer while you have no plan to purchase a new one but want to speed it up, this is the right article for you to free fix your slow computer. It doesn’t matter what operating system is running on your computer. You can follow the 4 tips to free fix your slow computer instantly.

1. Detect any virus, trojan, malware has hidden on your computer. This is the most important and earliest thing you have to do. Just make sure your computer is safe without implanted virus or affected files. You need to isolate the affected files with other datas on your computer as soon as possible. Virus, trojan, malware will absolutely slow down your computer and even crash the whole system.

2. Remove those useless programs, applications, games in order to release more hard space for your slow computer. Too many programs, applications installed on the computer also will slow your computer down because they occupy much hard space and computer memory. Your system needs more time to respond every operation you have done. That is why you frequently encounter such phenomenon that your computer is deathly slow and nerver responds you.

3. Defragment the system to improve slow computer speed. How many years has your computer served for you? If you never clean the fragment from the moment when you start using your computer, you would get a slow computer after a few of years. Every operating system has own its defrag function so that PC users can remove system fragment with it. Therefore, you can use defrag on your computer to free fix the slow computer.

4. Run a free registry scan to find out and repair registry errors on the slow computer. Most of the slow computer problems are related to registry. Too many invalid, missing and rubbish registry will affect the computer speed and slow it down. Your slow computer keeps freezing because of the registry errors. To be honest, registry errors is unavoidable because you have to install, uninstall applications, games, programs on your computer frequently. That will change and leave invalid registry entries sometimes will destroy registry keys. So you need to clean up the registry errors regularly. Free registry scaner could help you detect and repair those registry errors in just a few of minutes.

If you are not an expert to fix slow computer problems. I sincerely suggest you download some PC repair tools to detect and fix errors on your computer so that you don’t need to repair PC problems manually. In fact, most of the repair tools are multifunctional and also contain the rescue methods I introduce above.

Are you getting a slow computer? I highly recommend you try to use registry repair tool to optimize and protect your computer regularly. You can download the free trial to scan your computer for free from now on.

Source by Alex

Is your computer running extremely slow? If you are having a slow computer while you have no plan to purchase a new one but want to speed it up, this is the right article for you to free fix your slow computer. It doesn’t matter what operating system is running on your computer. You can follow the 4 tips to free fix your slow computer instantly.

1. Detect any virus, trojan, malware has hidden on your computer. This is the most important and earliest thing you have to do. Just make sure your computer is safe without implanted virus or affected files. You need to isolate the affected files with other datas on your computer as soon as possible. Virus, trojan, malware will absolutely slow down your computer and even crash the whole system.

2. Remove those useless programs, applications, games in order to release more hard space for your slow computer. Too many programs, applications installed on the computer also will slow your computer down because they occupy much hard space and computer memory. Your system needs more time to respond every operation you have done. That is why you frequently encounter such phenomenon that your computer is deathly slow and nerver responds you.

3. Defragment the system to improve slow computer speed. How many years has your computer served for you? If you never clean the fragment from the moment when you start using your computer, you would get a slow computer after a few of years. Every operating system has own its defrag function so that PC users can remove system fragment with it. Therefore, you can use defrag on your computer to free fix the slow computer.

4. Run a free registry scan to find out and repair registry errors on the slow computer. Most of the slow computer problems are related to registry. Too many invalid, missing and rubbish registry will affect the computer speed and slow it down. Your slow computer keeps freezing because of the registry errors. To be honest, registry errors is unavoidable because you have to install, uninstall applications, games, programs on your computer frequently. That will change and leave invalid registry entries sometimes will destroy registry keys. So you need to clean up the registry errors regularly. Free registry scaner could help you detect and repair those registry errors in just a few of minutes.

If you are not an expert to fix slow computer problems. I sincerely suggest you download some PC repair tools to detect and fix errors on your computer so that you don’t need to repair PC problems manually. In fact, most of the repair tools are multifunctional and also contain the rescue methods I introduce above.

Are you getting a slow computer? I highly recommend you try to use registry repair tool to optimize and protect your computer regularly. You can download the free trial to scan your computer for free from now on.

Source by Alex

 We have seen in the earlier Article Microsoft Excel and Automation that with a simple Macro Statement we could transfer control to a particular area of Worksheet very quickly, when several Worksheets are there in a Workbook. We have designed a Control Sheet and a Control Data Sheet to store the user’s choices and use those values for running the Program.

Excel Macros can make our work easier by automating several tasks like Print Previewing or Printing of Worksheets, hiding all worksheets except the one that we are working on, transfer data from other worksheets to a specific range linked with the Graph Chart so that the Chart changes dynamically and no need for creating several Charts across sheets and so on.

We can bring in lot of improvement in that example Workbook that we have created earlier and in this Article we will concentrate on a simple issue, specific to what we did with the earlier macro. We have seen that we can transfer control to a particular worksheet among several worksheets in order to avoid scrolling sheets to the right to find the specific sheet location that we want to work with. If you have tried that example, then a Question is already on your mind that how do we pass control back to the Control Sheet, without clicking on the Tab Scrolling Buttons?

Since, we have transferred control with a macro we need another macro to bring the control back to Main worksheet where we have designed the List boxes and Command Button for automation. But this macro we cannot run from the Main Control Sheet. We will run it conveniently from a Toolbar Button above. We need to create a custom Toolbar Button and attach the new Macro to the Toolbar Button. But, the new Toolbar Button will remain in the machine where you will create it. If the same workbook is open in a different machine the Button will not be available there, but we can make the Custom Toolbar Button to travel with the Workbook so that it can be used in any machine.

First we will write a Macro and then go for the Custom Toolbar Button creation.

1. Select Tools – -> Macros – -> Visual Basic Editor.

2. Click on the Project Explorer Toolbar Button (or press Ctrl+R) to split the Visual Basic Editor window into two. Left side panel will list the Worksheet names and the right-side window is for VBA Code editing. Check the left side panel under the heading This Workbook shows a Folder with the name Modules. If you are using the same workbook that you have created for the earlier example then this will be there. If the Module Folder is there then double click on the VBA Module below that to open up the VBA Code Editing window. If the Module Folder is not there then select Insert – -> Module to insert a Global VBA Module.

3. Click on the Code window at the right side and select Procedure from Insert Menu.

4. Type the Name GotoControl in the Name control and select Sub in the Type Category.

5. Select Public in the Scope choices.

6. Click OK to insert the empty Procedure skeleton in the VBA Window.

7. Type the following Macro Statement without making mistakes in the middle of the two lines. See that you are keying in a period (.) between the right parenthesis and the word select.

Worksheets ("Control") .select

1. Select View – -> Toolbars – -> Customize.

2. Select the Toolbars Tab (if it is not the current one)

3. Click New to create a new Empty Toolbar and type a Name (say myToolbar) in the Toolbar Name control and click OK. An Empty Toolbar will show up, look for it if you could not spot it. It may appear anywhere within the Excel Application Area. You may drag and place it among the existing Toolbars above.

4. Click on the Commands Tab on the Customize dialog control.

5. Click on File in the Categories List and Click New…

6. Right-Click on the Button and type &Go2Ctrl in the Name Control.

7. Select Text Only option in the displayed menu. The Name Go2Ctrl appears in the Button face.

8. Click on the Assign Macro to display all the existing Macros available and among them you will find the GotoControl that we have created, click on it and Click OK and Close the Customize Dialog Control.

9. Now we are ready to test our creation. Click on the Go2Ctrl Toolbar Button and you will be placed on the Control Worksheet.

10. Click on the GotoCommand Button after selecting a Worksheet and Month from the List to transfer control to that sheet.

11. Try clicking again on the Go2Ctrl Toolbar Button to jump the control back to the Main Worksheet.

Now, we need to make one more change for the Toolbar to travel along with the Workbook to other machines.

1. Select View – -> Toolbar – -> Customize.

2. Click on the Attach…Button.

3. You will find Custom Toolbars List at the left-side panel. Select myToolbarfrom the list and Click CopyButton to make a copy to the Toolbars in WorkbookList.

4. Click OK to Close the Customize dialog box.

If your Excel File can be put on a Network Drive then you can try opening it from a different Machine. The Custom Toolbar with the Go2CtrlButton will come along with the Workbook on that machine also.

a.p.r. pillai

http://www.msaccesstips.com

Source by Ramachandran Pillai

 We have seen in the earlier Article Microsoft Excel and Automation that with a simple Macro Statement we could transfer control to a particular area of Worksheet very quickly, when several Worksheets are there in a Workbook. We have designed a Control Sheet and a Control Data Sheet to store the user’s choices and use those values for running the Program.

Excel Macros can make our work easier by automating several tasks like Print Previewing or Printing of Worksheets, hiding all worksheets except the one that we are working on, transfer data from other worksheets to a specific range linked with the Graph Chart so that the Chart changes dynamically and no need for creating several Charts across sheets and so on.

We can bring in lot of improvement in that example Workbook that we have created earlier and in this Article we will concentrate on a simple issue, specific to what we did with the earlier macro. We have seen that we can transfer control to a particular worksheet among several worksheets in order to avoid scrolling sheets to the right to find the specific sheet location that we want to work with. If you have tried that example, then a Question is already on your mind that how do we pass control back to the Control Sheet, without clicking on the Tab Scrolling Buttons?

Since, we have transferred control with a macro we need another macro to bring the control back to Main worksheet where we have designed the List boxes and Command Button for automation. But this macro we cannot run from the Main Control Sheet. We will run it conveniently from a Toolbar Button above. We need to create a custom Toolbar Button and attach the new Macro to the Toolbar Button. But, the new Toolbar Button will remain in the machine where you will create it. If the same workbook is open in a different machine the Button will not be available there, but we can make the Custom Toolbar Button to travel with the Workbook so that it can be used in any machine.

First we will write a Macro and then go for the Custom Toolbar Button creation.

1. Select Tools – -> Macros – -> Visual Basic Editor.

2. Click on the Project Explorer Toolbar Button (or press Ctrl+R) to split the Visual Basic Editor window into two. Left side panel will list the Worksheet names and the right-side window is for VBA Code editing. Check the left side panel under the heading This Workbook shows a Folder with the name Modules. If you are using the same workbook that you have created for the earlier example then this will be there. If the Module Folder is there then double click on the VBA Module below that to open up the VBA Code Editing window. If the Module Folder is not there then select Insert – -> Module to insert a Global VBA Module.

3. Click on the Code window at the right side and select Procedure from Insert Menu.

4. Type the Name GotoControl in the Name control and select Sub in the Type Category.

5. Select Public in the Scope choices.

6. Click OK to insert the empty Procedure skeleton in the VBA Window.

7. Type the following Macro Statement without making mistakes in the middle of the two lines. See that you are keying in a period (.) between the right parenthesis and the word select.

Worksheets ("Control") .select

1. Select View – -> Toolbars – -> Customize.

2. Select the Toolbars Tab (if it is not the current one)

3. Click New to create a new Empty Toolbar and type a Name (say myToolbar) in the Toolbar Name control and click OK. An Empty Toolbar will show up, look for it if you could not spot it. It may appear anywhere within the Excel Application Area. You may drag and place it among the existing Toolbars above.

4. Click on the Commands Tab on the Customize dialog control.

5. Click on File in the Categories List and Click New…

6. Right-Click on the Button and type &Go2Ctrl in the Name Control.

7. Select Text Only option in the displayed menu. The Name Go2Ctrl appears in the Button face.

8. Click on the Assign Macro to display all the existing Macros available and among them you will find the GotoControl that we have created, click on it and Click OK and Close the Customize Dialog Control.

9. Now we are ready to test our creation. Click on the Go2Ctrl Toolbar Button and you will be placed on the Control Worksheet.

10. Click on the GotoCommand Button after selecting a Worksheet and Month from the List to transfer control to that sheet.

11. Try clicking again on the Go2Ctrl Toolbar Button to jump the control back to the Main Worksheet.

Now, we need to make one more change for the Toolbar to travel along with the Workbook to other machines.

1. Select View – -> Toolbar – -> Customize.

2. Click on the Attach…Button.

3. You will find Custom Toolbars List at the left-side panel. Select myToolbarfrom the list and Click CopyButton to make a copy to the Toolbars in WorkbookList.

4. Click OK to Close the Customize dialog box.

If your Excel File can be put on a Network Drive then you can try opening it from a different Machine. The Custom Toolbar with the Go2CtrlButton will come along with the Workbook on that machine also.

a.p.r. pillai

http://www.msaccesstips.com

Source by Ramachandran Pillai