EXCE 2003 VBA:
trying to call this function from cell b2 . needing the information from cell d2 and on down.
keep getting #name?
I would like to get this macro to repeat all the way to the end of a large document that I am doing some statistical analysis of - I am trying to make a single column of letters to bring into ...
see attached workbook........
Hi Experts
Need a macro to check if the user exist when they click the workbook icon on the desktop.........(i have already done the log-in form...User_Log_In...
I have a spreadsheet that when it opens I want to have a few columns with drop downs. The data from the drop downs has to come from SQL because the data changes hourly. I want to have the drop...
see attached workbook.......
Hi Experts
Need a msg to appear if the user doesn't select one of the username's from the drop down list and clicks okay want to catch the error and ask them ...
Hi all,
I have created a spreadsheet with macros in 2003 and when I e-mail to colleagures with 2007 the macros don't work!
Does anyone have a clue how to get resolve this.
Thanks
see attached workbook
Hi Experts
Just need to add a function to the Add New User macro sequence. Currently when you add a new user the macro works fine and prefectly.
Just one problem ...
see attached workbook
Hi experts
Need the macro to do the following, but yo have to follow the sequence to understand the point/problem to hand.
1. Goto worksheet "Daily commmunication...
I have a date in cell J2 that is formatted MM/DD/YYYY which is they way I need it.
but in cell J3 I have an invoice number that uses part of the date.
So for example I have 28704L as the fir...
I have an Excel formula which goes like
=A1&"something with more quotes"&B1
it refused to accept the format due to the embbeded ". I added \ to escape the ", but it did not work.
what...
see attached file
Hi Experts
Need to add a message to the userform in worksheet "Administrator". When the user clicks the tab to gain access to the worksheet and then teh userform opens u...
Hi, this is pretty unusual in that I dont have access to all the code.
I have about 20 excel files. In each file there is a macro that needs to be run. what I have to do is:
open file1, run ...
I have an excel worksheet with 40000 rows. About 1000 cells in one column (field) have green triangle markers in the top left corner - this indicates the data is in text format or is preceded ...
I am currently trying to use the sample provided by Lebans
http://www.lebans.com/reporttopdf.htm
....but the only part I need is just the code below such that the file excel filename cre...
I somehow hid columns A - E in an Excel sheet and I can't figure out how to get them back. Attached is a copy of the document with the info removed since its work stuff. Could someone please...
Good Afternoon
I am using the following code, called from a button which just calls: Max, I was hoping to stop the screen updating and thought Application.ScreenUpdating = False was the cod...
How do I reference this csv doc so that the identified range will be copied? Assuming that a csv doc will know what to do with End(xlDown).
Thanks!
John
I would like to add a new command button to the toolbar in Excel for example the Standard Toolbar. When I click on it, I would like VB.NET to handle this event and display a msgbox.
Question...
hello to the expert,
I have a connection that work for load data, addnew & edit but not for delete.
see attached error file
Dim sql As String
Dim DBcn As ADODB.Connection
Set DBcn =...
I've got a 25 sheet workbook. When I set the print properties on one sheet it does not apply to the others. Why?
I currently working on a excel spreadsheet that is using numbers to calculate a score.. The numbers map to a legend and I would like to use the label to be represented in the overall score or ...
Hi All,
I need your assistance. I have Column B with data exported from an Access database however I cant remove the ' or the space after '. Sometimes there are 3 o 4 spaces aftert the ' ....
average tenor is 2.3, that is greater than tenor 2 but less than tenor of 3, the value for 2.3 needs to be interpolated between
1.85 and 1.6 for the fraction of .3. That is, the value for fra...
hi!
I have the following spreadsheet:
columna columnb columnc columnd
1 AAAA BCBCBC xyxyxy
1 ...
My code will save file in current directory path and now I will like to add two additional function.
(1a). Scan to see if a subdirectory folder "Excelfolder" exist in the current path, if i...
