Search results for query: *

Hi All I have a business user that wants to look at pivot tables (since it is organized) and we have a comments field to the right, where the user can input comments to a particular field. The pivot table (its formatted but displays all the raw data) can be refreshed/filtered very quickly but...

Hi All I have several tables that helps me try to capture the unique number of vendors that are active from the users table as shown below in the SQL script. However, ther is an exception where users may be associated with multiple vendors. I feel that my script captures all associated vendor...

Hi All I have several tables that helps me try to capture the unique number of vendors that are active from the users table as shown below in the SQL script. However, ther is an exception where users may be associated with multiple vendors. I feel that my script captures all associated vendor...

Hi All I have locked off my macros if the user goes to VB editor. Is there a way to prevent the user from seeing the macro names when they go to Tools -> Macros? Thanks for your help Gautam

Hi All Everytime a user of a customized template does a drag and drop, it takes away the format of the cell. Is there a way to disable the drag and drop for the user? Thanks Gautam

Hi I would like my MS Excel template to display announcements that I store on a web server. I have created two dummy cells (hidden from the user). If cell B1 has changed value, a message box pops up displaying that the announcement. Then A1 is set to B1. Ideally, I would like a macro that...

Hi All I would like the user to manually enter the data, use the drop down list box or externally reference the data but I do not want the user cutting and pasting since it would change hte format of the template (ie colors, borders etc). 1) Is there a way of allowing them to cut and paste...

Hi how do I change the color of cell (for example green) when the contents are either inputted through a copy and paste from another worksheet. Thanks for all your help!!! Gautam PS I am using this function, which does not seem to work :(: Private Sub Worksheet_Change(ByVal Target As Range)...

Hi All I am using a template in MS Excel as a secure tool. The security will be authenticated from the client side as opposed to the server side. I have the user fill their username and password in a userform. This username and password is sent to a URL which displays XML data. If an element...

Hi All I want to store some xml data in a web server. The xml data is formatted and created in MS excel. I want excel to send the data to a webserver. I have an issue with two things: what is the command to send data? and to log on the webserver, i have to login..is there anyway to...

Hi All I was wondering anyone knows what are the standard project libaries you get with the following versions of MS XL: Microsoft Excel Version 97 Microsoft Excel 2000 Microsoft Excel 2002 Microsoft Excel 2003 The ones that I am concerned with are: Visual Basic for Applications Microsoft...

Hi I was wondering if VBA in XL can check if a URL exists? Can VBA also check the XL user is connected online. If so, how. Please let me know if this is possible? Thanks Gautam

Hi all I have used the following code : Private Sub Workbook_Open() UserForm1.Show End Sub My userform1 does not display. Do I need to change any settings anywhere? Thanks for your help. Gautam

Hi All I can read an XML file from a web browser (for user& password verifcation for online users) but I would like to read in the contents from a particular element. Here is my attached code and the XML file: Sub connectToHTTP() Dim xml Set xml = CreateObject("Microsoft.XMLHTTP") '...

Hi All A brief background - my tool uses VBA and converts the data to XML prior to it being accepted in SAP. My tool is a demo and uses an Acces table to verify username and password prior to the data being sent. However, in a more realistic case, I would like to make a webcall to our web...

Hi All i am trying to call a variable from a private sub to a public sub. I was wondering if there is a particular syntax/ get or set functions that i need to do so. For example I need to bring a combobox.value from a private sub to a public sub. Thanks for your help. Cheers Gauta

Hi i created a combobox that has 8 values. however, I do not want the user to input their value on the combobox and I want to keep a dropdown menu (that is why i didnt go with a listbox). Please let me know if there is a way to do this. Thanks for your help Regards Gautam P.S Below is my...

Hi All I figured out how to connect Access to Excel as shown below. However, how would i go about executing the SQL statement that compares an excel entry in cells d1 and e1 to a that of a table in Access and then imports that section from access. What would be the appropriate syntax to put...

Hi All How do I link an access table to Excel. I want the user to input a userid and password (that is currently hardcoded) and compare it to the ids and passwords in MS Access before allowing the user to submit the data. Any suggestions will be much appreciated. Thanks for your help...

Hi All I want to check a range of values (Range B9:F9) to see if they are empty or not-numeric. I have attached my code from below which shows that it works for just range B9. I tried several variations of the code but couldnt get it working. Please let me know if there is something I am...