Dummy Excel
Well-known Member
- Joined
- Sep 21, 2005
- Messages
- 1,004
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
Hi,
Im a little rusty with VB, as I haven't used in quite sometime, so please bear with me!
im trying to open a file and using the below code:
although when i run the code line by line ie F8, it jumps head after it reaches line "Workbooks.Open (H)"
why is that?
is there a better way to open an external file these days?
thanks
Sam
Im a little rusty with VB, as I haven't used in quite sometime, so please bear with me!
im trying to open a file and using the below code:
Code:
'Opening Monthly Summary Report
MsgBox "Please Open Monthly Summary Report", vbOKOnly, "Monthly Summary Report"
H = Application.GetOpenFilename("Excel Files (*.xlsx),*.xlsx")
Workbooks.Open (H)
RawData = ActiveWorkbook.Name
why is that?
is there a better way to open an external file these days?
thanks
Sam