Replies

Thank you, Hans. This works exactly the way I want it to work!!!

When I demonstrate this tomorrow at work, I will most certainly give credit to this forum!!! Again, I can’t thank you enough!!!

Thanks,
–cat

It’s me again … I really have to think of a work-around for this issue …

Givens (things I can’t change but will be changed in the future by this company’s designers/developers):
–A CSV file is created as a pop-up that the user can either OPEN or Save … usually a user wishes to simply open the file
–currently CSV file type is opened with Excel (maybe I can do something here with switches???? )
–If the user has any other setting other then English(United States) as their Regional Setting …
the data is placed all in one column … with the important exception of the ALT+ENTER symbol (multiple lines in one cell)
this comes over as a new row incorrectly. Actually separating the quotes that denote the text field. So, even applying the Data | Text to Columns option in Excel doesn’t work correctly (due to ALT+Enter characters that are missing/forced into new row)

So, I’m thinking that maybe there’s a way to have CSV open with Excel (like it currently does),
–but have Excel automatically open a file that has a macro that does the work for the user after they click a keyboard combination that runs a macro that does:
(1) looks for that place that the special character should be … maybe by trying to count the quote symbols in a cell … if there are not two than do not break the row, and then
(2) do the text to columns using a comma.

But, I want the end user to be able to open the CSV file and simply click, say, CTRL+SHIFT+P, to run the macro, to produce the CSV file that his US counterparts get.

AS always, I really, really do appreciate all the help this forum gives me. I also feel a little guilty cause I know this can be done, and that I could probably learn how and do it, and I do usually do that approach … but, I know that by simply asking this group … I can save a lot of time … I don’t mean to be “using” you guys, but you really do help me a lot!!!

Thanks,
cat

I’ve uploaded an excel file (I couldn’t upload the csv files) … one tab represents what the Finnish user sees (but of course, it is a CSV file not a XLS file) with comments in C3 and J2, and an English tab with comments in J2 cell.

Thanks, Hans.

01/00/00

is the result of a VLOOKUP that finds the row, but the column that it is pulling is blank but formatted as a date.

–cat

Thank you, Hans. That worked! I didn’t even know that I was hiding something!

Thanks, Hans that’s what I needed.

Hi,

I would use this formula:

=C10/(POWER(CONVERT(B10,”in”,”m”),2))

Thanks,
–cat

Woo Hoo !!! That worked. I learned about the Change and the Calculate Event all in one week!!! I think I’m going to like this “Event” vba stuff. (Now I need to tackle the rest of the problem … )

Thank you all!
Cindy

Hi All,

I have re-attached another file.

For the Change procedure to work, does the user need to “manually” change the cells? … Or can the cells be changed by formulas?

Eventually these cells will be formulas (vlookups, indirect, etc) looking at another file, the datafile. The user changes that file, the values change in this sheet. When the values change so that D7=0, I wish to have column D hidden.

Thanks,
–Cindy

Hi, (so glad this is Friday!)

It seems that the Change procedure doesn’t even work … so, I won’t worry about adding it to a new workbook and modifying it, yet.

I have attached the template. Again, I really really appreciate this forum’s help!

Thanks,
Cindy

p.s. I had to change the file from a XLT to a XLS since I couldn’t attach it.

Hi,

The Change procedure does not refer to the sheet’s name (which starts out as “Generic” and gets changed later after it is added to another workbook).

All the Change procedure code does (or should do) is hide column D if cell D7 = 0 and unhides column D if cell D7 0.
I really don’t want to check for changes until the sheet has been added and set up corrected through my other macro. Hence the

I will try to get something to attach … the workbook that creates this file is fairly short, but it calls another workbook that is very large and, unfortunately, just about everything is confidential as I am working for a pharmaceutical company.

Thanks,
Cindy

I’m back …

I’ve placed code in a Change procedure sheet named “Generic” in an Excel Template file. I have another workbook macro that adds the Generic Sheet to the workbook, then proceeds to change the name of the sheet just added. Then, when my program first modifies the sheet, I get this error … “Compile Error – sub or function not defined”. I’m pretty sure it is because the name has changed from “Generic” to the appropriate name.

Is there a way that the Change Procedure can “know” the new name or a way to … I don’t know, get around this?

Thanks,
–cat

Thanks, Hans. I hadn’t thought about putting it in the sheet I add first. Congrats on your 50,000 Post ! I know that I am personally glad that you are around when I have my questions!

About the Change procedure and performance, what type of hit will I take?

Thanks again,
Cindy

Thank you Hans and Legare!

I’m not sure what I would do without this forum!!!
–Cindy

Yes … and make sure A10:A17 are blank, too.

–cat