Search results

Is there a way to determine the data type of the contents of a cell and then use the data type as a condition for an "If" statement ? If so, could someone point me in the right direction? Kind of like : If ActiveCell.Type is Integer Then .... End If I know the "ActiveCell" object doesn't...

I want to assign the Column and Row number of the active cell of a worksheet to variables (Cnum, Rnum) but I can't find the right syntax I was thinking it would be something like: "Cnum = ActiveCell.(This is the part I don't know) Could somebody enlighten me?

Thanks That puts me one step closer

I am using Office 2003. I am trying to backfill data into an Access DB that somebody else developed from an Excel worksheet. I do this on other DBs I created using a routine I developed with the help of several people on this forum. (Thanks again) I use a line of code like: DBS!ShtNum =...

I work for a global company. I wrote some VB to support some Excel files generated by SAP for the bean counters in the US use to create reports. Now I have people in Europe, Asia etc. interested in using this report generator, but all the currency is in $US. Understandably, people in other...

That is Exactly what I was looking for. You top the list of people who have helped me with this project and with my journey into the development environment

I have written a rather large set of VB Scripts for an Excel spreadsheet that compiles a report from several source files generated from SAP. Over the last few months I have relied on many of the people in this forum to point me in the right direction and help me overcome hurdles. First let me...

Thanks As always Bob ...and Holger, you're a tremendous help to us newbies.

Tell me More. In this case, I do not need to use a column letter as a designator. But for futute consideration, how do you convert a numeric expressions to a string? I assume it requires more than defining the variable as a string type.

I want to go through a table row by row and, when a condition is met, Highlight a range of cells in that row. (RowX,1) through (RowX,34) I can select the entire row (Row 1) or a specific Range (A1:A34) but I can't get the syntax right for a range described with a variable. Can somebody out...

This worked Great, Thanks!

Looks Like what I need This looks like what I need I will try it first thing tomorrow. Thx

I want to verify that a worksheet with a specific name does not already exist prior to creating that worksheet. Searching through past threads I see that ASAP utilities would probably help do this, but since the people using this spread will not have this add-in I would like to find a way...

Followup ? Importing the data from the html file eliminates the data type issue. But I need to automate this for the end user. I recorded the following Macro todo this, but I would like to modify the section in bold so that a browse window is opened. I Know I need to put something like...

Followup ? Importing the data from the html file eliminates the data type issue. But I need to automate this for the end user. I recorded the following Macro todo this, but I would like to modify the section in bold so that a browse window is opened. I Know I need to put something like...

More I just tried to bring the data in using Data>Import and the data worked fine in Calc's....Weird!

I need to import SAP data in an HTML file into Excel, but there seems to be a data type issue. When I select a cell I get the value of the numbers in the cell, but if I try to use the cells in a calculation, or try to Sum etc. the cells, I get a value of zero or the "#VALUE!" error. The Data...

Reply I was able to display the additional fields in the folder, thinking I could use the Comments field for the other information, but I can't figure out how I fill/edit those fields. We are looking for for something less passive than a field in the folder, Like a message box that must be...

My employer has a new records retention policy. We would like to have some basic information display when the project Folder is opened, ...or selected. Is this Possible? I was thinking I could have a file with this data inside the folder with the folder information (Folder Name, Creation Date...

Solution Turns out the problem was with my ISP. Once they got their issues "cleared up" everything started working again. One of those rare times when an IT problem was resolved by doing nothing