Stack Overflow
Stack Overflow

Questions tagged [excel-4.0]

54 questions
24
votes
10 answers

Excel issue "excel 4.0 function stored in defined names"

I am trying to isolate the issue causing Excel 4.0 function stored in defined names.
Ayusman
  • 8,509
  • 21
  • 79
  • 132
13
votes
4 answers

ExecuteExcel4Macro to get value from closed workbook

I found this bit of code and thought it might be good to use if I just need to pull one value from a closed sheet. strInfoCell = "'" & strPath & "[" & strFile & "]Sheet1'!R3C3" myvalue = ExecuteExcel4Macro(strInfoCell) When I run this code I get a…
DevilWAH
  • 2,553
  • 13
  • 41
  • 57
6
votes
4 answers

Convert Excel 4 macros to VBA

I have an old Excel 4 macro that I use to run monthly invoices. It is about 3000 lines and has many Excel 5 Dialog Box sheets (for dialog boxes). I would like to know what the easiest way would be to change it into VBA and if it is worth it. Also,…
Robert
  • 61
  • 1
  • 2
5
votes
1 answer

ExecuteExcel4Macro, path containing an apostrophe

This will be my first question on this site, so bear with me. So, I am trying to utilize the ExecuteExcel4Macro function, to reference a value in a different workbook, without having to open the workbook, as it will have to loop through a lot of…
Vulthil
  • 738
  • 4
  • 10
5
votes
1 answer

How can I reverse engineer a (deprecated) Excel V4 macro?

I have been tasked with figuring out that this does. I haven't seen this type of language/formulas before and when I browse the web for these formulas I can't seem to find any concrete definitions as to what each function does. There are 3 sheets to…
millsofmn
  • 301
  • 3
  • 12
4
votes
2 answers

Reading data from Excel file prior to version 95

Apparently Excel 4.0 is still used and I have to read it in Java. Neither poi nor jExcelAPI, as great as they are, can parse them. I can't find anything on them, especially with Java. Any help?
pitr
  • 715
  • 1
  • 8
  • 25
3
votes
1 answer

What does the FORMULA.FILL function do in Excel 4 Macros?

I'm translating some functions written in Excel 4 XLM macros into VBA. One of the functions called within the macro I'm currently translating is FORMULA.FILL. I cannot seem to find any documentation of what this function does. Could anyone provide…
called2voyage
  • 252
  • 9
  • 28
3
votes
2 answers

Cannot see excel sheet in VBE

I am working with an Excel file that was created by somebody else. One sheet containing Macros appears to be password protected, but what I don't understand is that I cannot see it in VBE under the sheet list. The sheet tab is visible in Excel, but…
user2024631
  • 31
  • 1
2
votes
2 answers

Grab formulas from closed Excel file (not just values)

I'm able to grab values from a closed workbook with the widely found GetValues function; it works great. But sometimes I need to grab the formula of a cell from the closed workbook. I tried modifying GetValues to grab the cells formula but I'm…
Stay-at-home-dad
  • 876
  • 3
  • 12
  • 27
2
votes
3 answers

Why is the return result of ExecuteExcel4Macro always False?

While using ExecuteExcel4Macro to run a Excel macro in Python, I always get the False result, here is the code executed: import win32com.client filename = r'E:\excel.xls' xlApp = win32com.client.Dispatch('Excel.Application') xlApp.visible =…
RussellLuo
  • 155
  • 2
  • 9
2
votes
1 answer

How to identify Excel 4.0 Macro?

We were trying to Sign an Excel Macro, but got an error that it contains Excel 4.0 Macros and hence it can't proceed to sign them. MSDN says it won't allow Excel 4.0 Macro's but we couldn't find ways to identify Excel 4.0 Macros. How to identify if…
Pravin
  • 1,059
  • 8
  • 17
2
votes
0 answers

Get value from closed Excel workbook via HTTP link

I have a bunch of Excel workbooks that are stored on a shared online directory (kind of like Dropbox) in different folders. I am creating a master workbook to pull values from these Excel workbooks into a summary. While testing I've managed to…
dknt
  • 21
  • 2
2
votes
1 answer

Excel VBA XL4 Application Level Defined Name

Defined Names are normally defined at the worksheet or workbook level. But it is also possible to define them at the Application level using an old xl4 macro call. They thus become a place to store state that does not get reset when a VBA project is…
Tuntable
  • 3,276
  • 1
  • 21
  • 26
2
votes
1 answer

Excel C API: Is there an Excel v4.0 macro function to test if a sheet is hidden?

I need to find out if a sheet is hidden using an Excel 4 macro function / Excel SDK, preferably getting XlSheetVisibility value (i.e. xlSheetHidden, xlSheetVeryHidden, xlSheetVisible). I would expect this kind of query to be possible by…
Kemal
  • 849
  • 5
  • 21
2
votes
1 answer

What does "=EMBED("Forms.CheckBox.1","")" do for checkboxes?

I have an Excel sheet with a large amount of checkboxes. I copy and pasted the checkboxes around. In the formula bar, every single one of them has =EMBED("Forms.CheckBox.1","") What is the significance of this? What does it do to the checkboxes?
Stanfrancisco
  • 352
  • 1
  • 7
  • 24
1
2 3 4