| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Value Message, Getting Data from Other Excel File
I have a Excel spreadsheet that I have exported from Crystal Reports so
that I can add more data and perform some calculations. I have written VBA to do all of this but when I open the Excel and launch the macro I get this Update Value message and have to open the linked Excel file for each reference to it in the VBA. Everything works just fine AFTER you open the file 48 times!! What can I do so that the user just opens the spreadsheet runs the macro and gets the completed spreadsheet? TIA, Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to pull data from another file - update name of file | Excel Discussion (Misc queries) | |||
| Excel Links don't update error message even if it really does upda | Excel Discussion (Misc queries) | |||
| i want to update one excel file the other one update automaticaly | New Users to Excel | |||
| update data from one excel to another excel file | Excel Worksheet Functions | |||
| Getting message can't save all data in excel xls file | Excel Discussion (Misc queries) | |||
Hybrid Mode
